I like to bring inventory remaining quantity and consumption into one pivot table. But when I add WHERE, remaining quantity become 0.
My script is like this.
SELECT L.[Remaining Quantity], L.[Quantity], L.[Entry Type]
FROM [CRONUS Canada, Inc_$Item Ledger Entry] AS L
WHERE L.[Entry Type] = ‘5’
SQL expert please help. Thank you.