| Purpose & Benefits |
|---|
| This report lists Stock records by Product within Group and shows the Gross Profit and percentage Gross Margin, based on the latest Standard cost against Selling price 3 (usually the lowest selling price, giving the minimum margin normally achieved). |
The Product Margins filter selection form is initially set with default information from Maintain Central Information. There are 4 filters as shown above. The way in which you make selections for each of these filters is crucial to the nature of the analysis results, and each filter is described in the following table.
Filters
Decide which filters you want to apply to your report.
| # | Filter Field | Options | Remarks/Notes |
|---|---|---|---|
| 1 | Product Group | AllRangeSingle | If you select Single or Range, complete the From and To fields as required |
| 2 | Product Code | AllRangeSingle | If you select Single or Range, complete the From and To fields as required |
| 3 | Include DiscontinuedProducts | Yes or No | Default is Yes |
| 4 | Cost Price Type | Standard, Last or Average |
You can select which Report Template to use from the drop-down menu; remember you can add one or more extra templates using the Document Templates function in the Central > Central Information menu. Having completed your selections, simply click the Process button to run the report.
The report is displayed for you to preview, as in this example portion:
