Hello, I am trying to add the Customer Order Nbr to my Shipment GI. I have added the table and included the correct item in the Results Grid. However, nothing is populating in the GI. Any idea as to why?
Customer Order Nbr in Shipments GI
+2Please 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.
+2Here is the documentation around it:
https://openuni.acumatica.com/courses/reporting/s130-inquiries-reports-and-dashboards/
+20Hi,
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:
+20+20
I have modified the above-given GI and attached it here. Please check now.
+20Removed unnecessary joins from the Relations tab, due to that you are getting multiple records.
Now you will get only shipment records as expected.
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.