Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM03707
Item Name Product 03707
Current Stock 2.381
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.694 Opening Balance
930 Inbound Qty
243 Outbound Qty
2.381 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 930 0 2.259
05/11/2024 04223 CUS0006 Customer 0006 SALES MAIN 0 10 2.249
06/11/2024 04496 CUS0208 Customer 0208 SALES MAIN 0 10 2.239
11/11/2024 05373 CUS0208 Customer 0208 SALES MAIN 0 6 2.233
15/11/2024 06463 CUS0208 Customer 0208 SALES MAIN 0 3 2.230
21/11/2024 01053 CUS0003 Customer 0003 SALES MAIN 0 3 2.227
21/11/2024 01078 CUS0017 Customer 0017 SALES MAIN 0 66 2.161
21/11/2024 01142 CUS0010 Customer 0010 SALES MAIN 0 5 2.156
21/11/2024 01235 CUS0822 Customer 0822 SALES MAIN 0 13 2.143
23/11/2024 01504 CUS0017 Customer 0017 SALES MAIN 0 50 2.093
25/11/2024 01742 CUS0029 Customer 0029 SALES MAIN 0 33 2.060
25/11/2024 01856 CUS0017 Customer 0017 SALES MAIN 0 6 2.054
25/11/2024 01952 CUS0584 Customer 0584 SALES MAIN 0 10 2.044
27/11/2024 02418 CUS0006 Customer 0006 SALES MAIN 0 6 2.038
28/11/2024 02832 CUS0001 Customer 0001 SALES MAIN 0 16 2.022
29/11/2024 03125 CUS0029 Customer 0029 SALES MAIN 0 6 2.016

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.