Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM04851
Item Name Product 04851
Current Stock 1.697
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.454 Opening Balance
422 Inbound Qty
179 Outbound Qty
1.697 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 422 0 1.310
01/11/2024 03321 CUS0006 Customer 0006 SALES MAIN 0 10 1.300
02/11/2024 03512 CUS0002 Customer 0002 SALES MAIN 0 10 1.290
02/11/2024 03589 CUS0822 Customer 0822 SALES MAIN 0 1 1.289
11/11/2024 05389 CUS0581 Customer 0581 SALES MAIN 0 16 1.273
13/11/2024 05959 CUS0822 Customer 0822 SALES MAIN 0 33 1.240
14/11/2024 06373 CUS0795 Customer 0795 SALES MAIN 0 6 1.234
16/11/2024 00012 CUS0318 Customer 0318 SALES MAIN 0 66 1.168
25/11/2024 01847 CUS0795 Customer 0795 SALES MAIN 0 1 1.167
28/11/2024 02806 CUS0573 Customer 0573 SALES MAIN 0 16 1.151
30/11/2024 03147 CUS0630 Customer 0630 SALES MAIN 0 20 1.131

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.