Profit reports not showing costs

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Click on Home->All Reports
2. Under the "Profit" heading click "Profit Per Invoice"
3.

What is the expected output? What do you see instead?

I was hoping that it would show the total, the cost and the profit, but it 
shows only "0" for all the costs. This means that profit calculations are wrong.

What version of the product are you using? On what operating system?

2011.1. I am using the Web App on a Linux Server.

Please provide any additional information below.

Original issue reported on code.google.com by Dave.A.C...@gmail.com on 15 Feb 2012 at 4:03

[GoogleCodeExporter]

Hi Dave,

Are you using any extensions?

Matt

Original comment by MattAntW...@gmail.com on 15 Feb 2012 at 8:00

[GoogleCodeExporter]

Hi, 

I have checked the report code, it seems that sql query is fetching the cost 
and quantity values from the inventory table so if we haven't include a record 
in inventory section like a service which doesn't need a quantity, cost is 
appeared as zero in the report.  can be fixed by adding a inventory record to 
that.

There are two cost fields in product table and inventory table which I doesn't 
understand the use. I think if there is a option to choose whether the item is 
a product or a service, Most of the inventory problems will be solved.

Anushka

Original comment by anu...@gmail.com on 16 Feb 2012 at 7:24