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 LWHERE L.[Entry Type] = '5'
SQL expert please help. Thank you.
Not sure you need an SQL expert, but a someone who knows the data. Consumption entries will typically not have a remaining quantity.
Compare with the actual data, as seen from with NAV, to validate your output.