Item ledger entry SQL entry type

Hello,

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.

Parents
No Data
Reply Children
No Data
Related
Recommended