Skip to main content

Customer Order Nbr in Shipments GI


Forum|alt.badge.img

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?

 

 

Did this topic help you find an answer to your question?

13 replies

Kulvir Kaila
Jr Varsity I
Forum|alt.badge.img+2
  • Jr Varsity I
  • 60 replies
  • March 1, 2021

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


Forum|alt.badge.img
  • Author
  • 74 replies
  • March 1, 2021

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!

 

 


Forum|alt.badge.img
  • Author
  • 74 replies
  • March 1, 2021

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.

 

 


Kulvir Kaila
Jr Varsity I
Forum|alt.badge.img+2
  • Jr Varsity I
  • 60 replies
  • March 1, 2021

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • March 2, 2021

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!!
 

 

 

 


Forum|alt.badge.img
  • Author
  • 74 replies
  • March 2, 2021

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:

 


Forum|alt.badge.img
  • Author
  • 74 replies
  • March 2, 2021

Tables/Relations

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • March 3, 2021

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


Forum|alt.badge.img
  • Author
  • 74 replies
  • March 3, 2021

@Naveen B 

 

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


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • March 3, 2021

@byates,

 

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


Forum|alt.badge.img
  • Author
  • 74 replies
  • March 3, 2021

Can I ask what was changed? 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3381 replies
  • March 3, 2021

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

Now you will get only shipment records as expected.


Forum|alt.badge.img
  • Author
  • 74 replies
  • March 3, 2021

Thank you very much Naveen!


Reply


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