Service Item Reporting

Hi

Let me start by saying thanks to everyone that is involved in this excellent project. I have been using it for a few months now and it is catering perfectly for an international company with $1mil turnover per month.

I am looking for a report that can provide me with detailed history on the purchase of specific inventory items. For example, I would ideally like to provide our management with a report that shows YTD expenditure on a single item only, even though it is captured on supplier invoices (using direct method and service items) together with a multitude of other items. This makes the search and display feature of "PO Transaction Inquiry" inadequate as there are thousands.

I have been looking and can't seem to find such a report, but I am still fairly new to FA so my apologies if this already exists, or if the question has already been asked and answered.

Even if this is given in the form of an mysql query I would be more than happy to run the report manually and extract the data in csv.

Kind regards
Johan