You use this program to generate a report that enables you to analyze sales order values over a projected period of time in days or months.
| Field | Description |
|---|---|
| Report type | |
| Detail | Select this to print a list of all applicable orders as well as order value totals in each column |
| Summary | Select this to print only order value totals in each of the projection columns. |
| Based on date | Select the date on which you want to base the projection. |
| Order date | Select this to base the projection on the order date against the sales order. |
| Ship date | Select this to base the projection on the ship date against the sales order. |
| Projection period | This option enables you to enter a projection date into the future. |
| Days | Select this to print order values in eight columns where the projection period of each column is based on the number of days specified at the Projection days field. |
| Months | Select this to print order values in eight monthly columns (i.e. Past due, current month and six future months). |
| Projection days |
Indicate the number of days on which to base the projection period of each column (i.e. the number of days required to represent each period). |
| Include | |
| Orders in suspense | Select this to includes sales orders that are in a status of suspense (S). |
| Field | Description |
|---|---|
| Order selection | Indicate the sales order(s) to include in the report. |
| Customer selection | Indicate the customer(s) for which you want to include sales orders in the report |
| Branch selection | Indicate the Accounts Receivable branch(es) for which you want to include sales orders in the report. |
The options on this tab enable you to indicate how you want to print order values on the report.
These options only apply if the Accounts Receivable setup option: Foreign currency sales required is enabled (Accounts Receivable Setup).
| Field | Description |
|---|---|
| Show values in | |
| Local currency | Select this to print foreign amounts in the local currency equivalent. |
| Foreign currency | Select this to print foreign amounts in the original currency. |
| Convert to local value at | |
| Entry time | Select this to convert foreign currency values to local currency using the rate at the time the order was processed. |
| Current rate | Select this to convert foreign currency values to local currency using the current exchange rate. |
| Currency selection |
Indicate the currency(ies) for which you want to include the selected orders in the report. Select All to print the value of sales orders regardless of the currency in which they were posted. Alternatively, select Single to only print the value of sales orders that were posted in a specific currency. |
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).
The outstanding value for each order is calculated and printed in one of eight columns according to the number of days into the future that the order is to be shipped.
Orders with a Ship date before (or equal to) the current system date are reflected in the Past due column. The remaining order values are assigned to the relevant time period column based on the entered projection period. For example: If you enter seven day time periods and the ship date of the order is 21 days into the future, then the value of the order is printed in the 15 to 21 Days column.
Values are printed exclusive of tax when the Reduce SO value when tax is inclusive is enabled (Sales Orders Setup) and the tax code used on the sales order was inclusive.
Freight and Miscellaneous charge lines are included in the values on this report.