Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM01893
Item Name Product 01893
Current Stock 1.648
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.176 Opening Balance
596 Inbound Qty
124 Outbound Qty
1.648 Closing Balance
Transaction Ledger 15 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 596 0 1.384
04/11/2024 03793 CUS0822 Customer 0822 SALES MAIN 0 10 1.374
04/11/2024 03983 CUS0003 Customer 0003 SALES MAIN 0 10 1.364
05/11/2024 04107 CUS0001 Customer 0001 SALES MAIN 0 6 1.358
05/11/2024 04213 CUS0002 Customer 0002 SALES MAIN 0 6 1.352
06/11/2024 04309 CUS0576 Customer 0576 SALES MAIN 0 3 1.349
06/11/2024 04505 CUS0795 Customer 0795 SALES MAIN 0 13 1.336
06/11/2024 04518 CUS0630 Customer 0630 SALES MAIN 0 16 1.320
08/11/2024 05032 CUS0002 Customer 0002 SALES MAIN 0 10 1.310
11/11/2024 05529 CUS0006 Customer 0006 SALES MAIN 0 13 1.297
16/11/2024 00161 CUS0010 Customer 0010 SALES MAIN 0 16 1.281
23/11/2024 01725 CUS0822 Customer 0822 SALES MAIN 0 3 1.278
25/11/2024 01873 CUS0009 Customer 0009 SALES MAIN 0 1 1.277
27/11/2024 02505 CUS0577 Customer 0577 SALES MAIN 0 1 1.276
28/11/2024 02583 CUS0024 Customer 0024 SALES MAIN 0 16 1.260

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.