Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM00506
Item Name Product 00506
Current Stock 4.233
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
2.265 Opening Balance
2.760 Inbound Qty
792 Outbound Qty
4.233 Closing Balance
Transaction Ledger 46 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.760 0 4.879
01/11/2024 03440 CUS0582 Customer 0582 SALES MAIN 0 3 4.876
02/11/2024 03577 CUS0001 Customer 0001 SALES MAIN 0 16 4.860
04/11/2024 03898 CUS0822 Customer 0822 SALES MAIN 0 6 4.854
05/11/2024 04091 CUS0002 Customer 0002 SALES MAIN 0 10 4.844
05/11/2024 04101 CUS0584 Customer 0584 SALES MAIN 0 3 4.841
05/11/2024 04230 CUS0002 Customer 0002 SALES MAIN 0 16 4.825
08/11/2024 05162 CUS0822 Customer 0822 SALES MAIN 0 6 4.819
09/11/2024 05195 CUS0822 Customer 0822 SALES MAIN 0 3 4.816
11/11/2024 05583 CUS0218 Customer 0218 SALES MAIN 0 33 4.783
12/11/2024 05674 CUS0603 Customer 0603 SALES MAIN 0 3 4.780
13/11/2024 05940 CUS0584 Customer 0584 SALES MAIN 0 6 4.774
13/11/2024 06167 CUS0002 Customer 0002 SALES MAIN 0 6 4.768
14/11/2024 06236 CUS0584 Customer 0584 SALES MAIN 0 10 4.758
14/11/2024 06377 CUS0582 Customer 0582 SALES MAIN 0 3 4.755
14/11/2024 06380 CUS0218 Customer 0218 SALES MAIN 0 16 4.739
15/11/2024 06461 CUS0576 Customer 0576 SALES MAIN 0 33 4.706
15/11/2024 06464 CUS0576 Customer 0576 SALES MAIN 0 16 4.690
15/11/2024 06607 CUS0002 Customer 0002 SALES MAIN 0 16 4.674
15/11/2024 06623 CUS0029 Customer 0029 SALES MAIN 0 46 4.628
15/11/2024 06704 CUS0822 Customer 0822 SALES MAIN 0 6 4.622
16/11/2024 00025 CUS0029 Customer 0029 SALES MAIN 0 46 4.576
16/11/2024 00070 CUS0006 Customer 0006 SALES MAIN 0 46 4.530
16/11/2024 00074 CUS0006 Customer 0006 SALES MAIN 0 16 4.514
18/11/2024 00225 CUS0010 Customer 0010 SALES MAIN 0 10 4.504
18/11/2024 00325 CUS0006 Customer 0006 SALES MAIN 0 233 4.271
18/11/2024 00332 CUS0010 Customer 0010 SALES MAIN 0 10 4.261
21/11/2024 01049 CUS0022 Customer 0022 SALES MAIN 0 3 4.258
21/11/2024 01228 CUS0002 Customer 0002 SALES MAIN 0 10 4.248
23/11/2024 01505 CUS0001 Customer 0001 SALES MAIN 0 16 4.232
23/11/2024 01682 CUS0208 Customer 0208 SALES MAIN 0 6 4.226
25/11/2024 01928 CUS0003 Customer 0003 SALES MAIN 0 3 4.223
25/11/2024 01936 CUS0822 Customer 0822 SALES MAIN 0 6 4.217
27/11/2024 02417 CUS0208 Customer 0208 SALES MAIN 0 6 4.211
27/11/2024 02482 CUS0212 Customer 0212 SALES MAIN 0 6 4.205
27/11/2024 02515 CUS0822 Customer 0822 SALES MAIN 0 6 4.199
27/11/2024 02563 CUS0686 Customer 0686 SALES MAIN 0 6 4.193
28/11/2024 02576 CUS0002 Customer 0002 SALES MAIN 0 16 4.177
28/11/2024 02827 CUS0006 Customer 0006 SALES MAIN 0 3 4.174
29/11/2024 02963 CUS0785 Customer 0785 SALES MAIN 0 46 4.128
29/11/2024 02980 CUS0611 Customer 0611 SALES MAIN 0 6 4.122
29/11/2024 03131 CUS0029 Customer 0029 SALES MAIN 0 10 4.112
29/11/2024 03139 CUS0205 Customer 0205 SALES MAIN 0 10 4.102
29/11/2024 03145 CUS0510 Customer 0510 SALES MAIN 0 6 4.096
30/11/2024 03156 CUS0509 Customer 0509 SALES MAIN 0 6 4.090
30/11/2024 03233 CUS0001 Customer 0001 SALES MAIN 0 3 4.087

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.