Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM01949
Item Name Product 01949
Current Stock 5.489
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
5.288 Opening Balance
1.693 Inbound Qty
1.492 Outbound Qty
5.489 Closing Balance
Transaction Ledger 61 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.693 0 6.375
04/11/2024 03701 CUS0573 Customer 0573 SALES MAIN 0 3 6.372
04/11/2024 03701 CUS0573 Customer 0573 SALES MAIN 0 3 6.369
04/11/2024 03701 CUS0573 Customer 0573 SALES MAIN 0 3 6.366
04/11/2024 03701 CUS0573 Customer 0573 SALES MAIN 0 3 6.363
05/11/2024 04106 CUS0002 Customer 0002 SALES MAIN 0 8 6.355
05/11/2024 04227 CUS0027 Customer 0027 SALES MAIN 0 500 5.855
05/11/2024 04233 CUS0795 Customer 0795 SALES MAIN 0 6 5.849
05/11/2024 04233 CUS0795 Customer 0795 SALES MAIN 0 6 5.843
05/11/2024 04233 CUS0795 Customer 0795 SALES MAIN 0 6 5.837
05/11/2024 04233 CUS0795 Customer 0795 SALES MAIN 0 6 5.831
06/11/2024 04303 CUS0821 Customer 0821 SALES MAIN 0 6 5.825
06/11/2024 04309 CUS0576 Customer 0576 SALES MAIN 0 6 5.819
06/11/2024 04364 CUS0795 Customer 0795 SALES MAIN 0 3 5.816
06/11/2024 04562 CUS0208 Customer 0208 SALES MAIN 0 10 5.806
07/11/2024 04700 CUS0208 Customer 0208 SALES MAIN 0 6 5.800
07/11/2024 04740 CUS0007 Customer 0007 SALES MAIN 0 3 5.797
09/11/2024 05186 CUS0002 Customer 0002 SALES MAIN 0 6 5.791
09/11/2024 05265 CUS0027 Customer 0027 SALES MAIN 0 166 5.625
09/11/2024 05271 CUS0017 Customer 0017 SALES MAIN 0 10 5.615
11/11/2024 05351 CUS0795 Customer 0795 SALES MAIN 0 13 5.602
11/11/2024 05351 CUS0795 Customer 0795 SALES MAIN 0 13 5.589
11/11/2024 05351 CUS0795 Customer 0795 SALES MAIN 0 26 5.563
11/11/2024 05351 CUS0795 Customer 0795 SALES MAIN 0 26 5.537
11/11/2024 05440 CUS0630 Customer 0630 SALES MAIN 0 10 5.527
11/11/2024 05440 CUS0630 Customer 0630 SALES MAIN 0 10 5.517
11/11/2024 05440 CUS0630 Customer 0630 SALES MAIN 0 13 5.504
11/11/2024 05440 CUS0630 Customer 0630 SALES MAIN 0 13 5.491
11/11/2024 05577 CUS0029 Customer 0029 SALES MAIN 0 6 5.485
12/11/2024 05436 CUS0821 Customer 0821 SALES MAIN 0 3 5.482
12/11/2024 05790 CUS0630 Customer 0630 SALES MAIN 0 10 5.472
13/11/2024 06164 CUS0630 Customer 0630 SALES MAIN 0 16 5.456
14/11/2024 06208 CUS0017 Customer 0017 SALES MAIN 0 6 5.450
14/11/2024 06231 CUS0029 Customer 0029 SALES MAIN 0 6 5.444
14/11/2024 06393 CUS0029 Customer 0029 SALES MAIN 0 16 5.428
14/11/2024 06445 CUS0795 Customer 0795 SALES MAIN 0 66 5.362
14/11/2024 06445 CUS0795 Customer 0795 SALES MAIN 0 66 5.296
14/11/2024 06445 CUS0795 Customer 0795 SALES MAIN 0 33 5.263
14/11/2024 06445 CUS0795 Customer 0795 SALES MAIN 0 33 5.230
15/11/2024 06468 CUS0022 Customer 0022 SALES MAIN 0 33 5.197
15/11/2024 06468 CUS0022 Customer 0022 SALES MAIN 0 33 5.164
15/11/2024 06468 CUS0022 Customer 0022 SALES MAIN 0 16 5.148
15/11/2024 06468 CUS0022 Customer 0022 SALES MAIN 0 16 5.132
15/11/2024 06541 CUS0029 Customer 0029 SALES MAIN 0 16 5.116
15/11/2024 06619 CUS0006 Customer 0006 SALES MAIN 0 5 5.111
16/11/2024 00010 CUS0573 Customer 0573 SALES MAIN 0 3 5.108
16/11/2024 00016 CUS0821 Customer 0821 SALES MAIN 0 16 5.092
16/11/2024 00061 CUS0795 Customer 0795 SALES MAIN 0 16 5.076
21/11/2024 01230 CUS0573 Customer 0573 SALES MAIN 0 5 5.071
25/11/2024 01861 CUS0630 Customer 0630 SALES MAIN 0 9 5.062
25/11/2024 01861 CUS0630 Customer 0630 SALES MAIN 0 9 5.053
25/11/2024 01861 CUS0630 Customer 0630 SALES MAIN 0 9 5.044
25/11/2024 01861 CUS0630 Customer 0630 SALES MAIN 0 9 5.035
25/11/2024 01935 CUS0822 Customer 0822 SALES MAIN 0 3 5.032
25/11/2024 02012 CUS0001 Customer 0001 SALES MAIN 0 6 5.026
25/11/2024 02015 CUS0821 Customer 0821 SALES MAIN 0 53 4.973
28/11/2024 02598 CUS0006 Customer 0006 SALES MAIN 0 13 4.960
28/11/2024 02724 CUS0611 Customer 0611 SALES MAIN 0 5 4.955
29/11/2024 02836 CUS0021 Customer 0021 SALES MAIN 0 16 4.939
29/11/2024 02837 CUS0021 Customer 0021 SALES MAIN 0 23 4.916
29/11/2024 02885 CUS0822 Customer 0822 SALES MAIN 0 33 4.883

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.