Customer Order Nbr in Shipments GI

Please show us your relations tab where you setup the relation to the SOOrder table.

I was thinking that is where the issues lies as I did not alter the relations. Just starting to work in ACU and that is currently out of my knowledge. Below are the current relations, so it appears I will likely need to setup a new one for the SOOrder table.

Thank you!

Should have added…. I have NO idea how to work with the relations. So if there is any links or directions to help me I would appreciate it.

Here is the documentation around it:

https://openuni.acumatica.com/courses/reporting/s130-inquiries-reports-and-dashboards/

Hi, @byates 

Created sample Generic Inquiry to fetch the Customer Order Nbr along with Shipment details and attached GI in XML format, please import and verify.

Attached screenshots for reference. Hope this helps!!
 

Thank you very much that was very helpful!! I have created a new and added the field  that I am looking for. I am noticing that I am getting multiple line items for one shipment, how can I truncate the data to just show one line per shipment? 

Original Shipments:

New Shipment GI:

Tables/Relations

@byates It would be great if you provide your GI, that you created newly.

@Naveen B 

Absolutely, please see attached. Thanks very much for the assistance.

@byates,

I have modified the above-given GI and attached it here. Please check now.

Can I ask what was changed? 

Removed unnecessary joins from the Relations tab, due to that you are getting multiple records.

Now you will get only shipment records as expected.

Thank you very much Naveen!