Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM00488
Item Name Product 00488
Current Stock 1.851
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.643 Opening Balance
381 Inbound Qty
173 Outbound Qty
1.851 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 381 0 1.618
04/11/2024 03793 CUS0822 Customer 0822 SALES MAIN 0 3 1.615
04/11/2024 03888 CUS0576 Customer 0576 SALES MAIN 0 3 1.612
04/11/2024 03903 CUS0029 Customer 0029 SALES MAIN 0 6 1.606
05/11/2024 03992 CUS0620 Customer 0620 SALES MAIN 0 66 1.540
05/11/2024 04206 CUS0001 Customer 0001 SALES MAIN 0 1 1.539
06/11/2024 04366 CUS0822 Customer 0822 SALES MAIN 0 6 1.533
07/11/2024 04713 CUS0215 Customer 0215 SALES MAIN 0 10 1.523
09/11/2024 05196 CUS0006 Customer 0006 SALES MAIN 0 6 1.517
14/11/2024 06230 CUS0822 Customer 0822 SALES MAIN 0 6 1.511
15/11/2024 06706 CUS0630 Customer 0630 SALES MAIN 0 1 1.510
21/11/2024 01140 CUS0795 Customer 0795 SALES MAIN 0 16 1.494
27/11/2024 02514 CUS0029 Customer 0029 SALES MAIN 0 10 1.484
27/11/2024 02561 CUS0686 Customer 0686 SALES MAIN 0 3 1.481
28/11/2024 02577 CUS0576 Customer 0576 SALES MAIN 0 3 1.478
28/11/2024 02819 CUS0029 Customer 0029 SALES MAIN 0 33 1.445

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.