The Inventory Valuation Summary Report will only show the quantity summary, average cost and extended value of each of the inventory. You'll want to run the Custom Transaction DetailReport to show the specific account of the item.
Click Reports on the upper menu.
Select Custom Reports.
Choose Transaction Detail.
Go to the Display tab, filter accounts, and item to show it on the report.
Once done, export the Inventory Valuation Summary and Custom Transaction Detail report to Excel. Then, consolidate both reports to show the inventory valuation summary for specific accounts.
Sorry, I didn't mean to be snarky. I just feel that's an asinine way to give an inventory valuation report of RAW material and finished goods. I'd be better off manually going through the spreadsheet and separating the two categories.
Unless there is a better way, I think this is what I am going to do. 90%-95% of our finished goods are assembly items. The report can split assembly with reg inventory items. If I split the report, I can just go in and pick out the few 5%-10% of items that are finished goods.
The workaround provided by my colleague is the only way to achieve what you need, Joneill1186.
I know how convenient it is to get the information in one report. I'm taking notes of our customers' concerns. I'll be sharing this with our management team. This will be reviewed and might be added in future updates.