Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM00728
Item Name Product 00728
Current Stock 1.774
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.613 Opening Balance
550 Inbound Qty
389 Outbound Qty
1.774 Closing Balance
Transaction Ledger 11 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 550 0 2.109
04/11/2024 03774 CUS0017 Customer 0017 SALES MAIN 0 26 2.083
04/11/2024 03983 CUS0003 Customer 0003 SALES MAIN 0 33 2.050
06/11/2024 04378 CUS0584 Customer 0584 SALES MAIN 0 6 2.044
06/11/2024 04481 CUS0584 Customer 0584 SALES MAIN 0 33 2.011
07/11/2024 04702 CUS0686 Customer 0686 SALES MAIN 0 10 2.001
08/11/2024 05033 CUS0208 Customer 0208 SALES MAIN 0 6 1.995
12/11/2024 05776 CUS0318 Customer 0318 SALES MAIN 0 83 1.912
14/11/2024 06390 CUS0049 Customer 0049 SALES MAIN 0 166 1.746
16/11/2024 00182 CUS0010 Customer 0010 SALES MAIN 0 10 1.736
16/11/2024 00206 CUS0017 Customer 0017 SALES MAIN 0 16 1.720

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.