Hi! I want to do a saved inventory detail search. This is the criteria: Transaction : Type = Invoice Results: 1. Group by "Item" 2. SUM "Item count" 3. Item : "Total Value" 4. SUM "Item : Location On Hand" The problem is that 3) gives me a multiple of the number of transactions for the item so the total value = total value x number of invoices I haven't even gotten to 4) yet. Any ideas how I can do this?

Is there a reason Invoice is part of your requirements? Have you considered using the Inventory Value report?

We do obsolete inventory report based on quantity in stock / consumption last month. We need a report showing consumption, stock on hand and stock value per item, for all locations. Not per location, but summed per item