Skip to main content
Answer

Generic Inquiries

  • January 26, 2023
  • 4 replies
  • 59 views
P
Semi-Pro II
Forum|alt.badge.img+1

Hi All,

I want to make a GI for Sales Order, I have tables SOOrder and SOLine, I got the fields of SOOrder to display and of SOLine not. The thing is, 1 SOOrder can have multiple SOLine details (1 SO, multiple inventory items). I think it won’t display because of that, is that correct? But how I be able to get it?

Thank you in advance!

Best answer by Kandy Beatty

HI @paula012 

You can have a GI that shows multi lines. Here is the Relation that I used. 

 

Also, Here is one you can build from:

 

Kandy Beatty

4 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+17
  • Kandy Beatty
  • Captain II
  • Answer
  • January 26, 2023

HI @paula012 

You can have a GI that shows multi lines. Here is the Relation that I used. 

 

Also, Here is one you can build from:

 

1 Attachments
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*.
R
Chris Hackett
P
P
Semi-Pro II
Forum|alt.badge.img+1
  • paula012
  • Author
  • Semi-Pro II
  • January 26, 2023

HI @paula012 

You can have a GI that shows multi lines. Here is the Relation that I used. 

 

Thank you so much ma’am @kandybeatty49 ! I used OrigOrderNbr and OrigOrderType following some guide, but yes maybe because that wasn’t originally its purpose. However, how do I know which I choose to use as child field? I took a look at DAC relations and found two, I don’t know how they work and apply such a difference in the result? Can you briefly explain? Thanks a lot again!

 

Chris Hackett
Kandy Beatty
Captain II
Forum|alt.badge.img+17
  • Kandy Beatty
  • Captain II
  • January 26, 2023

Hi @paula012 

I don’t use the cascade deletion. So I am not sure of that. 

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*.
P
P
Semi-Pro II
Forum|alt.badge.img+1
  • paula012
  • Author
  • Semi-Pro II
  • January 26, 2023

Hi @paula012 

I don’t use the cascade deletion. So I am not sure of that. 

Oh, I see. I don’t even know yet what that is too. But thanks anyway! :)

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