Solved

Line Duplicate In GI Due To Shipped QTY

  • 23 November 2022
  • 2 replies
  • 92 views

Userlevel 4
Badge

Hi All,

I am revising a GI that show all the items placed in back order or have yet to be shipped. The situation I am facing is that duplicate line of the same items show up when partial quantity is shipped out and there is still remaining quantity to be fulfill.

 

Above screen shot shows that 7 pieces were shipped out and 18 pieces is still on back order. I could not figure out what relation I will need to set in order for the GI to show the line once, preferably the line that is in Open QTY. I suspect there is a hidden line somewhere that I can’t see and remove.

Looking forward to see help from the community regarding the situation above. 

Kind regards,

Calvin   

icon

Best answer by Naveen Boga 24 November 2022, 03:22

View original

2 replies

Userlevel 7
Badge +18

Hi, @Calvin  I have modified the joins conditions, and it is loading with the proper data without duplicates.

Attached is the updated GI here for reference.

 

Hope this helps!

 

Userlevel 4
Badge

Thank you @Naveen Boga!

Reply


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