The only way to pull up specific parts on your report is to customize it according to your preference, Brita. I'm here to show you how and provide a better report that displays a breakdown of your data.
To achieve this, kindly search and open the Inventory Valuation Detail report. It provides a breakdown of items under the categories. Please know that retail value is not an available column in this report.
- Go to the Reports menu and then Inventory.
- Select Inventory Valuation Detail and modify the reporting period accordingly.
- Click Customize report and make sure to add Item, Cost, and Avg Cost on the Columns field.
- You can also select how your data are organized by setting the Sort by section according to your preference.
- Once done, hit OK.
Still, if you want to review the retail value, this is only possible in the Inventory Valuation Summary report. However, once you double-click each category, retail value is unavailable as a column on its data, but their transactions are displayed.
You may also let QBDT store applied reporting data and detail alterations. It can help you save time once you need to pull up the same information in the future. Please review this link as your reference: Create, access, and modify memorized reports.
Drop by again on this thread if you have more questions about handling your reports and items or need assistance with other QuickBooks navigations. I'm always here to ensure you're taken care of.
