Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM00141
Item Name Product 00141
Current Stock 15.164
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
14.988 Opening Balance
6.850 Inbound Qty
6.674 Outbound Qty
15.164 Closing Balance
Transaction Ledger 58 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 6.850 0 21.333
01/11/2024 03334 CUS0001 Customer 0001 SALES MAIN 0 10 21.323
01/11/2024 03408 CUS0010 Customer 0010 SALES MAIN 0 33 21.290
01/11/2024 03420 CUS0009 Customer 0009 SALES MAIN 0 33 21.257
01/11/2024 03488 CUS0029 Customer 0029 SALES MAIN 0 66 21.191
04/11/2024 03711 CUS0004 Customer 0004 SALES MAIN 0 33 21.158
04/11/2024 03774 CUS0017 Customer 0017 SALES MAIN 0 83 21.075
04/11/2024 03776 CUS0002 Customer 0002 SALES MAIN 0 16 21.059
04/11/2024 03781 CUS0215 Customer 0215 SALES MAIN 0 16 21.043
04/11/2024 03782 CUS0005 Customer 0005 SALES MAIN 0 33 21.010
04/11/2024 03920 CUS0004 Customer 0004 SALES MAIN 0 333 20.677
04/11/2024 03979 CUS0006 Customer 0006 SALES MAIN 0 33 20.644
04/11/2024 03983 CUS0003 Customer 0003 SALES MAIN 0 50 20.594
06/11/2024 04367 CUS0006 Customer 0006 SALES MAIN 0 33 20.561
06/11/2024 04378 CUS0584 Customer 0584 SALES MAIN 0 16 20.545
06/11/2024 04503 CUS0010 Customer 0010 SALES MAIN 0 33 20.512
07/11/2024 04593 CUS0017 Customer 0017 SALES MAIN 0 66 20.446
07/11/2024 04702 CUS0686 Customer 0686 SALES MAIN 0 16 20.430
07/11/2024 04714 CUS0029 Customer 0029 SALES MAIN 0 16 20.414
09/11/2024 05172 CUS0584 Customer 0584 SALES MAIN 0 16 20.398
11/11/2024 05418 CUS0795 Customer 0795 SALES MAIN 0 16 20.382
11/11/2024 05421 CUS0207 Customer 0207 SALES MAIN 0 10 20.372
11/11/2024 05524 CUS0006 Customer 0006 SALES MAIN 0 33 20.339
11/11/2024 05530 CUS0208 Customer 0208 SALES MAIN 0 33 20.306
12/11/2024 05780 CUS0029 Customer 0029 SALES MAIN 0 333 19.973
12/11/2024 05883 CUS0212 Customer 0212 SALES MAIN 0 66 19.907
12/11/2024 05888 CUS0798 Customer 0798 SALES MAIN 0 166 19.741
13/11/2024 06180 CUS0001 Customer 0001 SALES MAIN 0 16 19.725
14/11/2024 06319 CUS0007 Customer 0007 SALES MAIN 0 33 19.692
14/11/2024 06390 CUS0049 Customer 0049 SALES MAIN 0 666 19.026
14/11/2024 06390 CUS0049 Customer 0049 SALES MAIN 0 666 18.360
14/11/2024 06390 CUS0049 Customer 0049 SALES MAIN 0 1.333 17.027
14/11/2024 06390 CUS0049 Customer 0049 SALES MAIN 0 1.333 15.694
15/11/2024 06560 CUS0630 Customer 0630 SALES MAIN 0 6 15.688
15/11/2024 06603 CUS0001 Customer 0001 SALES MAIN 0 26 15.662
15/11/2024 06603 CUS0001 Customer 0001 SALES MAIN 0 26 15.636
15/11/2024 06603 CUS0001 Customer 0001 SALES MAIN 0 26 15.610
15/11/2024 06603 CUS0001 Customer 0001 SALES MAIN 0 26 15.584
15/11/2024 06604 CUS0022 Customer 0022 SALES MAIN 0 66 15.518
15/11/2024 06623 CUS0029 Customer 0029 SALES MAIN 0 166 15.352
16/11/2024 00009 CUS0017 Customer 0017 SALES MAIN 0 33 15.319
21/11/2024 01049 CUS0022 Customer 0022 SALES MAIN 0 10 15.309
21/11/2024 01050 CUS0022 Customer 0022 SALES MAIN 0 66 15.243
21/11/2024 01229 CUS0001 Customer 0001 SALES MAIN 0 16 15.227
22/11/2024 01487 CUS0010 Customer 0010 SALES MAIN 0 66 15.161
23/11/2024 01569 CUS0215 Customer 0215 SALES MAIN 0 100 15.061
23/11/2024 01728 CUS0584 Customer 0584 SALES MAIN 0 33 15.028
27/11/2024 02413 CUS0001 Customer 0001 SALES MAIN 0 6 15.022
27/11/2024 02435 CUS0215 Customer 0215 SALES MAIN 0 33 14.989
27/11/2024 02496 CUS0022 Customer 0022 SALES MAIN 0 33 14.956
27/11/2024 02514 CUS0029 Customer 0029 SALES MAIN 0 66 14.890
28/11/2024 02736 CUS0022 Customer 0022 SALES MAIN 0 10 14.880
28/11/2024 02818 CUS0584 Customer 0584 SALES MAIN 0 66 14.814
29/11/2024 02966 CUS0584 Customer 0584 SALES MAIN 0 50 14.764
29/11/2024 02998 CUS0006 Customer 0006 SALES MAIN 0 6 14.758
30/11/2024 03160 CUS0029 Customer 0029 SALES MAIN 0 33 14.725
30/11/2024 03216 CUS0822 Customer 0822 SALES MAIN 0 33 14.692
30/11/2024 03229 CUS0509 Customer 0509 SALES MAIN 0 33 14.659

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.