Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM00667
Item Name Product 00667
Current Stock 3.421
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
3.128 Opening Balance
1.146 Inbound Qty
853 Outbound Qty
3.421 Closing Balance
Transaction Ledger 26 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.146 0 3.941
01/11/2024 03432 CUS0006 Customer 0006 SALES MAIN 0 6 3.935
01/11/2024 03490 CUS0029 Customer 0029 SALES MAIN 0 16 3.919
02/11/2024 03508 CUS0795 Customer 0795 SALES MAIN 0 36 3.883
04/11/2024 03772 CUS0611 Customer 0611 SALES MAIN 0 10 3.873
05/11/2024 04215 CUS0003 Customer 0003 SALES MAIN 0 16 3.857
05/11/2024 04238 CUS0022 Customer 0022 SALES MAIN 0 6 3.851
07/11/2024 04579 CUS0029 Customer 0029 SALES MAIN 0 36 3.815
07/11/2024 04588 CUS0051 Customer 0051 SALES MAIN 0 36 3.779
08/11/2024 05002 CUS0795 Customer 0795 SALES MAIN 0 72 3.707
11/11/2024 05394 CUS0029 Customer 0029 SALES MAIN 0 16 3.691
11/11/2024 05433 CUS0029 Customer 0029 SALES MAIN 0 180 3.511
11/11/2024 05578 CUS0006 Customer 0006 SALES MAIN 0 6 3.505
11/11/2024 05587 CUS0822 Customer 0822 SALES MAIN 0 10 3.495
12/11/2024 05599 CUS0822 Customer 0822 SALES MAIN 0 6 3.489
12/11/2024 05918 CUS0041 Customer 0041 SALES MAIN 0 16 3.473
13/11/2024 06068 CUS0029 Customer 0029 SALES MAIN 0 36 3.437
13/11/2024 06196 CUS0010 Customer 0010 SALES MAIN 0 36 3.401
14/11/2024 06226 CUS0029 Customer 0029 SALES MAIN 0 72 3.329
14/11/2024 06379 CUS0795 Customer 0795 SALES MAIN 0 36 3.293
14/11/2024 06398 CUS0010 Customer 0010 SALES MAIN 0 36 3.257
16/11/2024 00036 CUS0212 Customer 0212 SALES MAIN 0 16 3.241
18/11/2024 00529 CUS0822 Customer 0822 SALES MAIN 0 108 3.133
18/11/2024 00531 CUS0576 Customer 0576 SALES MAIN 0 13 3.120
30/11/2024 03203 CUS0006 Customer 0006 SALES MAIN 0 16 3.104
30/11/2024 03215 CUS0576 Customer 0576 SALES MAIN 0 16 3.088

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.