Sales Orders > Reports > Order Profitability

Order Profitability

You use the Order Profitability program to generate a report listing the expected profitability of selected orders held on file.

The report is designed as an exception report. 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.

If the profitability of one or more detail lines in a sales order falls outside the less than/greater than percentage range, then all detail lines for the order are printed, including an order summary line. If none of the detail lines fall outside the less than/greater than percentage range, then no details are printed for the order.

[Note]

Cancelled and Completed orders are excluded from the report.

Report Options

Field Value Description
Types of order to include  

Select the types of to include in the report.

By default, all order types are selected.

The following order types are available for selection or deselection:

  • Open order
  • Open backorder
  • Released backorder
  • In warehouse
  • Ready to invoice
  • Suspense
  • Forward
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 if you want to include completed order lines on the report.
Include zero profit percentage Select this if you want 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 you wan 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

You use this field to 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 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.
Profit percentages   If the profitability of one or more detail lines in a sales order falls outside the less than/greater than percentages entered, then all detail lines for the order are printed, including an order summary line. If none of the detail lines fall outside the less than/greater than percentages entered, then no details are printed for the order.
Product class

Select this to use the profit margins held against the product class that was assigned to the order line.

The High/low profit percentages defined against the product class (Browse on Product Classes), for an order line is used.
Manually entered

Select this to enter the required profit margin percentages at the Order profit less than and Order profit greater than fields.

Items below the low percentage and above the high percentage are selected for inclusion in the report (i.e. this is not a 'From - To' range type selection).

To identify those orders whose profit lies between two percentages, you would select this option and then enter the percentages in the Order profit less than and Order profit greater than fields.

For example, if you wanted to identify orders with a profit percentage of 50, you would enter 51 in the Order profit less than field and 49 in the Order profit greater than field.
Order profit less than

Enter a profit percentage if you selected to manually enter a range of profit margins.

The purpose of this percentage is to identify 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 10% is entered, then all sales that generate less than 10% profit are listed.
Order profit greater than

Enter a profit percentage if you selected to manually enter a range of profit margins.

The purpose of this percentage is to identify 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 20% is entered, then all sales that generate more than 20% profit are listed.
Profit margin basis    
Calculate order profit margin on  
Merchandise amount Select this to calculate the profit margin using the profit amount and the merchandise value of the order.

This is how the profit margin is calculated on the standard report.
Total order amount Select this to calculate the profit margin using the profit amount and the total value of the order.

Output Options

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).

Report Details

If FIFO costing is in use (Inventory Setup - General tab or Browse on 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 (Warehouses for Stock Code).

The Total 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.

[Note]

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.