Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM02512
Item Name Product 02512
Current Stock 4.578
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
2.872 Opening Balance
2.325 Inbound Qty
619 Outbound Qty
4.578 Closing Balance
Transaction Ledger 30 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 2.325 0 5.042
01/11/2024 03503 CUS0029 Customer 0029 SALES MAIN 0 33 5.009
04/11/2024 03707 CUS0584 Customer 0584 SALES MAIN 0 16 4.993
04/11/2024 03911 CUS0611 Customer 0611 SALES MAIN 0 6 4.987
05/11/2024 04223 CUS0006 Customer 0006 SALES MAIN 0 66 4.921
06/11/2024 04397 CUS0584 Customer 0584 SALES MAIN 0 16 4.905
08/11/2024 04927 CUS0795 Customer 0795 SALES MAIN 0 33 4.872
09/11/2024 05264 CUS0611 Customer 0611 SALES MAIN 0 10 4.862
09/11/2024 05267 CUS0576 Customer 0576 SALES MAIN 0 16 4.846
11/11/2024 05341 CUS0576 Customer 0576 SALES MAIN 0 6 4.840
11/11/2024 05439 CUS0005 Customer 0005 SALES MAIN 0 16 4.824
11/11/2024 05559 CUS0795 Customer 0795 SALES MAIN 0 16 4.808
12/11/2024 05678 CUS0029 Customer 0029 SALES MAIN 0 16 4.792
12/11/2024 05919 CUS0576 Customer 0576 SALES MAIN 0 10 4.782
14/11/2024 06228 CUS0003 Customer 0003 SALES MAIN 0 33 4.749
14/11/2024 06367 CUS0029 Customer 0029 SALES MAIN 0 16 4.733
15/11/2024 06450 CUS0029 Customer 0029 SALES MAIN 0 66 4.667
16/11/2024 00038 CUS0576 Customer 0576 SALES MAIN 0 16 4.651
16/11/2024 00074 CUS0006 Customer 0006 SALES MAIN 0 50 4.601
18/11/2024 00422 CUS0006 Customer 0006 SALES MAIN 0 5 4.596
18/11/2024 00423 CUS0029 Customer 0029 SALES MAIN 0 33 4.563
18/11/2024 00523 CUS0795 Customer 0795 SALES MAIN 0 33 4.530
21/11/2024 01155 CUS0009 Customer 0009 SALES MAIN 0 16 4.514
21/11/2024 01238 CUS0576 Customer 0576 SALES MAIN 0 6 4.508
25/11/2024 01867 CUS0611 Customer 0611 SALES MAIN 0 3 4.505
25/11/2024 01946 CUS0022 Customer 0022 SALES MAIN 0 13 4.492
27/11/2024 02520 CUS0010 Customer 0010 SALES MAIN 0 16 4.476
28/11/2024 02803 CUS0611 Customer 0611 SALES MAIN 0 10 4.466
29/11/2024 02888 CUS0584 Customer 0584 SALES MAIN 0 33 4.433
30/11/2024 03240 CUS0212 Customer 0212 SALES MAIN 0 10 4.423

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.