Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM01785
Item Name Product 01785
Current Stock 2.285
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.879 Opening Balance
672 Inbound Qty
266 Outbound Qty
2.285 Closing Balance
Transaction Ledger 17 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 672 0 1.997
01/11/2024 03333 CUS0001 Customer 0001 SALES MAIN 0 3 1.994
04/11/2024 03983 CUS0003 Customer 0003 SALES MAIN 0 10 1.984
06/11/2024 04315 CUS0009 Customer 0009 SALES MAIN 0 33 1.951
06/11/2024 04361 CUS0584 Customer 0584 SALES MAIN 0 10 1.941
07/11/2024 04580 CUS0006 Customer 0006 SALES MAIN 0 10 1.931
07/11/2024 04747 CUS0001 Customer 0001 SALES MAIN 0 16 1.915
09/11/2024 05174 CUS0029 Customer 0029 SALES MAIN 0 10 1.905
09/11/2024 05260 CUS0006 Customer 0006 SALES MAIN 0 23 1.882
13/11/2024 05948 CUS0021 Customer 0021 SALES MAIN 0 50 1.832
15/11/2024 06552 CUS0001 Customer 0001 SALES MAIN 0 16 1.816
18/11/2024 00214 CUS0006 Customer 0006 SALES MAIN 0 10 1.806
18/11/2024 00227 CUS0584 Customer 0584 SALES MAIN 0 10 1.796
18/11/2024 00231 CUS0005 Customer 0005 SALES MAIN 0 10 1.786
23/11/2024 01503 CUS0004 Customer 0004 SALES MAIN 0 33 1.753
28/11/2024 02827 CUS0006 Customer 0006 SALES MAIN 0 6 1.747
28/11/2024 02830 CUS0004 Customer 0004 SALES MAIN 0 16 1.731

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.