Skip to main content
Solved

Line Duplicate In GI Due To Shipped QTY

  • 23 November 2022
  • 2 replies
  • 104 views

Forum|alt.badge.img
  • Jr Varsity III
  • 65 replies

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!

 

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

2 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3377 replies
  • 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
  • 65 replies
  • November 24, 2022

Thank you @Naveen Boga!


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