Sales by Product Detail report: options and information

Available in Microsoft Office Accounting Professional 2009 only.

The Sales by Product Detail report contains detailed information about product sales over a selected time period. You can use this information to determine how well products and services are performing. If products or services are not performing well, you can adjust your marketing efforts to prevent long-term decreases to your business profits, or you can decide to focus on other, more profitable areas.

By comparing this report with the Product and Service Profitability report and other stock reports, you can determine your most and least profitable products, as well as how fast those products sell. You can filter the report by product types or customers, so that you can focus on factors that help you understand the selling process.

Default information in this report includes transaction types and numbers, dates, customer names, quantities sold and sales prices. You can use additional column options to view sales groups, sales order numbers relating to an invoice and delivery dates. The report displays the current month-to-date period, but you can modify the period by using the Date toolbar or the Select Filter Options dialog box.

In the Sales by Product Detail report, you can do the following:

  • Click a column heading to sort all report contents by that column.

  • Double-click a row to open the original transaction form for that line item.

    Note: If you open a report and edit an underlying document, you need to refresh the report to see the effect of your changes. Click Refresh Report   Button Image on the toolbar or press F5.

When you move the mouse cursor over information that is linked to additional details, the cursor changes to a pointing finger. This indicates you can double-click that location to display associated information, such as opening the original transaction document.

To open this report, point to Sales on the Reports menu, and then click Sales by Product Detail.

The following table provides links to topics that describe additional ways in which you can work with this report.

To learn how to

See this topic

Modify the appearance of the report.

Modify a report

Filter the report to focus on specific areas.

Report filter options: Sales by Product Detail

Export the report for further analysis.

Export a report to Microsoft Office Excel

Print the report.

Print a report

Save the format of the report after you have customised it.

Save a report

Foreign currency

When Microsoft Office Accounting 2009 is set up to use foreign currency, this report displays the amounts in the customer currencies. In addition, the report changes to include columns that show the three-letter code for the customer currencies, the exchange rate and the amount in pounds sterling (GBP).

For more information about using foreign currency in Office Accounting 2009, see About using foreign currencies.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!