Hi there, hautecreations.
The option to run a report to show the Item, Cost, Average Cost, and Sales Price columns is unavailable. What we can do is run the Inventory Valuation Summary report to show the Average Cost and Sales Price. Then, export the report to Excel to modify the column to add the theoretic cost column. Here's how to run the Inventory Valuation Summary report:
- Go to Reports, on the top menu.
- Select Inventory.
- Select Inventory Valuation Summary, then set the dates to All.
- Double-click the item in question.
Also, when you sell what you don't have in stock, QuickBooks will post the current average cost to COGS. QuickBooks compares them to the average cost used when selling what you do not have when you buy items. If there's a difference, QuickBooks makes an adjustment entry to both inventory assets and COGS. To learn more about computing the average cost and know which report will help with inventory management, check out this article: Understand inventory assets and cost of goods sold tracking.
In this particular situation, I recommend sending a message to the product engineers to let them know you'd like to have the option to run this kind of report. Here's how to get your feedback submitted:
- Go to the Help menu and select Send Feedback Online.
- Click Product Suggestion.
- Choose a feedback type and product area on the QuickBooks Feedback window.
- Enter your suggestion or feedback, name, and email address (optional).
- Select the Send Feedback Online.
You might also want to read this article to know how QuickBooks tracks inventory: Understand inventory assets and cost of goods sold tracking.
Let me know in the comment section if you need more help in accomplishing your other QuickBooks tasks. I'll be right here to keep assisting.
