Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM01847
Item Name Product 01847
Current Stock 5.825
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
4.648 Opening Balance
2.220 Inbound Qty
1.043 Outbound Qty
5.825 Closing Balance
Transaction Ledger 35 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.220 0 6.186
01/11/2024 03325 CUS0010 Customer 0010 SALES MAIN 0 13 6.173
01/11/2024 03503 CUS0029 Customer 0029 SALES MAIN 0 6 6.167
04/11/2024 03966 CUS0010 Customer 0010 SALES MAIN 0 16 6.151
04/11/2024 03977 CUS0823 Customer 0823 SALES MAIN 0 100 6.051
04/11/2024 03984 CUS0584 Customer 0584 SALES MAIN 0 16 6.035
05/11/2024 03995 CUS0029 Customer 0029 SALES MAIN 0 16 6.019
05/11/2024 04216 CUS0584 Customer 0584 SALES MAIN 0 16 6.003
07/11/2024 04708 CUS0318 Customer 0318 SALES MAIN 0 66 5.937
07/11/2024 04726 CUS0001 Customer 0001 SALES MAIN 0 20 5.917
08/11/2024 05164 CUS0584 Customer 0584 SALES MAIN 0 33 5.884
09/11/2024 05250 CUS0584 Customer 0584 SALES MAIN 0 16 5.868
11/11/2024 05350 CUS0001 Customer 0001 SALES MAIN 0 6 5.862
11/11/2024 05586 CUS0029 Customer 0029 SALES MAIN 0 16 5.846
12/11/2024 05677 CUS0006 Customer 0006 SALES MAIN 0 50 5.796
12/11/2024 05792 CUS0205 Customer 0205 SALES MAIN 0 53 5.743
13/11/2024 05954 CUS0208 Customer 0208 SALES MAIN 0 26 5.717
13/11/2024 05956 CUS0051 Customer 0051 SALES MAIN 0 16 5.701
13/11/2024 06077 CUS0208 Customer 0208 SALES MAIN 0 16 5.685
14/11/2024 06226 CUS0029 Customer 0029 SALES MAIN 0 133 5.552
16/11/2024 00008 CUS0208 Customer 0208 SALES MAIN 0 16 5.536
16/11/2024 00044 CUS0001 Customer 0001 SALES MAIN 0 66 5.470
18/11/2024 00347 CUS0208 Customer 0208 SALES MAIN 0 33 5.437
18/11/2024 00358 CUS0795 Customer 0795 SALES MAIN 0 20 5.417
18/11/2024 00427 CUS0584 Customer 0584 SALES MAIN 0 33 5.384
21/11/2024 01234 CUS0022 Customer 0022 SALES MAIN 0 6 5.378
22/11/2024 01434 CUS0584 Customer 0584 SALES MAIN 0 10 5.368
25/11/2024 02013 CUS0029 Customer 0029 SALES MAIN 0 83 5.285
27/11/2024 02514 CUS0029 Customer 0029 SALES MAIN 0 10 5.275
28/11/2024 02592 CUS0041 Customer 0041 SALES MAIN 0 23 5.252
28/11/2024 02807 CUS0017 Customer 0017 SALES MAIN 0 10 5.242
28/11/2024 02818 CUS0584 Customer 0584 SALES MAIN 0 23 5.219
29/11/2024 03124 CUS0010 Customer 0010 SALES MAIN 0 33 5.186
29/11/2024 03140 CUS0029 Customer 0029 SALES MAIN 0 10 5.176
30/11/2024 03285 CUS0029 Customer 0029 SALES MAIN 0 33 5.143

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.