Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM00232
Item Name Product 00232
Current Stock 3.355
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
2.335 Opening Balance
1.700 Inbound Qty
680 Outbound Qty
3.355 Closing Balance
Transaction Ledger 32 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.700 0 3.550
04/11/2024 03775 CUS0005 Customer 0005 SALES MAIN 0 33 3.517
04/11/2024 03781 CUS0215 Customer 0215 SALES MAIN 0 10 3.507
04/11/2024 03920 CUS0004 Customer 0004 SALES MAIN 0 33 3.474
04/11/2024 03979 CUS0006 Customer 0006 SALES MAIN 0 16 3.458
04/11/2024 03983 CUS0003 Customer 0003 SALES MAIN 0 16 3.442
05/11/2024 03995 CUS0029 Customer 0029 SALES MAIN 0 16 3.426
06/11/2024 04381 CUS0795 Customer 0795 SALES MAIN 0 20 3.406
07/11/2024 04702 CUS0686 Customer 0686 SALES MAIN 0 10 3.396
09/11/2024 05250 CUS0584 Customer 0584 SALES MAIN 0 16 3.380
11/11/2024 05280 CUS0212 Customer 0212 SALES MAIN 0 16 3.364
11/11/2024 05334 CUS0006 Customer 0006 SALES MAIN 0 10 3.354
11/11/2024 05382 CUS0006 Customer 0006 SALES MAIN 0 33 3.321
11/11/2024 05385 CUS0002 Customer 0002 SALES MAIN 0 16 3.305
11/11/2024 05424 CUS0005 Customer 0005 SALES MAIN 0 6 3.299
12/11/2024 05895 CUS0584 Customer 0584 SALES MAIN 0 33 3.266
12/11/2024 05917 CUS0821 Customer 0821 SALES MAIN 0 16 3.250
13/11/2024 06162 CUS0017 Customer 0017 SALES MAIN 0 10 3.240
14/11/2024 06234 CUS0005 Customer 0005 SALES MAIN 0 10 3.230
16/11/2024 00068 CUS0029 Customer 0029 SALES MAIN 0 16 3.214
18/11/2024 00214 CUS0006 Customer 0006 SALES MAIN 0 16 3.198
18/11/2024 00538 CUS0001 Customer 0001 SALES MAIN 0 33 3.165
21/11/2024 01051 CUS0510 Customer 0510 SALES MAIN 0 33 3.132
22/11/2024 01490 CUS0010 Customer 0010 SALES MAIN 0 16 3.116
23/11/2024 01701 CUS0215 Customer 0215 SALES MAIN 0 16 3.100
23/11/2024 01721 CUS0822 Customer 0822 SALES MAIN 0 33 3.067
25/11/2024 01877 CUS0287 Customer 0287 SALES MAIN 0 16 3.051
27/11/2024 02512 CUS0686 Customer 0686 SALES MAIN 0 100 2.951
28/11/2024 02827 CUS0006 Customer 0006 SALES MAIN 0 16 2.935
29/11/2024 02892 CUS0208 Customer 0208 SALES MAIN 0 33 2.902
30/11/2024 03160 CUS0029 Customer 0029 SALES MAIN 0 16 2.886
30/11/2024 03282 CUS0576 Customer 0576 SALES MAIN 0 16 2.870

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.