Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM02029
Item Name Product 02029
Current Stock 5.098
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
4.304 Opening Balance
2.080 Inbound Qty
1.286 Outbound Qty
5.098 Closing Balance
Transaction Ledger 59 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.080 0 6.206
01/11/2024 03354 CUS0010 Customer 0010 SALES MAIN 0 6 6.200
02/11/2024 03508 CUS0795 Customer 0795 SALES MAIN 0 23 6.177
02/11/2024 03584 CUS0795 Customer 0795 SALES MAIN 0 23 6.154
04/11/2024 03715 CUS0822 Customer 0822 SALES MAIN 0 10 6.144
05/11/2024 04223 CUS0006 Customer 0006 SALES MAIN 0 10 6.134
05/11/2024 04226 CUS0795 Customer 0795 SALES MAIN 0 10 6.124
05/11/2024 04234 CUS0029 Customer 0029 SALES MAIN 0 46 6.078
05/11/2024 04287 CUS0029 Customer 0029 SALES MAIN 0 23 6.055
06/11/2024 04382 CUS0584 Customer 0584 SALES MAIN 0 16 6.039
06/11/2024 04390 CUS0584 Customer 0584 SALES MAIN 0 23 6.016
07/11/2024 04588 CUS0051 Customer 0051 SALES MAIN 0 70 5.946
07/11/2024 04750 CUS0611 Customer 0611 SALES MAIN 0 1 5.945
08/11/2024 05010 CUS0821 Customer 0821 SALES MAIN 0 16 5.929
08/11/2024 05162 CUS0822 Customer 0822 SALES MAIN 0 16 5.913
11/11/2024 05417 CUS0029 Customer 0029 SALES MAIN 0 46 5.867
11/11/2024 05525 CUS0041 Customer 0041 SALES MAIN 0 16 5.851
11/11/2024 05567 CUS0029 Customer 0029 SALES MAIN 0 33 5.818
12/11/2024 05599 CUS0822 Customer 0822 SALES MAIN 0 6 5.812
12/11/2024 05789 CUS0029 Customer 0029 SALES MAIN 0 6 5.806
12/11/2024 05918 CUS0041 Customer 0041 SALES MAIN 0 16 5.790
13/11/2024 06066 CUS0584 Customer 0584 SALES MAIN 0 16 5.774
13/11/2024 06068 CUS0029 Customer 0029 SALES MAIN 0 46 5.728
13/11/2024 06073 CUS0208 Customer 0208 SALES MAIN 0 46 5.682
13/11/2024 06188 CUS0029 Customer 0029 SALES MAIN 0 46 5.636
13/11/2024 06196 CUS0010 Customer 0010 SALES MAIN 0 46 5.590
14/11/2024 06215 CUS0584 Customer 0584 SALES MAIN 0 23 5.567
14/11/2024 06226 CUS0029 Customer 0029 SALES MAIN 0 46 5.521
14/11/2024 06236 CUS0584 Customer 0584 SALES MAIN 0 23 5.498
14/11/2024 06293 CUS0009 Customer 0009 SALES MAIN 0 13 5.485
14/11/2024 06300 CUS0029 Customer 0029 SALES MAIN 0 23 5.462
14/11/2024 06367 CUS0029 Customer 0029 SALES MAIN 0 23 5.439
14/11/2024 06369 CUS0009 Customer 0009 SALES MAIN 0 23 5.416
14/11/2024 06379 CUS0795 Customer 0795 SALES MAIN 0 46 5.370
15/11/2024 06479 CUS0584 Customer 0584 SALES MAIN 0 6 5.364
15/11/2024 06480 CUS0584 Customer 0584 SALES MAIN 0 23 5.341
15/11/2024 06541 CUS0029 Customer 0029 SALES MAIN 0 23 5.318
15/11/2024 06616 CUS0611 Customer 0611 SALES MAIN 0 3 5.315
15/11/2024 06621 CUS0029 Customer 0029 SALES MAIN 0 23 5.292
16/11/2024 00061 CUS0795 Customer 0795 SALES MAIN 0 10 5.282
16/11/2024 00166 CUS0219 Customer 0219 SALES MAIN 0 16 5.266
16/11/2024 00168 CUS0584 Customer 0584 SALES MAIN 0 33 5.233
18/11/2024 00225 CUS0010 Customer 0010 SALES MAIN 0 16 5.217
18/11/2024 00415 CUS0822 Customer 0822 SALES MAIN 0 23 5.194
18/11/2024 00542 CUS0003 Customer 0003 SALES MAIN 0 3 5.191
21/11/2024 01078 CUS0017 Customer 0017 SALES MAIN 0 16 5.175
21/11/2024 01130 CUS0029 Customer 0029 SALES MAIN 0 46 5.129
22/11/2024 01430 CUS0584 Customer 0584 SALES MAIN 0 10 5.119
23/11/2024 01516 CUS0795 Customer 0795 SALES MAIN 0 16 5.103
23/11/2024 01598 CUS0029 Customer 0029 SALES MAIN 0 16 5.087
23/11/2024 01690 CUS0611 Customer 0611 SALES MAIN 0 10 5.077
25/11/2024 01859 CUS0010 Customer 0010 SALES MAIN 0 23 5.054
25/11/2024 01875 CUS0002 Customer 0002 SALES MAIN 0 3 5.051
25/11/2024 01937 CUS0009 Customer 0009 SALES MAIN 0 23 5.028
25/11/2024 01951 CUS0584 Customer 0584 SALES MAIN 0 46 4.982
28/11/2024 02583 CUS0024 Customer 0024 SALES MAIN 0 16 4.966
28/11/2024 02588 CUS0207 Customer 0207 SALES MAIN 0 3 4.963
29/11/2024 03143 CUS0795 Customer 0795 SALES MAIN 0 33 4.930
30/11/2024 03215 CUS0576 Customer 0576 SALES MAIN 0 10 4.920

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.