Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM02746
Item Name Product 02746
Current Stock 2.572
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.811 Opening Balance
983 Inbound Qty
222 Outbound Qty
2.572 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 983 0 2.365
04/11/2024 03976 CUS0002 Customer 0002 SALES MAIN 0 3 2.362
06/11/2024 04317 CUS0215 Customer 0215 SALES MAIN 0 6 2.356
08/11/2024 05021 CUS0822 Customer 0822 SALES MAIN 0 10 2.346
11/11/2024 05334 CUS0006 Customer 0006 SALES MAIN 0 6 2.340
12/11/2024 05781 CUS0002 Customer 0002 SALES MAIN 0 10 2.330
13/11/2024 06061 CUS0010 Customer 0010 SALES MAIN 0 10 2.320
13/11/2024 06168 CUS0318 Customer 0318 SALES MAIN 0 80 2.240
16/11/2024 00032 CUS0208 Customer 0208 SALES MAIN 0 6 2.234
21/11/2024 01141 CUS0006 Customer 0006 SALES MAIN 0 6 2.228
22/11/2024 01495 CUS0002 Customer 0002 SALES MAIN 0 33 2.195
23/11/2024 01693 CUS0822 Customer 0822 SALES MAIN 0 16 2.179
28/11/2024 02806 CUS0573 Customer 0573 SALES MAIN 0 10 2.169
28/11/2024 02814 CUS0017 Customer 0017 SALES MAIN 0 10 2.159
29/11/2024 03063 CUS0017 Customer 0017 SALES MAIN 0 16 2.143

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.