Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM00248
Item Name Product 00248
Current Stock 1.829
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.621 Opening Balance
398 Inbound Qty
190 Outbound Qty
1.829 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 398 0 1.824
04/11/2024 03694 CUS0006 Customer 0006 SALES MAIN 0 6 1.818
05/11/2024 04224 CUS0287 Customer 0287 SALES MAIN 0 116 1.702
06/11/2024 04382 CUS0584 Customer 0584 SALES MAIN 0 6 1.696
08/11/2024 05028 CUS0581 Customer 0581 SALES MAIN 0 16 1.680
18/11/2024 00211 CUS0581 Customer 0581 SALES MAIN 0 16 1.664
18/11/2024 00212 CUS0581 Customer 0581 SALES MAIN 0 16 1.648
18/11/2024 00534 CUS0603 Customer 0603 SALES MAIN 0 2 1.646
29/11/2024 02912 CUS0584 Customer 0584 SALES MAIN 0 6 1.640
29/11/2024 02979 CUS0005 Customer 0005 SALES MAIN 0 6 1.634

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.