We manufacture parts for pumps. Some of our customers have a cross reference of their item numbers associated with ours. We are in the process of converting over from Macola/Synergy and some if not most of our items are in Acumatica cloud tables. I am attempting to find where the customers item numbers may be so that is included on an invoice as that is a requirment by the customers.
Solved
Customers item numbers may be different from our stocked item numbers
Best answer by sbond84
You can add the Alternate Id field to your reports.
Therefore, on a Sales Order, you would use SOLine.AlternateID.
Hope this helps!
Sarah
+15Use the Cross Reference Tab on the Stock item (you can use it for Vendor/Customer/Global references you can then search add by this reference
+15
Use the Cross Reference on the Stock Item you can use this to search/add them to documents etc. You can then add InItemXRef table on your form to print the required details.
Dermot Comerford
You can add the Alternate Id field to your reports.
Therefore, on a Sales Order, you would use SOLine.AlternateID.
Hope this helps!
Sarah
If there is an SOLine.AlternateID, should there not be an ARLine.AlternateID, or an AlternateID somewhere in the ARTran table? Not sure if I am looking in the correct place or not, but I feel that I am close.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.