I am working on a GI to pull Customer information. This information will be used to update another system. I have the GI pulling all the information with the exception of the Customer’s SHIP-TO ADDRESS (found on the AR303000 screen under the SHIPPING TAB).
I have tried the Inspect Element function and it shows
I can not figure out the corresponding table and Address ID field to use to pull the Ship-To information.
Thank you for any assistance.
Best answer by jinin
Hi
Can you check with the attached GI?
+15Hi you need to link the Address table to the Customer the defddressID on the customer you can then add the fields you want from the Address table
+11Hi
You can get the information from the ARShippingAddress DAC. Join the ARInvoice. ShipAddressID with ADShippingAddress.AddessID. You will get the data.
+11Hi
Please refer the sample GI.
Thank you for your assistance.
I have added the ARInvoice. and ARShippingAddress tables,
While it does pull the Ship-To Addresses for our Active customers, it doesn’t pull the Ship-To Address for many of the “Inactive” customers. It isn’t pull the Ship-To because these Inactive customers haven’t placed an order since we implemented Acumatica (October 2022). But all of the Inactive customers have Ship-To information on the Customer.Shipping TAB.
+11Hi
Could you please confirm whether you intend to retrieve all customer ship-to addresses from the customer screen or all the ship-to addresses from the invoices?
We need to retrieve all Customer Ship-To Addresses from the Customer Screen,
The end user wants to see the Ship-To Address for all customers Active and Inactive.
Thank you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
