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 I/C Selling Price/Margin Analysis Report.

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

To print the Selling Price/Margin Analysis report:

  1. Open Inventory Control > I/C Price/Sales Analysis Reports > Selling Price/Margin Analysis.

  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.

  3. Click Print.

    • If you are printing to a physical printer, the Print window appears. Confirm your printer selection and the number of copies to print, and then click OK. Otherwise, click Cancel or Setup.
    • If you are printing to the screen (preview), the report appears in a new window. You can print the report or export it to a file.

      Note: For Web-based clients, the preview screen appears first when you click the Print button.

    • If you are printing to a file, the Export window appears. Specify the file format (for example, PDF, DOC, or XLS). Also, specify a destination for the file:

      • Application. View the report in an application that can open files of the specified format (for example, if you specify PDF as the file format, the report opens in Adobe Acrobat). You can then save the file.
      • Disk file. Save the report to a location you specify.
      • Microsoft Mail. Send the report as an e-mail attachment.

      You can enter the name of a non-existent file or directory to be created by the system when you print. When you print to a file, the report is assigned a unique name, for example, CS1000.TXT.

    • If you are printing to e-mail, an e-mail message appears with the report attached.