Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM01615
Item Name Product 01615
Current Stock 1.867
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.422 Opening Balance
690 Inbound Qty
245 Outbound Qty
1.867 Closing Balance
Transaction Ledger 11 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 690 0 1.419
04/11/2024 03977 CUS0823 Customer 0823 SALES MAIN 0 50 1.369
06/11/2024 04491 CUS0009 Customer 0009 SALES MAIN 0 6 1.363
08/11/2024 04955 CUS0108 Customer 0108 SALES MAIN 0 16 1.347
08/11/2024 05161 CUS0029 Customer 0029 SALES MAIN 0 33 1.314
14/11/2024 06441 CUS0581 Customer 0581 SALES MAIN 0 10 1.304
15/11/2024 06447 CUS0038 Customer 0038 SALES MAIN 0 16 1.288
18/11/2024 00323 CUS0005 Customer 0005 SALES MAIN 0 6 1.282
18/11/2024 00411 CUS0041 Customer 0041 SALES MAIN 0 16 1.266
21/11/2024 01286 CUS0823 Customer 0823 SALES MAIN 0 66 1.200
28/11/2024 02819 CUS0029 Customer 0029 SALES MAIN 0 26 1.174

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.