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.
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:
But by clicking on the item, the results show only the following line:
Which is the correct quantity available at the specified location.
Does anyone understand why this is happening?
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…