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


Rob Moore | Project Manager - Business Warehouse | Edwards
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 Business Quarter, Manor Royal, Crawley, West Sussex RH10 9LW, United Kingdom.

As an Amazon Associate we earn from qualifying purchases.

This thread ...


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.