You use this program to generate a report listing the expected profitability of selected orders held on file.
The report is designed as an exception report, as it reports on orders with a profitability below a low profit percentage or above a high profit percentage.
These low/high profit percentages are either derived from the product class against each sales order line, or entered manually within this program.
| Field | Description | ||||||
|---|---|---|---|---|---|---|---|
| Types of order to include |
Indicate the order types to include in the report. All order types are included by default. The following order types are available for selection or deselection:
|
||||||
| Select All | Select this to include all order types simultaneously. | ||||||
| Deselect All | By default, all order types are selected. You use this option to deselect all order types simultaneously and then individually select only the order types you require. | ||||||
| Print options | |||||||
| Summary line for all orders | Select this to print a summary line for each sales order, regardless of whether any detail lines are printed. Otherwise a summary line is only printed when the detail lines are printed. | ||||||
| Print stock description | Select this to print the stock code description for each order line selected. | ||||||
| Include completed lines | Select this to include completed order lines on the report. | ||||||
| Include zero profit percentage | Select this to include order lines with a zero profit percentage. | ||||||
| Include dispatched but not invoiced | Select this to include sales order lines that have been dispatched, but not yet invoiced. | ||||||
| Include comment lines | Select this to include comment lines on the report. | ||||||
| Branch | Indicate the Accounts Receivable branch(es) for which to include sales orders in the report. | ||||||
| Date selection | |||||||
| All | Select this to include orders for all dates in the report. | ||||||
| Entry date |
Select this to include orders for a range of order entry dates. You indicate this range in the From date and To date fields below. |
||||||
| Ship date |
Select this to include orders for a range of order ship dates. You indicate this range in the From date and To date fields below. |
||||||
| From date |
Indicate the first date in a range of dates for which you want to include orders in the report. This date refers to either the entry or the ship date depending on whether you selected to include orders based on Entry date or Ship date. |
||||||
| To date |
This indicates the last date in a range of dates for which to include orders in the report. This date refers to either the entry or the ship date depending on whether you selected to include orders based on Entry date or Ship date. |
||||||
| Profit percentages | Select your Source
preference:
If the profitability of one or more detail lines in a sales order falls below the less than percentage or above the greater than percentage, then all detail lines for the order are printed (including an order summary line). If an order's profitability falls within the less than / greater than percentages stipulated, then no details are printed for the order. |
||||||
| Order profit less than |
Enter a profit percentage if you selected to manually enter a range of profit margins. This identifies those orders on which too little profit will be made. If a specific profit percentage is entered, then only orders with a profit percentage less than the percentage entered here are selected for inclusion on the report. For example: if 49% is entered, then all sales that generate less than 49% profit are listed. |
||||||
| Order profit greater than |
Enter a profit percentage if you selected to manually enter a range of profit margins. This identifies those orders on which a higher than expected profit margin will be made. Such orders could indicate that either inventory costs are incorrect or that the price/discount structure is incorrect. If a specific profit percentage is entered, then only orders with a profit percentage greater than the percentage entered here are selected for inclusion on the report. For example: If 51% is entered, then all sales that generate more than 51% profit are listed. |
||||||
| Profit margin basis | |||||||
| Calculate order profit margin on |
|
These options enable you to apply a theme to the report and to define multiple output destinations for the report once it has been compiled (SRS Output Options).
If FIFO costing is in use (Inventory Setup or Warehouses) then the Last cost is used to establish the cost value of the line. For all other costing methods, the Unit cost is used (Inventory Warehouse Maintenance for Stock Code).
See Restrictions and limits in Notes and warnings
Cancelled and Completed orders are excluded from the report.
TheTotal amount of order line displays the Total order value, followed by the Total Merchandise value of the order (i.e. excluding miscellaneous charges), the Total profit value and the percentage profit.
If the order does not contain any miscellaneous charges such as freight, packaging, etc., then the Total order value and the Total merchandise value are the same.
All values printed are exclusive of tax.
Although all values on the report are reflected in local currency, the Unit price of orders processed for foreign currency customers is printed in the currency of the customer, and the currency code is displayed in the Price field.
This report is an ORDER report and, as such, uses order quantities to determine the cost and line values.
The only cost that is known in advance is actual costing if the line was moved to ship prior to this report being run. Any other cost is only taken at the time of invoicing, so profit on a sale can only be accurately calculated after invoicing.
If the Sales Analysis module is installed, then the SALP70; report should preferably be used.