Skip to main content
Solved

Shipping Address displayed in GI

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.
 

 

View original
sroberts29
L
2 people like this
  • sroberts29
    sroberts29
  • L
    Lhouldsworth
Did this topic help you find an answer to your question?

6 replies

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

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
  • 17 replies
  • December 4, 2023

I need it to pull from the customer

 

Laura02
Captain II
Forum|alt.badge.img+19
  • Laura02
  • Captain II
  • 3132 replies
  • 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 ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
S
Jr Varsity III
Forum|alt.badge.img
  • sspencer
  • Author
  • Jr Varsity III
  • 17 replies
  • 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.

 

Laura02
1 person likes this
  • Laura02
    Laura02
Laura02
Captain II
Forum|alt.badge.img+19
  • Laura02
  • Captain II
  • 3132 replies
  • December 5, 2023
sspencer wrote:

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 ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
M
Acumatica Employee
Forum|alt.badge.img

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
2 people like this
  • B
    Bree612
  • Chris Hackett
    Chris Hackett

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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