Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM00733
Item Name Product 00733
Current Stock 5.350
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
4.705 Opening Balance
1.790 Inbound Qty
1.145 Outbound Qty
5.350 Closing Balance
Transaction Ledger 42 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.790 0 5.918
01/11/2024 03408 CUS0010 Customer 0010 SALES MAIN 0 16 5.902
01/11/2024 03415 CUS0584 Customer 0584 SALES MAIN 0 33 5.869
04/11/2024 03767 CUS0017 Customer 0017 SALES MAIN 0 16 5.853
04/11/2024 03786 CUS0795 Customer 0795 SALES MAIN 0 2 5.851
04/11/2024 03979 CUS0006 Customer 0006 SALES MAIN 0 16 5.835
05/11/2024 04116 CUS0822 Customer 0822 SALES MAIN 0 83 5.752
05/11/2024 04295 CUS0002 Customer 0002 SALES MAIN 0 33 5.719
06/11/2024 04369 CUS0822 Customer 0822 SALES MAIN 0 16 5.703
06/11/2024 04481 CUS0584 Customer 0584 SALES MAIN 0 33 5.670
07/11/2024 04702 CUS0686 Customer 0686 SALES MAIN 0 10 5.660
07/11/2024 04714 CUS0029 Customer 0029 SALES MAIN 0 10 5.650
08/11/2024 04876 CUS0004 Customer 0004 SALES MAIN 0 16 5.634
08/11/2024 04960 CUS0822 Customer 0822 SALES MAIN 0 50 5.584
08/11/2024 05033 CUS0208 Customer 0208 SALES MAIN 0 6 5.578
09/11/2024 05182 CUS0006 Customer 0006 SALES MAIN 0 83 5.495
11/11/2024 05382 CUS0006 Customer 0006 SALES MAIN 0 33 5.462
11/11/2024 05551 CUS0049 Customer 0049 SALES MAIN 0 66 5.396
12/11/2024 05780 CUS0029 Customer 0029 SALES MAIN 0 66 5.330
12/11/2024 05888 CUS0798 Customer 0798 SALES MAIN 0 66 5.264
12/11/2024 05895 CUS0584 Customer 0584 SALES MAIN 0 16 5.248
12/11/2024 05932 CUS0017 Customer 0017 SALES MAIN 0 18 5.230
13/11/2024 05934 CUS0006 Customer 0006 SALES MAIN 0 10 5.220
13/11/2024 05947 CUS0795 Customer 0795 SALES MAIN 0 16 5.204
14/11/2024 06232 CUS0010 Customer 0010 SALES MAIN 0 16 5.188
14/11/2024 06390 CUS0049 Customer 0049 SALES MAIN 0 66 5.122
16/11/2024 00063 CUS0576 Customer 0576 SALES MAIN 0 16 5.106
16/11/2024 00068 CUS0029 Customer 0029 SALES MAIN 0 16 5.090
16/11/2024 00178 CUS0822 Customer 0822 SALES MAIN 0 33 5.057
16/11/2024 00182 CUS0010 Customer 0010 SALES MAIN 0 10 5.047
22/11/2024 01487 CUS0010 Customer 0010 SALES MAIN 0 16 5.031
23/11/2024 01569 CUS0215 Customer 0215 SALES MAIN 0 100 4.931
23/11/2024 01593 CUS0795 Customer 0795 SALES MAIN 0 16 4.915
25/11/2024 01851 CUS0029 Customer 0029 SALES MAIN 0 16 4.899
25/11/2024 01945 CUS0001 Customer 0001 SALES MAIN 0 13 4.886
27/11/2024 02435 CUS0215 Customer 0215 SALES MAIN 0 16 4.870
29/11/2024 02912 CUS0584 Customer 0584 SALES MAIN 0 16 4.854
29/11/2024 02917 CUS0208 Customer 0208 SALES MAIN 0 16 4.838
29/11/2024 02966 CUS0584 Customer 0584 SALES MAIN 0 10 4.828
29/11/2024 02977 CUS0584 Customer 0584 SALES MAIN 0 6 4.822
30/11/2024 03160 CUS0029 Customer 0029 SALES MAIN 0 33 4.789
30/11/2024 03201 CUS0004 Customer 0004 SALES MAIN 0 16 4.773

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.