You will have to read:
MBC6REP (to get open sales orders) and
* join to MBCJCPP (by company/order type/sales order to get the Purchase Order)
* join to MBDEREP (by company/customer number to get the alpha sort name)
And merge MBBWCPP (to get historical sales orders, meaning fully shipped and invoiced). This file contains the Purchase Order and the Customer Name.
Regards
Antonio.
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Moore, Rob
Sent: Wednesday, November 13, 2013 10:16 AM
To: MAPICS ERP System Discussion
Subject: Re: [MAPICS-L] Help locating data in XA
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.
midrange.com
