Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM01616
Item Name Product 01616
Current Stock 1.629
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.373 Opening Balance
400 Inbound Qty
144 Outbound Qty
1.629 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 400 0 1.232
01/11/2024 03333 CUS0001 Customer 0001 SALES MAIN 0 1 1.231
01/11/2024 03482 CUS0006 Customer 0006 SALES MAIN 0 16 1.215
04/11/2024 03693 CUS0017 Customer 0017 SALES MAIN 0 16 1.199
09/11/2024 05171 CUS0009 Customer 0009 SALES MAIN 0 50 1.149
21/11/2024 01066 CUS0581 Customer 0581 SALES MAIN 0 33 1.116
27/11/2024 02431 CUS0009 Customer 0009 SALES MAIN 0 3 1.113
28/11/2024 02827 CUS0006 Customer 0006 SALES MAIN 0 6 1.107
28/11/2024 02830 CUS0004 Customer 0004 SALES MAIN 0 16 1.091
29/11/2024 02971 CUS0822 Customer 0822 SALES MAIN 0 3 1.088

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.