Item Transaction History

Read-only stock ledger inquiry for item movement analysis. Current source: Sales Invoice outbound.

IMS_Demo
Clear
Item Code ITEM00635
Item Name Product 00635
Current Stock 1.501
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.299 Opening Balance
260 Inbound Qty
58 Outbound Qty
1.501 Closing Balance
Transaction Ledger 10 movement(s)
Date Document No Customer Code Customer Name Transaction Type Warehouse In Qty Out Qty Running Balance
01/11/2024 IR202411-0001 - - RECEIPT MAIN 260 0 1.011
01/11/2024 03485 CUS0010 Customer 0010 SALES MAIN 0 1 1.010
11/11/2024 05386 CUS0795 Customer 0795 SALES MAIN 0 20 990
13/11/2024 06169 CUS0823 Customer 0823 SALES MAIN 0 1 989
13/11/2024 06183 CUS0576 Customer 0576 SALES MAIN 0 1 988
16/11/2024 00054 CUS0001 Customer 0001 SALES MAIN 0 3 985
21/11/2024 01157 CUS0005 Customer 0005 SALES MAIN 0 3 982
23/11/2024 01727 CUS0008 Customer 0008 SALES MAIN 0 10 972
25/11/2024 01746 CUS0051 Customer 0051 SALES MAIN 0 3 969
28/11/2024 02744 CUS0822 Customer 0822 SALES MAIN 0 16 953

Opening Balance — ims.InventoryBeginningSnapshot (PeriodKey 202411, warehouse-specific) • Inbound Qty — SUM(In Qty) from ledger receipts in date range — ims.InventoryTransaction (TransactionType = Receipt) • Outbound Qty — SUM(Out Qty) from sales in date range — ims.SalesDetail via posted Sale ledger rows • Closing Balance — Opening Balance + Total In Qty − Total Out Qty Running balance is calculated independently per warehouse.