report to show items, with sales information, sold below retail

You can run the Sales by Item Detail report to see items sold below retail price along with sales information in QuickBooks Desktop (QBDT), Brita2.

The report will show the retail price, discount amount, and sales price for each item sold. You can identify items sold below retail by comparing the retail price column to the sales price column (amount after discounts).

1. Go to Reports, then choose Sales.
2. Select Sales by Item Detail.
3. Click the Customize Report button at the upper-right top.
4. Check the boxes for Retail Price and Discount Amount under Display columns.
5. Click OK.

Furthermore, you can check this article to learn how you can customize your reports: Customize reports in QuickBooks Desktop.

If you have additional concerns about the reports in QBDT. Feel free to click the Reply button below and we'll be here anytime to help.

Thank you for the instructions.  However I do not show an area to modify the

sales by item detail report, nor does it have the selections to add retail pricing or discount price while using QuickBooks desktop.

As you can see for attached there is no selection for Discount Available or anything for Discount.  Please advise.

I've got ways to ensure the Discount Available column is included in the Sales by Item Detail report, @Brita2.

In QuickBooks Desktop (QBDT), the Discount Available column is only available for specific company types, such as product and service-based businesses.

If you're using the correct one, the Verify and Rebuild tool can check your company file for any data damage that causes the missing column and perform necessary repairs. Before doing so, ensure to update QBDT to the latest release.

To verify your company data:

1. Go to Window and select Close All.
2. Select File, then Utilities.
3. Click Verify Data.

Here's how to rebuild:

1. Go to File, select Utilities, and then select Rebuild Data.
2. Press OK when QBDT asks to make a backup. Choose where to save it and click OK.
3. Select OK once you get the message Rebuild has completed.

Once done, rerun the Verify Data tool to double-check for additional issues.

Moreover, you can memorize your reports to save and use the same customization settings for future use.

Should you have additional concerns with your sales reports, feel free to drop your reply below. We're here to help you ensure everything runs smoothly. Have a good one.

performed a verify data and a rebuild and still no Discounts to be selected.  Please advise.

Hi there, Brita2. Let me route you in the right direction for support regarding this matter.

The availability of certain features can vary depending on the configuration of your company type. As a result, columns such as Discount Available may not be visible based on how your company's profile is set up.

Since you mentioned that the column still doesn't appear even after utilizing the Verify and Rebuild tools, I recommend contacting our live support team. They can investigate further as to why you’re unable to include the desired column and provide real-time assistance to help you customize your reports according to your needs.

Here's how to reach us:

1. On the top menu, go to Help.
2. Select QuickBooks Desktop Help/Contact Us.
3. Click Contact Us.
4. Give a brief description of your concern. Then, Continue.
5. Sign in to your Intuit account. Then, enter the code you receive in your email.
6. Choose to Chat with us or Have us call you.

For your convenience, you can check our support hours in this article: Contact QuickBooks Desktop support.

I'll also leave this resource for your reference on utilizing discounts in QuickBooks: Use discount and subtotal items on an Invoice.

You might also want to save a report's customization settings. Here's a guide on doing so: Create, access and modify memorized reports.

Come back to the Community if you have other concerns about customizing your reports in QuickBooks Desktop, Brita2. I'll be right here for you.