Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM02757
Item Name Product 02757
Current Stock 3.758
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
2.942 Opening Balance
1.360 Inbound Qty
544 Outbound Qty
3.758 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 1.360 0 4.145
01/11/2024 03412 CUS0581 Customer 0581 SALES MAIN 0 16 4.129
01/11/2024 03485 CUS0010 Customer 0010 SALES MAIN 0 33 4.096
07/11/2024 04843 CUS0207 Customer 0207 SALES MAIN 0 3 4.093
08/11/2024 04956 CUS0029 Customer 0029 SALES MAIN 0 33 4.060
11/11/2024 05332 CUS0581 Customer 0581 SALES MAIN 0 16 4.044
11/11/2024 05343 CUS0611 Customer 0611 SALES MAIN 0 33 4.011
11/11/2024 05407 CUS0029 Customer 0029 SALES MAIN 0 66 3.945
11/11/2024 05575 CUS0611 Customer 0611 SALES MAIN 0 3 3.942
14/11/2024 06230 CUS0822 Customer 0822 SALES MAIN 0 33 3.909
25/11/2024 02017 CUS0029 Customer 0029 SALES MAIN 0 166 3.743
29/11/2024 02975 CUS0005 Customer 0005 SALES MAIN 0 33 3.710
29/11/2024 03066 CUS0611 Customer 0611 SALES MAIN 0 10 3.700
29/11/2024 03122 CUS0822 Customer 0822 SALES MAIN 0 33 3.667
30/11/2024 03287 CUS0002 Customer 0002 SALES MAIN 0 66 3.601

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.