Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM00983
Item Name Product 00983
Current Stock 2.792
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.384 Opening Balance
1.670 Inbound Qty
262 Outbound Qty
2.792 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 1.670 0 2.614
05/11/2024 03990 CUS0208 Customer 0208 SALES MAIN 0 16 2.598
11/11/2024 05424 CUS0005 Customer 0005 SALES MAIN 0 16 2.582
12/11/2024 05767 CUS0006 Customer 0006 SALES MAIN 0 33 2.549
16/11/2024 00051 CUS0582 Customer 0582 SALES MAIN 0 16 2.533
16/11/2024 00203 CUS0003 Customer 0003 SALES MAIN 0 33 2.500
23/11/2024 01724 CUS0010 Customer 0010 SALES MAIN 0 66 2.434
27/11/2024 02405 CUS0576 Customer 0576 SALES MAIN 0 33 2.401
28/11/2024 02595 CUS0287 Customer 0287 SALES MAIN 0 33 2.368
28/11/2024 02756 CUS0611 Customer 0611 SALES MAIN 0 16 2.352

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.