Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM02351
Item Name Product 02351
Current Stock 4.901
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
2.887 Opening Balance
2.890 Inbound Qty
876 Outbound Qty
4.901 Closing Balance
Transaction Ledger 16 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.890 0 5.410
02/11/2024 03506 CUS0006 Customer 0006 SALES MAIN 0 33 5.377
06/11/2024 04397 CUS0584 Customer 0584 SALES MAIN 0 16 5.361
11/11/2024 05551 CUS0049 Customer 0049 SALES MAIN 0 100 5.261
14/11/2024 06300 CUS0029 Customer 0029 SALES MAIN 0 16 5.245
14/11/2024 06302 CUS0002 Customer 0002 SALES MAIN 0 66 5.179
15/11/2024 06555 CUS0208 Customer 0208 SALES MAIN 0 33 5.146
16/11/2024 00042 CUS0017 Customer 0017 SALES MAIN 0 16 5.130
18/11/2024 00321 CUS0037 Customer 0037 SALES MAIN 0 66 5.064
18/11/2024 00359 CUS0795 Customer 0795 SALES MAIN 0 66 4.998
18/11/2024 00416 CUS0205 Customer 0205 SALES MAIN 0 16 4.982
21/11/2024 01041 CUS0017 Customer 0017 SALES MAIN 0 33 4.949
23/11/2024 01729 CUS0022 Customer 0022 SALES MAIN 0 16 4.933
25/11/2024 01936 CUS0822 Customer 0822 SALES MAIN 0 33 4.900
28/11/2024 02583 CUS0024 Customer 0024 SALES MAIN 0 33 4.867
28/11/2024 02753 CUS0318 Customer 0318 SALES MAIN 0 333 4.534

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.