Available Quantity in Item search is incorrect when certain Transaction types are involved

I have an Item search that finds any items which had a transaction yesterday and returns their remaining available quantity between two locations.

Criteria:

Available Quantity in Item search is incorrect when certain Transaction types are involved

Results:

Available Quantity in Item search is incorrect when certain Transaction types are involved

This works fine when the Transaction type is a Sale Order, but I have noticed for Transfer Orders and possibly Item Receipts, that the summed quantity is incorrect.

When running the above search the summed quantity is 6:

Available Quantity in Item search is incorrect when certain Transaction types are involved

But by clicking on the item, the results show only the following line:

Available Quantity in Item search is incorrect when certain Transaction types are involved

Which is the correct quantity available at the specified location.

Does anyone understand why this is happening?

Beginner Asked on November 15, 2019 in Saved Searches.
Add Comment
3 Answer(s)

Maybe exclude COGS lines?

Advanced Answered on November 15, 2019.

Not making any difference unfortunately.

on November 15, 2019.
Add Comment

Including a “Transaction : Transfer Order Quantity Committed is not empty” filter fixes the issue with Transfer Orders, but Item Receipts continue to show a quantity that is 2x the actual quantity. Not seeing any Transaction filters that could help though…

Beginner Answered on November 18, 2019.
Add Comment

You can use Maximum for the Location Available as well, instead of Sum and this should fix the ambiguity.

 

Beginner Answered on November 19, 2019.

Only if I’m searching for a single location, my goal is to include the combined quantities of multiple locations.

on November 21, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor