Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM01892
Item Name Product 01892
Current Stock 3.394
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
2.598 Opening Balance
1.095 Inbound Qty
299 Outbound Qty
3.394 Closing Balance
Transaction Ledger 16 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.095 0 3.087
01/11/2024 03405 CUS0318 Customer 0318 SALES MAIN 0 166 2.921
05/11/2024 03998 CUS0795 Customer 0795 SALES MAIN 0 16 2.905
07/11/2024 04741 CUS0208 Customer 0208 SALES MAIN 0 6 2.899
08/11/2024 04944 CUS0208 Customer 0208 SALES MAIN 0 6 2.893
08/11/2024 05161 CUS0029 Customer 0029 SALES MAIN 0 16 2.877
11/11/2024 05529 CUS0006 Customer 0006 SALES MAIN 0 10 2.867
12/11/2024 05932 CUS0017 Customer 0017 SALES MAIN 0 10 2.857
13/11/2024 05947 CUS0795 Customer 0795 SALES MAIN 0 6 2.851
14/11/2024 06370 CUS0611 Customer 0611 SALES MAIN 0 6 2.845
15/11/2024 06545 CUS0584 Customer 0584 SALES MAIN 0 6 2.839
16/11/2024 00075 CUS0006 Customer 0006 SALES MAIN 0 16 2.823
16/11/2024 00161 CUS0010 Customer 0010 SALES MAIN 0 10 2.813
23/11/2024 01725 CUS0822 Customer 0822 SALES MAIN 0 3 2.810
27/11/2024 02418 CUS0006 Customer 0006 SALES MAIN 0 6 2.804
28/11/2024 02583 CUS0024 Customer 0024 SALES MAIN 0 16 2.788

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.