Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM00670
Item Name Product 00670
Current Stock 16.377
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
16.500 Opening Balance
3.892 Inbound Qty
4.015 Outbound Qty
16.377 Closing Balance
Transaction Ledger 30 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 3.892 0 20.224
01/11/2024 03410 CUS0029 Customer 0029 SALES MAIN 0 48 20.176
02/11/2024 03508 CUS0795 Customer 0795 SALES MAIN 0 48 20.128
05/11/2024 04104 CUS0822 Customer 0822 SALES MAIN 0 96 20.032
05/11/2024 04234 CUS0029 Customer 0029 SALES MAIN 0 480 19.552
07/11/2024 04726 CUS0001 Customer 0001 SALES MAIN 0 96 19.456
08/11/2024 04927 CUS0795 Customer 0795 SALES MAIN 0 16 19.440
09/11/2024 05176 CUS0029 Customer 0029 SALES MAIN 0 240 19.200
11/11/2024 05338 CUS0029 Customer 0029 SALES MAIN 0 144 19.056
11/11/2024 05358 CUS0481 Customer 0481 SALES MAIN 0 66 18.990
11/11/2024 05367 CUS0822 Customer 0822 SALES MAIN 0 144 18.846
11/11/2024 05417 CUS0029 Customer 0029 SALES MAIN 0 96 18.750
11/11/2024 05573 CUS0795 Customer 0795 SALES MAIN 0 240 18.510
11/11/2024 05587 CUS0822 Customer 0822 SALES MAIN 0 6 18.504
12/11/2024 05930 CUS0686 Customer 0686 SALES MAIN 0 96 18.408
13/11/2024 06073 CUS0208 Customer 0208 SALES MAIN 0 480 17.928
13/11/2024 06188 CUS0029 Customer 0029 SALES MAIN 0 240 17.688
14/11/2024 06226 CUS0029 Customer 0029 SALES MAIN 0 96 17.592
15/11/2024 06447 CUS0038 Customer 0038 SALES MAIN 0 240 17.352
15/11/2024 06529 CUS0795 Customer 0795 SALES MAIN 0 1 17.351
15/11/2024 06628 CUS0208 Customer 0208 SALES MAIN 0 192 17.159
18/11/2024 00415 CUS0822 Customer 0822 SALES MAIN 0 48 17.111
22/11/2024 01483 CUS0481 Customer 0481 SALES MAIN 0 66 17.045
25/11/2024 01926 CUS0576 Customer 0576 SALES MAIN 0 240 16.805
27/11/2024 02491 CUS0029 Customer 0029 SALES MAIN 0 266 16.539
28/11/2024 02578 CUS0208 Customer 0208 SALES MAIN 0 16 16.523
28/11/2024 02821 CUS0009 Customer 0009 SALES MAIN 0 16 16.507
29/11/2024 02905 CUS0584 Customer 0584 SALES MAIN 0 192 16.315
29/11/2024 03061 CUS0029 Customer 0029 SALES MAIN 0 96 16.219
30/11/2024 03206 CUS0795 Customer 0795 SALES MAIN 0 10 16.209

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.