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
Page 1 / 1
Thank you very much Naveen!
Removed unnecessary joins from the Relations tab, due to that you are getting multiple records.
Now you will get only shipment records as expected.
Can I ask what was changed?
I have modified the above-given GI and attached it here. Please check now.
Absolutely, please see attached. Thanks very much for the assistance.
Tables/Relations
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:
Hi,
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!!
Here is the documentation around it:
https://openuni.acumatica.com/courses/reporting/s130-inquiries-reports-and-dashboards/
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.
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!
Please show us your relations tab where you setup the relation to the SOOrder table.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.