Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM02848
Item Name Product 02848
Current Stock 1.887
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.761 Opening Balance
340 Inbound Qty
214 Outbound Qty
1.887 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 340 0 1.458
04/11/2024 03696 CUS0021 Customer 0021 SALES MAIN 0 40 1.418
09/11/2024 05188 CUS0795 Customer 0795 SALES MAIN 0 66 1.352
09/11/2024 05255 CUS0581 Customer 0581 SALES MAIN 0 13 1.339
09/11/2024 05272 CUS0584 Customer 0584 SALES MAIN 0 16 1.323
11/11/2024 05351 CUS0795 Customer 0795 SALES MAIN 0 33 1.290
14/11/2024 06299 CUS0822 Customer 0822 SALES MAIN 0 10 1.280
16/11/2024 00057 CUS0630 Customer 0630 SALES MAIN 0 10 1.270
27/11/2024 02426 CUS0576 Customer 0576 SALES MAIN 0 10 1.260
28/11/2024 02735 CUS0003 Customer 0003 SALES MAIN 0 16 1.244

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.