Skip to main content
Answer

Shipping Address displayed in GI

  • December 4, 2023
  • 6 replies
  • 328 views
S
Jr Varsity III
Forum|alt.badge.img

I need to display the address from the shipping tab on a Custom GI.  Currently i can display the Billing address info without any problems but i am not sure how to display the shpping address.

 

When i inspect the element for the shipping address The data field is AddressLine1, The DataClass is Address,   This is the same thing i see when i inspect the element on the Billing tab.   The only difference is the ViewName.   for the shipping tab the view name is DefLocationAddress.   How do i refer to AddressLine1 for the Shipping Tab in a GI?

 

Best answer by MinushaWeerasuriya76

Please try linking the Customer table to the LocationExtAddress table as shown in the screenshot below. Afterwards, pull the address fields from the LocationExtAddress table.
 

 

Scott Spencer
Laura03
B

6 replies

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+15

Hi @sspencer 

Do you want pull from the customer or Shipment screen?

Acumatica Functional Consultant & Customer Experience Supervisor
S
Jr Varsity III
Forum|alt.badge.img
  • sspencer
  • Author
  • Jr Varsity III
  • December 4, 2023

I need it to pull from the customer

 

Scott Spencer
Laura03
Captain II
Forum|alt.badge.img+19
  • Laura03
  • Captain II
  • December 4, 2023

Hello,

The answer is similar to a case from last week, except

1. Connect Address table with Alias “ShippingAddress” instead of BillingAddress.

  1. Join Customer Table to ShippingAddress Alias table on Shipping Address ID instead of Billing Address as shown here. 

Laura

~ Laura Barber, WM Synergy
Chris Hackett
S
Jr Varsity III
Forum|alt.badge.img
  • sspencer
  • Author
  • Jr Varsity III
  • December 4, 2023

Thanks,  But i am getting an error that says the defSOAddressID is obsolete

 

.

.

.

.

I got this relationship worked out but it is not returning any data from the Shipment tab,  The data columns are blank.

 

Scott Spencer
Laura03
Laura03
Captain II
Forum|alt.badge.img+19
  • Laura03
  • Captain II
  • December 5, 2023

Thanks,  But i am getting an error that says the defSOAddressID is obsolete

 

I showed version 2022 R2 Sales Demo tenant.

If the results are blank, there could be a problem with the join. Please show your relations. Thank you!

Laura

~ Laura Barber, WM Synergy
Chris Hackett
M
Acumatica Employee
Forum|alt.badge.img+1

Please try linking the Customer table to the LocationExtAddress table as shown in the screenshot below. Afterwards, pull the address fields from the LocationExtAddress table.
 

 

B
Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved