Sales Price Summary report

The Sales Price Summary report shows pricing data on sales of products that are not part of a multi-element allocation. The report considers items not included in a multi-element allocation as items sold separately and not as part of a multi-element arrangement. Use this report to quickly see how frequently these sales vary more than expected from a median or average price.

The Sales Price Summary report provides:

  • Information about the percentage of sales that fall within a specified price range
  • Relevant data to assist a company in determining fair value pricing

The report can calculate price limits based on average sales price. This report is only available for companies that are subscribed to Advanced Revenue Management. You need to update user permissions to access this report.

Some companies refer to this report as the "80/15" test because the current interpretation of sufficient evidence is having 80% of the transactions fall within /-15% of the median price.

Who typically needs this report?

  • Financial executives, such as the CFO, who need to determine which products they can add to a fair value price list
  • Revenue managers who need to proactively manage price levels per item to ensure threshold limits do not fall below the established fair value pricing
  • The CFO or controller who needs to justify fair value pricing strategy to auditors

To access this report:

  • Go to Order Entry > All > Reports > Sales price summary.

Subscription

Order Entry and Revenue Management
User type

Business, Employee, Warehouse, Approval, CRM
Permissions

View MEA Allocations

View a monthly report

To run a report:

  1. On the report settings page, select View.

    The report displays all results for the default reporting period.

  2. To refine the report, select Customize.

Customize and run

If you want to see every result for a particular category, do not make selections from any of the data entry entries. You can run this report without entering any search information. If you do that, however, the report may take a long time to run and may return too many results to be useful.

Before running the report, you can select the time period and types of items to include as well as specify how you want the report to appear.

To customize and run a report:

  1. Select the reporting period from the dropdown list, or enter the start and end dates you want the report to cover. If you do not specify a reporting period, the system generates a report for the current month to date.
    • You can specify either the reporting period or the start and end dates, but not both.
  2. Set the filters to get the specific data you want.
    • Filters enable you to include or exclude specific types of data in the report, such as customer, item, UPC, value, or account. As a general rule, to get fewer and more precise results in your report, set more filters.
  3. Format the report.
    • Format options will vary from report to report. Generally, you can set the layout of the report and arrange how to group and display the data contained in the report.
  4. Type a title, subtitle, and footer text for your report.

  5. To view, process, memorize, or export the report, do one of the following:

    • To view the report now, select View.

    • To generate the report and store it for later access, select Process & Store.

      Reports can be either stored in My Stored Reports or delivered to a cloud storage location, such as Dropbox. Learn more about processing and storing reports.

    • To memorize (that is, save) the report so that later you can refer back to it or modify and re-run it, select Memorize.
    • To export the report to a separate file that you can then distribute or save to your local drive, select Export and then select Word, Excel, CSV, or Text.

Time period

You can use one of the numerous pre-defined reporting periods available from the Reporting period and As of date fields, or create your own reporting period using the Start date and End date fields.

In the Time period section, do one of the following:

  • Use the Reporting period dropdown list to select the reporting period. Either enter a date in the As of date field or use the calendar tool to select a date.
  • Enter a specific Start date, End date, or both. Alternatively, use the calendar tool to select the desired dates.

If you complete all the time period fields (that is, if you fill in the Reporting period, As of date, Start date, and End date fields), Intacct generates your report based on the start and end dates. It ignores the As of date.

The following table describes the fields in the Time period section.

Field Description

Reporting period

These periods are relative to the As of date.

All periods begin on the first day of the period, such as the first day of the month, quarter, or year that you select.

As of date

The date that Intacct will use as a baseline for the reporting period you select. Defaults to today's date.

Start date

Leave the Start date blank to include all information from the earliest date of your Intacct data up to and including the end date.

End date

Leave the End date blank to include all information from the start date up to today.

Prompt on run

Select this checkbox to force Intacct to wait for you (or anyone using this report) to enter a location, department, and/or time period before it will run the report.

Report filters

Use the filters to focus the results of your report. In effect, filter enable you to isolate and assemble just the data you want. You can set any combination of filters.

  • To limit the report to a specific transaction type, select Transaction type, then select the type that you want.
  • To limit the report to a specific customer or range of customers, use the From customer and To customer dropdowns.
  • To limit the report to a specific item or range of items, use the From item and To item dropdowns.
  • To limit the report to a specific product line, select Product line, then select the product line that you want.
  • To limit the report to a specific customer type, select Customer type, then select the type that you want.
  • To limit the report to a specific territory, select the Territory, then select the territory that you want.
Filter field Notes

Transaction type

Limits the report to a specific type of transaction, such as Sales Quote, Sales Order, and so on.

From customer, To customer

Limits the report to a range of customers sorted by customer ID.

From item, To item

Limits the report to a range of items by item name or number, for example, items from A to F, or item numbers 3100 to 5000.

Product line

Limits the report to a specific customer type.

Territory

Limits the report to a specific territory.

All From and To field pairs work the same way. Use them to get search results in as broad or as fine a range as you need, from everything in the system down to a single specific object.

To run this report for a single object:

  1. From the From dropdown list, select the object you want.
  2. From the To dropdown list, select the same object.

To run this report for a specific range of objects:

  1. From the From dropdown list, select the object that you want at the beginning of the range.
  2. From the To dropdown list, select the object that you want at the end of the range.

To run this report for all objects:

Leave both fields blank.

If you have a large number of objects or the report takes too long to process, use the From and To fields to run a series of smaller reports. For example, you can run five reports, one each for objects whose names begin with A-E, then F-J, K-O, P-T, and U-Z.

An object is a catch-all term that refers to any specific data item in the system. Customers, vendors, items, and accounts are all examples of objects.

Establish pricing ratios

Pricing ratio settings establish the variance you want to allow or expect to see for items that are not sold in multiple-element arrangements. The system calculated the median price for an item, and you set the variance percentages you expect to see and the threshold for the number of sales that vary from your expected price range.

  1. In Price max, enter the percentage above median price that you expect to see. For example, if you set Price max 10% on an item with a median price of $100, then a sale at $109 would be within your expected range. A sale at $111 would be outside your range.
  2. In Price min, type the percentage below median price that you expect to see. For example, if you set Price min 10% on an item with a median price of $100, then a sale at $91 would be within your expected range. A sale at $89 would be outside your range.
  3. In Percentage threshold, enter the percentage of sales you expect to see within your range. When less than this percentage fall within your expected range, the system displays the reported percentage in red.

Sort results

  • To set a specific column to sort by, select Sort by, then select the column.
  • To set a specific item to group by, select Group by, then select the item. When you group by an item the system provides a summary column for each group.

Titles and footer

Titles, subtitles, and footers apply only to the print versions of this report. Export to Excel or CSV, or select Print for a PDF version.

  1. Enter the title in the Report title 1 field.

    • This title displays in large type at the top of the page, directly under your company name.
    • You can type over any default name that Sage Intacct might have populated in this field.  

  2. Enter the subtitle in the Report title 2 field.

    • The subtitle displays in smaller type, directly beneath the main title.
  3. Enter the footer text in the Footer text field. Footer text displays at the bottom center of the report.

You can use up to 80 characters, including spaces, in each title, subtitle, and footer.