I need a report which shows these columns: Item, Cost, Average Cost and Sales Price.
Just noticed I had a loss in XX item sold because I base Sales Price on the Cost (theoretic cost), but the actual Average Cost is higher due to a high prorrated Freight in the Purchase or because Vendor incremented prices and Accounting didn't notice and just captured Bill with that price.
With this report I can compare my "theoretic" Cost vs the Actual Average Cost and update my Sales Price accordingly.
Currently I found that the inventory valuation report Shows my "Average Cost" and "Sales Price" which I can work with to make same analysis, but having the "theoretic" cost column could give me better insight.
I agree there is a report where I can get the "Theoretical" Cost, and then there's the one where I can get "Average Cost". And yes I can export them both and put them together with a vlookup. As a work around.