Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM02847
Item Name Product 02847
Current Stock 1.690
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.350 Opening Balance
670 Inbound Qty
330 Outbound Qty
1.690 Closing Balance
Transaction Ledger 10 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 670 0 1.944
05/11/2024 03989 CUS0006 Customer 0006 SALES MAIN 0 33 1.911
08/11/2024 05006 CUS0006 Customer 0006 SALES MAIN 0 33 1.878
11/11/2024 05554 CUS0017 Customer 0017 SALES MAIN 0 33 1.845
12/11/2024 05924 CUS0822 Customer 0822 SALES MAIN 0 10 1.835
14/11/2024 06299 CUS0822 Customer 0822 SALES MAIN 0 6 1.829
15/11/2024 06450 CUS0029 Customer 0029 SALES MAIN 0 33 1.796
27/11/2024 02488 CUS0006 Customer 0006 SALES MAIN 0 33 1.763
27/11/2024 02498 CUS0002 Customer 0002 SALES MAIN 0 16 1.747
27/11/2024 02517 CUS0822 Customer 0822 SALES MAIN 0 133 1.614

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.