Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM03199
Item Name Product 03199
Current Stock 3.583
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
1.488 Opening Balance
2.790 Inbound Qty
695 Outbound Qty
3.583 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 2.790 0 4.135
01/11/2024 03493 CUS0006 Customer 0006 SALES MAIN 0 33 4.102
04/11/2024 03701 CUS0573 Customer 0573 SALES MAIN 0 16 4.086
07/11/2024 04587 CUS0208 Customer 0208 SALES MAIN 0 50 4.036
08/11/2024 04951 CUS0009 Customer 0009 SALES MAIN 0 66 3.970
11/11/2024 05388 CUS0009 Customer 0009 SALES MAIN 0 66 3.904
13/11/2024 05938 CUS0010 Customer 0010 SALES MAIN 0 10 3.894
15/11/2024 06706 CUS0630 Customer 0630 SALES MAIN 0 10 3.884
18/11/2024 00422 CUS0006 Customer 0006 SALES MAIN 0 66 3.818
18/11/2024 00540 CUS0001 Customer 0001 SALES MAIN 0 16 3.802
27/11/2024 02438 CUS0822 Customer 0822 SALES MAIN 0 33 3.769
28/11/2024 02580 CUS0002 Customer 0002 SALES MAIN 0 50 3.719
28/11/2024 02721 CUS0001 Customer 0001 SALES MAIN 0 80 3.639
28/11/2024 02722 CUS0208 Customer 0208 SALES MAIN 0 100 3.539
28/11/2024 02732 CUS0630 Customer 0630 SALES MAIN 0 66 3.473
29/11/2024 02837 CUS0021 Customer 0021 SALES MAIN 0 33 3.440

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.