Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM02396
Item Name Product 02396
Current Stock 2.079
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
2.003 Opening Balance
661 Inbound Qty
585 Outbound Qty
2.079 Closing Balance
Transaction Ledger 28 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 661 0 2.495
01/11/2024 03354 CUS0010 Customer 0010 SALES MAIN 0 6 2.489
01/11/2024 03439 CUS0611 Customer 0611 SALES MAIN 0 2 2.487
02/11/2024 03508 CUS0795 Customer 0795 SALES MAIN 0 26 2.461
04/11/2024 03982 CUS0003 Customer 0003 SALES MAIN 0 6 2.455
05/11/2024 04238 CUS0022 Customer 0022 SALES MAIN 0 3 2.452
07/11/2024 04588 CUS0051 Customer 0051 SALES MAIN 0 26 2.426
07/11/2024 04692 CUS0584 Customer 0584 SALES MAIN 0 5 2.421
09/11/2024 05019 CUS0009 Customer 0009 SALES MAIN 0 3 2.418
11/11/2024 05417 CUS0029 Customer 0029 SALES MAIN 0 53 2.365
11/11/2024 05557 CUS0822 Customer 0822 SALES MAIN 0 26 2.339
11/11/2024 05578 CUS0006 Customer 0006 SALES MAIN 0 6 2.333
13/11/2024 06068 CUS0029 Customer 0029 SALES MAIN 0 53 2.280
13/11/2024 06073 CUS0208 Customer 0208 SALES MAIN 0 26 2.254
13/11/2024 06188 CUS0029 Customer 0029 SALES MAIN 0 26 2.228
13/11/2024 06189 CUS0584 Customer 0584 SALES MAIN 0 16 2.212
14/11/2024 06226 CUS0029 Customer 0029 SALES MAIN 0 53 2.159
14/11/2024 06293 CUS0009 Customer 0009 SALES MAIN 0 13 2.146
14/11/2024 06300 CUS0029 Customer 0029 SALES MAIN 0 26 2.120
14/11/2024 06379 CUS0795 Customer 0795 SALES MAIN 0 53 2.067
14/11/2024 06398 CUS0010 Customer 0010 SALES MAIN 0 26 2.041
15/11/2024 06469 CUS0822 Customer 0822 SALES MAIN 0 26 2.015
15/11/2024 06541 CUS0029 Customer 0029 SALES MAIN 0 16 1.999
15/11/2024 06621 CUS0029 Customer 0029 SALES MAIN 0 26 1.973
18/11/2024 00415 CUS0822 Customer 0822 SALES MAIN 0 26 1.947
18/11/2024 00539 CUS0017 Customer 0017 SALES MAIN 0 26 1.921
22/11/2024 01430 CUS0584 Customer 0584 SALES MAIN 0 10 1.911
23/11/2024 01715 CUS0611 Customer 0611 SALES MAIN 0 1 1.910

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.