Hi William
It depends whether your looking for open order or invoiced order data.

Open Order data would be in the MBC6REP file like Rob stated.
Invoiced order data would be in the MBF9REP and you may need to link to the
MBDHREP file as well.

Hope this helps. I can send you the exact links if you need them.

Jeff Williams



On Wed, Nov 13, 2013 at 1:15 PM, Moore, Rob <Rob.Moore@xxxxxxxxxxxxxxxxx>wrote:

Hi William
You might try a logical on MBC6REP? The PF doesn't have Customer name but
some of the logical joins do - e.g. MBC6RES9 ?

C6CANB Customer number
C6HITX Alpha sort name
C6CVNB Quote/order number
C6AAYC Order number reference

Regards

Rob Moore | Project Manager - Business Warehouse | Edwards
rob.moore@xxxxxxxxxxxxxxxxx
Edwards Ltd | Registered in England and Wales No. 6124750
Registered office: Manor Royal, Crawley, West Sussex RH10 9LW

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
On Behalf Of Willie J. Moore
Sent: 13 November 2013 17:52
To: mapics-l@xxxxxxxxxxxx
Subject: [MAPICS-L] Help locating data in XA

I have been tasked with setting up a cover letter with the following
information:
Customer Number
Customer Name
PO Number
Order Number

This information would be for this year. The file could be a history file
that I can select year that we want.
I would like to know what file or files I could get this information from.
Hopefully there is one file with this information in it.

Thank you,
William Moore

--
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a
message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/mapics-l.

The contents of this email and any attachments are confidential and are
provided solely for the use of the intended recipient(s). If you are not
the intended recipient, you are hereby notified that any copying,
disclosure, distribution, or use of this e-mail, its attachments or any
information contained therein is unauthorized and strictly prohibited and
you should please contact the sender immediately and delete this e-mail and
any attachments from your system. No responsibility is accepted for any
virus or defect that might arise from opening this e-mail or attachments,
whether or not it has been checked by anti-virus software.
**************************************************************************
Edwards Group Limited is a company registered in the Cayman Islands under
number 266201. The registered office address is c/o Maples Corporate
Services Limited, P.O. Box 309, Ugland House, Grand Cayman, KY1-1104,
Cayman Islands. The Global Headquarters address is Crawley Busin
ess Quarter, Manor Royal, Crawley, West Sussex RH10 9LW, United Kingdom.
--
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.