Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM03708
Item Name Product 03708
Current Stock 1.442
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.042 Opening Balance
500 Inbound Qty
100 Outbound Qty
1.442 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 500 0 1.368
11/11/2024 05373 CUS0208 Customer 0208 SALES MAIN 0 6 1.362
11/11/2024 05427 CUS0822 Customer 0822 SALES MAIN 0 6 1.356
16/11/2024 00184 CUS0823 Customer 0823 SALES MAIN 0 6 1.350
16/11/2024 00200 CUS0822 Customer 0822 SALES MAIN 0 10 1.340
18/11/2024 00419 CUS0002 Customer 0002 SALES MAIN 0 10 1.330
25/11/2024 01952 CUS0584 Customer 0584 SALES MAIN 0 10 1.320
28/11/2024 02750 CUS0002 Customer 0002 SALES MAIN 0 3 1.317
29/11/2024 02908 CUS0822 Customer 0822 SALES MAIN 0 33 1.284
30/11/2024 03210 CUS0027 Customer 0027 SALES MAIN 0 16 1.268

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.