I’m trying to create a GI to show sales transactions using the ARTran table along with the postal code from the shipping address related to that transaction. What is the best way to connect the SOShippingAddress (where the PostalCode is found) to the ARTran table? Or is there a better way around this?
Answer
How to connect the SOShippingAddress table to the ARTran table
Best answer by BenjaminCrisman
Hi
Here’s what to remember about the different contact tables, the main data is stored in Contact and displayed on Customer/Vendor pages.
You can get the address information by joining Customer and Contact.
SOAddress, ARAddress, APAddress are all related to specifically the address details which appear on the documents from that module, this way you can easily show that the main address is X while the SO document is using Y.
That being said, you are looking to join the SO table to ARTran?
If we start at the ARInvoice and link to ARTran (DocType = TranType, RefNbr = RefNbr) then we have all the ARInformation (though ARInvoice could be replaced with ARRegister). To link to Sales Orders from there I checked the Merged DAC Relations (SM402000):
From SOOrder you can link to the SOAddress
+4Hi
Here’s what to remember about the different contact tables, the main data is stored in Contact and displayed on Customer/Vendor pages.
You can get the address information by joining Customer and Contact.
SOAddress, ARAddress, APAddress are all related to specifically the address details which appear on the documents from that module, this way you can easily show that the main address is X while the SO document is using Y.
That being said, you are looking to join the SO table to ARTran?
If we start at the ARInvoice and link to ARTran (DocType = TranType, RefNbr = RefNbr) then we have all the ARInformation (though ARInvoice could be replaced with ARRegister). To link to Sales Orders from there I checked the Merged DAC Relations (SM402000):
From SOOrder you can link to the SOAddress
Thank you,
But you’re right, I was able to connect the SOOrder table to the SOAddress table and get the information I needed!
Hi
We could join the ARTran, SOOrder and SOLine without causing duplicates with the below limitations.
Limitation: The Sales Order has one Shipment and One Invoice.
Screenshots for reference:
Chandra M
+4Has anyone managed to join the ARTran, SOOrder and SOLine tables without causing duplicates?
Typically, if this type of data is needed to show the necessary data, it’s recommended to use a report where the table causing the duplicates is instead added to a subreport and this is used instead of trying to join all the tables into the same report relations.
Thank you!.
Your comments helped me solve the issue using a different approach.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.