Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM00383
Item Name Product 00383
Current Stock 2.734
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
2.066 Opening Balance
890 Inbound Qty
222 Outbound Qty
2.734 Closing Balance
Transaction Ledger 25 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 890 0 2.299
04/11/2024 03774 CUS0017 Customer 0017 SALES MAIN 0 10 2.289
04/11/2024 03903 CUS0029 Customer 0029 SALES MAIN 0 6 2.283
05/11/2024 04230 CUS0002 Customer 0002 SALES MAIN 0 16 2.267
06/11/2024 04366 CUS0822 Customer 0822 SALES MAIN 0 3 2.264
07/11/2024 04712 CUS0003 Customer 0003 SALES MAIN 0 6 2.258
07/11/2024 04720 CUS0009 Customer 0009 SALES MAIN 0 3 2.255
08/11/2024 04955 CUS0108 Customer 0108 SALES MAIN 0 16 2.239
08/11/2024 05005 CUS0208 Customer 0208 SALES MAIN 0 6 2.233
09/11/2024 05192 CUS0003 Customer 0003 SALES MAIN 0 10 2.223
11/11/2024 05334 CUS0006 Customer 0006 SALES MAIN 0 6 2.217
11/11/2024 05385 CUS0002 Customer 0002 SALES MAIN 0 6 2.211
12/11/2024 05889 CUS0798 Customer 0798 SALES MAIN 0 33 2.178
13/11/2024 06167 CUS0002 Customer 0002 SALES MAIN 0 3 2.175
13/11/2024 06180 CUS0001 Customer 0001 SALES MAIN 0 3 2.172
14/11/2024 06227 CUS0584 Customer 0584 SALES MAIN 0 16 2.156
14/11/2024 06382 CUS0576 Customer 0576 SALES MAIN 0 3 2.153
14/11/2024 06392 CUS0046 Customer 0046 SALES MAIN 0 10 2.143
16/11/2024 00020 CUS0576 Customer 0576 SALES MAIN 0 3 2.140
18/11/2024 00237 CUS0287 Customer 0287 SALES MAIN 0 16 2.124
18/11/2024 00342 CUS0795 Customer 0795 SALES MAIN 0 6 2.118
25/11/2024 01928 CUS0003 Customer 0003 SALES MAIN 0 3 2.115
27/11/2024 02415 CUS0287 Customer 0287 SALES MAIN 0 16 2.099
28/11/2024 02578 CUS0208 Customer 0208 SALES MAIN 0 6 2.093
30/11/2024 03283 CUS0022 Customer 0022 SALES MAIN 0 16 2.077

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.