Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM02864
Item Name Product 02864
Current Stock 1.429
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.298 Opening Balance
304 Inbound Qty
173 Outbound Qty
1.429 Closing Balance
Transaction Ledger 19 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 304 0 1.491
04/11/2024 03885 CUS0001 Customer 0001 SALES MAIN 0 16 1.475
04/11/2024 03914 CUS0002 Customer 0002 SALES MAIN 0 16 1.459
04/11/2024 03915 CUS0611 Customer 0611 SALES MAIN 0 1 1.458
06/11/2024 04366 CUS0822 Customer 0822 SALES MAIN 0 6 1.452
08/11/2024 05012 CUS0822 Customer 0822 SALES MAIN 0 20 1.432
09/11/2024 05175 CUS0795 Customer 0795 SALES MAIN 0 16 1.416
11/11/2024 05352 CUS0006 Customer 0006 SALES MAIN 0 6 1.410
12/11/2024 05784 CUS0287 Customer 0287 SALES MAIN 0 6 1.404
12/11/2024 05924 CUS0822 Customer 0822 SALES MAIN 0 10 1.394
15/11/2024 06616 CUS0611 Customer 0611 SALES MAIN 0 3 1.391
18/11/2024 00227 CUS0584 Customer 0584 SALES MAIN 0 6 1.385
21/11/2024 01141 CUS0006 Customer 0006 SALES MAIN 0 6 1.379
21/11/2024 01285 CUS0099 Customer 0099 SALES MAIN 0 10 1.369
22/11/2024 01497 CUS0009 Customer 0009 SALES MAIN 0 16 1.353
25/11/2024 01740 CUS0821 Customer 0821 SALES MAIN 0 10 1.343
25/11/2024 01845 CUS0821 Customer 0821 SALES MAIN 0 3 1.340
30/11/2024 03208 CUS0208 Customer 0208 SALES MAIN 0 6 1.334
30/11/2024 03298 CUS0017 Customer 0017 SALES MAIN 0 16 1.318

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.