Skip to main content
Answer

Line Duplicate In GI Due To Shipped QTY

  • November 23, 2022
  • 2 replies
  • 124 views

Forum|alt.badge.img

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   

Best answer by Naveen Boga

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!

 

2 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • Answer
  • November 24, 2022

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!

 


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • November 24, 2022

Thank you @Naveen Boga!