Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM02237
Item Name Product 02237
Current Stock 2.346
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.828 Opening Balance
790 Inbound Qty
272 Outbound Qty
2.346 Closing Balance
Transaction Ledger 12 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 790 0 2.183
01/11/2024 03410 CUS0029 Customer 0029 SALES MAIN 0 33 2.150
02/11/2024 03566 CUS0215 Customer 0215 SALES MAIN 0 10 2.140
04/11/2024 03909 CUS0208 Customer 0208 SALES MAIN 0 33 2.107
05/11/2024 04085 CUS0029 Customer 0029 SALES MAIN 0 16 2.091
12/11/2024 05787 CUS0584 Customer 0584 SALES MAIN 0 16 2.075
13/11/2024 06060 CUS0795 Customer 0795 SALES MAIN 0 6 2.069
16/11/2024 00185 CUS0795 Customer 0795 SALES MAIN 0 66 2.003
21/11/2024 01286 CUS0823 Customer 0823 SALES MAIN 0 16 1.987
22/11/2024 01435 CUS0006 Customer 0006 SALES MAIN 0 33 1.954
25/11/2024 02007 CUS0010 Customer 0010 SALES MAIN 0 10 1.944
30/11/2024 03206 CUS0795 Customer 0795 SALES MAIN 0 33 1.911

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.