Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM03104
Item Name Product 03104
Current Stock 3.834
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
2.156 Opening Balance
2.300 Inbound Qty
622 Outbound Qty
3.834 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.300 0 4.337
05/11/2024 04223 CUS0006 Customer 0006 SALES MAIN 0 66 4.271
11/11/2024 05379 CUS0208 Customer 0208 SALES MAIN 0 66 4.205
11/11/2024 05423 CUS0795 Customer 0795 SALES MAIN 0 10 4.195
11/11/2024 05548 CUS0584 Customer 0584 SALES MAIN 0 33 4.162
12/11/2024 05597 CUS0822 Customer 0822 SALES MAIN 0 33 4.129
13/11/2024 05960 CUS0006 Customer 0006 SALES MAIN 0 33 4.096
13/11/2024 06050 CUS0781 Customer 0781 SALES MAIN 0 1 4.095
15/11/2024 06475 CUS0006 Customer 0006 SALES MAIN 0 33 4.062
16/11/2024 00199 CUS0001 Customer 0001 SALES MAIN 0 100 3.962
18/11/2024 00422 CUS0006 Customer 0006 SALES MAIN 0 16 3.946
18/11/2024 00523 CUS0795 Customer 0795 SALES MAIN 0 33 3.913
23/11/2024 01506 CUS0017 Customer 0017 SALES MAIN 0 66 3.847
25/11/2024 01842 CUS0205 Customer 0205 SALES MAIN 0 33 3.814
29/11/2024 02882 CUS0786 Customer 0786 SALES MAIN 0 66 3.748
30/11/2024 03221 CUS0584 Customer 0584 SALES MAIN 0 33 3.715

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.