Report Average Value of Sales Orders

Access

Use this report to display the average of merchandise subtotals for sales orders (and, optionally, layaways).  You can generate the report for written or completed orders. The report

• includes regular, direct ship and as-is orders.

• sorts by location, by salesman, by order.

• does not include values for exchanges, returns, adjustments, or quotes.  

Once the report criteria have been selected, click Run to produce the report.

The output of this report may be affected by Regional Processing restrictions. That is, you can inquire only about customers and locations to which you have access.

Date CodeClick on the Arrow button to view a list of date codes, then select the code that best indicates the time period on which to base your report.  

Start DateIf you select CUS at the Date Code field, you activate this field.  Use this field to specify the start date of the custom date range for which you want to run this report. If you click on the Calendar Icon, you can select a date from the calendar that appears.

If you select another date code instead of CUS, this field fills in based on that selection and you cannot edit this field.

End DateIf you select CUS at the Date Code field, you activate this field.  Use this field to specify the end date of the custom date range for which you want to run this report. If you click on the Calendar Icon, you can select a date from the calendar that appears.

If you select another date code instead of CUS, this field fills in based on that selection and you cannot edit this field.

SalespersonEnter the code of the salesperson you want to include in the report. If you click on the Search button, a list of salespersons appears from which you can choose.  If you click on the Action button, the Multiple Salesperson Selection Window appears from which you can choose.  If you leave the field blank, you select all salespersons.

DistrictEnter the code of the district to which to restrict this report. If you click on the Arrow, a list of available districts appears from which you can choose one or more. If you click on the Action button, the Multiple District Selection window appears from which you can choose one or more.  If you enter a district at this field, you de-activate the Location field below.

Location Enter the code of the store to which to restrict this report. If you click on the Arrow, a list of available stores appears from which you can choose one or more. If you click on the Action button, the Multiple Location Selection window appears from which you can choose one or more.  If you enter a store at this field, you de-activate the District field above.

Based On

Include LayawaysTo include layaways in the report, check the box at this field.  Otherwise, leave the field blank. Note that if you select Completed at the Based On field, you inactivate this field.

Summary OnlyTo print only summary information, check the box at this field.  Otherwise, leave the box blank.  

If you leave the box blank, one line prints for each sales order or layaway you select for processing. If you check the box at this field, the report outputs only lines at breaks (that is, salesperson, location, grand total).  

Send Output toThe output destination of the report displays.  To change the output destination, click on the Actions button and select Output Settings.

Export PathIf you select either the Personal Report Viewer (PRV (Personal Report Viewer) A STORIS printer output option that allows you to customize report results, for example to rearrange data columns.), Excel Export, or ASCII Export, this field displays the pre-set computer drive and folder location to which the system exports the report data. You cannot edit the export path using this process.