Item Transaction History

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

IMS_Demo
Clear
Item Code ITEM00708
Item Name Product 00708
Current Stock 5.675
Warehouse All Warehouses
Period 01/11/2024 – 30/11/2024
3.199 Opening Balance
3.120 Inbound Qty
644 Outbound Qty
5.675 Closing Balance
Transaction Ledger 15 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 3.120 0 5.729
04/11/2024 03982 CUS0003 Customer 0003 SALES MAIN 0 33 5.696
06/11/2024 04363 CUS0001 Customer 0001 SALES MAIN 0 50 5.646
11/11/2024 05333 CUS0581 Customer 0581 SALES MAIN 0 66 5.580
11/11/2024 05396 CUS0208 Customer 0208 SALES MAIN 0 33 5.547
11/11/2024 05538 CUS0017 Customer 0017 SALES MAIN 0 66 5.481
13/11/2024 06200 CUS0584 Customer 0584 SALES MAIN 0 10 5.471
15/11/2024 06538 CUS0287 Customer 0287 SALES MAIN 0 33 5.438
16/11/2024 00077 CUS0002 Customer 0002 SALES MAIN 0 166 5.272
16/11/2024 00178 CUS0822 Customer 0822 SALES MAIN 0 33 5.239
23/11/2024 01577 CUS0212 Customer 0212 SALES MAIN 0 16 5.223
23/11/2024 01721 CUS0822 Customer 0822 SALES MAIN 0 66 5.157
27/11/2024 02510 CUS0006 Customer 0006 SALES MAIN 0 6 5.151
28/11/2024 02755 CUS0582 Customer 0582 SALES MAIN 0 33 5.118
30/11/2024 03220 CUS0009 Customer 0009 SALES MAIN 0 33 5.085

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.