Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM02811
Item Name Product 02811
Current Stock 6.719
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
3.941 Opening Balance
4.016 Inbound Qty
1.238 Outbound Qty
6.719 Closing Balance
Transaction Ledger 38 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 4.016 0 7.641
01/11/2024 03278 CUS0022 Customer 0022 SALES MAIN 0 33 7.608
01/11/2024 03424 CUS0006 Customer 0006 SALES MAIN 0 16 7.592
01/11/2024 03435 CUS0611 Customer 0611 SALES MAIN 0 10 7.582
02/11/2024 03591 CUS0003 Customer 0003 SALES MAIN 0 16 7.566
06/11/2024 04399 CUS0287 Customer 0287 SALES MAIN 0 3 7.563
06/11/2024 04569 CUS0029 Customer 0029 SALES MAIN 0 50 7.513
07/11/2024 04586 CUS0017 Customer 0017 SALES MAIN 0 10 7.503
07/11/2024 04701 CUS0630 Customer 0630 SALES MAIN 0 6 7.497
07/11/2024 04750 CUS0611 Customer 0611 SALES MAIN 0 1 7.496
08/11/2024 04937 CUS0029 Customer 0029 SALES MAIN 0 6 7.490
08/11/2024 05036 CUS0010 Customer 0010 SALES MAIN 0 66 7.424
11/11/2024 05429 CUS0573 Customer 0573 SALES MAIN 0 16 7.408
11/11/2024 05542 CUS0584 Customer 0584 SALES MAIN 0 16 7.392
11/11/2024 05573 CUS0795 Customer 0795 SALES MAIN 0 240 7.152
12/11/2024 05679 CUS0029 Customer 0029 SALES MAIN 0 33 7.119
12/11/2024 05790 CUS0630 Customer 0630 SALES MAIN 0 13 7.106
12/11/2024 05890 CUS0045 Customer 0045 SALES MAIN 0 40 7.066
12/11/2024 05915 CUS0001 Customer 0001 SALES MAIN 0 23 7.043
12/11/2024 05930 CUS0686 Customer 0686 SALES MAIN 0 33 7.010
13/11/2024 06164 CUS0630 Customer 0630 SALES MAIN 0 13 6.997
13/11/2024 06199 CUS0029 Customer 0029 SALES MAIN 0 16 6.981
14/11/2024 06297 CUS0029 Customer 0029 SALES MAIN 0 33 6.948
15/11/2024 06553 CUS0822 Customer 0822 SALES MAIN 0 40 6.908
15/11/2024 06609 CUS0630 Customer 0630 SALES MAIN 0 16 6.892
16/11/2024 00071 CUS0002 Customer 0002 SALES MAIN 0 66 6.826
18/11/2024 00416 CUS0205 Customer 0205 SALES MAIN 0 33 6.793
18/11/2024 00427 CUS0584 Customer 0584 SALES MAIN 0 100 6.693
18/11/2024 00438 CUS0795 Customer 0795 SALES MAIN 0 20 6.673
18/11/2024 00533 CUS0576 Customer 0576 SALES MAIN 0 66 6.607
22/11/2024 01482 CUS0822 Customer 0822 SALES MAIN 0 16 6.591
25/11/2024 01935 CUS0822 Customer 0822 SALES MAIN 0 33 6.558
25/11/2024 01940 CUS0029 Customer 0029 SALES MAIN 0 50 6.508
27/11/2024 02564 CUS0017 Customer 0017 SALES MAIN 0 1 6.507
29/11/2024 02920 CUS0630 Customer 0630 SALES MAIN 0 16 6.491
30/11/2024 03213 CUS0584 Customer 0584 SALES MAIN 0 6 6.485
30/11/2024 03302 CUS0205 Customer 0205 SALES MAIN 0 16 6.469
30/11/2024 03308 CUS0822 Customer 0822 SALES MAIN 0 66 6.403

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.