Skip to main content
Solved

GI - Ship To Address

M
Jr Varsity II
Forum|alt.badge.img

I am trying to create a generic inquiry that includes SO#, Line Item P/N, ship to date, and the ship to address from the shipment. I’m able to get all fields that I need only it is listing each SO# an infinite amount of times with differing information under the Address Line 1. When I remove the AddressLine1 from the results grid, the issue goes away - so I know it is an issue related to that. Any ideas? I’m sure it is something simple I am missing but I’ve stared at it for far too long at this point. Note - there is only 1 item on SO000002.

 

Best answer by Kandy Beatty

Hi @mpowell 

You don’t necessarily need DAC access. Acumatica has added a feature on the GI screen that shows related tables, and that may help you. There is also an Add Relations that will help with data fields relations. 

Here is also help on the the table joins for you:

 

I would also suggest reviewing the course on the Open University:

https://openuni.acumatica.com/courses/reporting/end-user-course-data-retrieval-and-analysis/

View original
dougmcbride79
1 person likes this
  • dougmcbride79
    dougmcbride79
Did this topic help you find an answer to your question?

5 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • BenjaminCrisman
  • Acumatica Support Team
  • 691 replies
  • October 5, 2022

Hi @mpowell ! You’ll want to make sure your joins are using all possible key linking fields.

So for SOOrder, this is OrderType and OrderNbr, but I only see OrderNbr listed.

For more help with getting better joins I recommend to check the Merged DAC Relations screen (SM402000) and enter a table which will show you the key linking fields to use, then you can click the associated table and find more fields and joins which can be joined to this table.

M
Jr Varsity II
Forum|alt.badge.img
  • mpowell
  • Author
  • Jr Varsity II
  • 27 replies
  • October 5, 2022

Thanks for getting back to me so quick Benjamin! I’m just now starting to dabble in GIs (this being the most extensive one I’ve done so far). Doesn’t look like I have security permissions to view the Merged DAC Relations so may reach out to our partner for help on this one. I’m not familiar enough with “joins” to set them up correctly. 

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • BenjaminCrisman
  • Acumatica Support Team
  • 691 replies
  • October 5, 2022

@mpowell without access to either the Merged DAC Relations screen or the Source Code screen (SM204570 but these may require the Customizer role) it might be hard to find the primary keys to use for linking:

 

DConcannon
Chris Hackett
2 people like this
  • DConcannon
    DConcannon
  • Chris Hackett
    Chris Hackett
Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Kandy Beatty
  • Captain II
  • 2209 replies
  • Answer
  • October 5, 2022

Hi @mpowell 

You don’t necessarily need DAC access. Acumatica has added a feature on the GI screen that shows related tables, and that may help you. There is also an Add Relations that will help with data fields relations. 

Here is also help on the the table joins for you:

 

I would also suggest reviewing the course on the Open University:

https://openuni.acumatica.com/courses/reporting/end-user-course-data-retrieval-and-analysis/

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
BenjaminCrisman
DConcannon
Laura02
4 people like this
  • BenjaminCrisman
    BenjaminCrisman
  • DConcannon
    DConcannon
  • Laura02
    Laura02
  • Chris Hackett
    Chris Hackett
Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+13

Hi @mpowell 

Attaching the Generic inquiry which gives some reference of the table Join

Thanks

1 Attachments
Acumatica Functional Consultant & Customer Experience Supervisor
Laura02
Chris Hackett
2 people like this
  • Laura02
    Laura02
  • 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