Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM00132
Item Name Product 00132
Current Stock 3.375
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
2.518 Opening Balance
1.141 Inbound Qty
284 Outbound Qty
3.375 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.141 0 3.082
01/11/2024 03430 CUS0004 Customer 0004 SALES MAIN 0 16 3.066
01/11/2024 03433 CUS0002 Customer 0002 SALES MAIN 0 16 3.050
02/11/2024 03507 CUS0006 Customer 0006 SALES MAIN 0 16 3.034
04/11/2024 03905 CUS0002 Customer 0002 SALES MAIN 0 6 3.028
11/11/2024 05359 CUS0822 Customer 0822 SALES MAIN 0 66 2.962
13/11/2024 06045 CUS0006 Customer 0006 SALES MAIN 0 6 2.956
13/11/2024 06071 CUS0004 Customer 0004 SALES MAIN 0 16 2.940
14/11/2024 06392 CUS0046 Customer 0046 SALES MAIN 0 10 2.930
16/11/2024 00060 CUS0822 Customer 0822 SALES MAIN 0 33 2.897
16/11/2024 00177 CUS0001 Customer 0001 SALES MAIN 0 16 2.881
18/11/2024 00360 CUS0002 Customer 0002 SALES MAIN 0 33 2.848
18/11/2024 00537 CUS0004 Customer 0004 SALES MAIN 0 6 2.842
27/11/2024 02496 CUS0022 Customer 0022 SALES MAIN 0 1 2.841
28/11/2024 02600 CUS0630 Customer 0630 SALES MAIN 0 33 2.808
29/11/2024 02833 CUS0006 Customer 0006 SALES MAIN 0 10 2.798

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.