Selling Price/Margin Analysis Report – Printing

Sage ERP Accpac Inventory Control 6.0

Printing the Selling Price/Margin Analysis Report

The Selling Price and Margin Analysis report lists items whose base prices or discount or markup prices have a gross profit margin that is less than the percentage you specify.

Use the report to identify items with unusually low or high profit margins.

For more information on the contents of this report, see Selling Price/Margin Analysis – Features.

Before printing

Run Day End Processing if you want to include the latest costing information in the report.

When to print

Print the report when you want to analyze item profit margins or compare base price margins with the margins on discounted or marked-up prices.

To print the Selling Price/Margin Analysis report

  1. Double-click the Selling Price/Margin Analysis icon in the Price/Sales Analysis Reports folder.

  2. Make your selections in the following fields:

Price List [ ] to [ ]. Select a range of price lists to include in the report.

Location [ ] to [ ]. Select a range of locations to include in the report.

Sort by. Specify the order in which to list item records.

From [ ] To [ ]. Specify the range of item numbers, categories, segments, or optional field entries to include in the report.

Print Items with Margin Less than [ ] Percent. Specify the largest margin percentage for the report. Items whose margins fall below this amount will be included.

Calculate Margin by. Select a method for calculating the margin.

Currency-related fields appear only if you use multicurrency accounting:

  1. To begin printing, click the Print button.

If you are printing to a printer, Inventory Control displays the Print Destination dialog box to let you confirm your printer selection and change the number of copies to print. Click OK if the settings are correct; otherwise, click Cancel or Setup.

If you are printing to a file, Inventory Control displays the name of the file, so you can change it or cancel printing.

If you are printing to the screen (preview), Inventory Control displays the report. You can then export it to a file or send it to the printer.

See also