# Net Sales Revenue by Period by Customer (SALES.R23)

Read Time: 3 minute(s)

#

Job ID Enter a unique ID if you wish to enter and save the parameters to this procedure for future use. If you only need to run the procedure and do not want to save your entry then you may leave this field empty.

Destination Select the destination for the output from this procedure.

Process Select the method to be used for processing the report. Foreground is always available and must be used when output is directed to anything other than a system printer (i.e. printers spooled through the database on the host computer.) Depending on your setup there may be various batch process queues available in the list that allow you to submit the job for processing in the background or at a predefined time such as overnight. A system printer must be specified when using these queues.

Format Select the format for the output. The availability of other formats depends on what is allowed by each procedure. Possible formats include Text, Excel, Word, PDF, HTML, Comma delimited and Tab delimited.

Layout You may indicate the layout of the printed page by specifying the appropriate setting in this field. Set the value to Portrait if the page is to be oriented with the shorter dimension (usually 8.5 inches) at the top or Landscape if the longer dimension (usually 11 inches) is to be at the top. Portrait will always be available but Landscape is dependent on the output destination and may not be available in all cases.

Copies Enter the number of copies to be printed.

Run Process Click on the button to run the process. This performs the save function which may also be activated by clicking the save button in the tool bar or pressing the F9 key or Ctrl+S.

C)alendar or F)iscal Period Enter the letter "C" if you want to report by calendar period. "F" will report by fiscal period as defined by the FY.E procedure.

Start Month/Period If you are reporting by calendar period, enter the number of the month to be used as the first period in the report. For example, enter 1 for January, 2 for February etc. If you want to report by Fiscal period, enter the period number.

Start Year Enter the year to use along with the month in the previous prompt to define the first period. You must enter the full year such as 1990.

S)ummary or D)etail The entry in this field determines if all of the detail data should be included in the report, or if only the summary totals should be shown. Enter "D" to include the details, or "S" for summary.

Print Options If you wish to only show the quantity sold for each rep, enter QUANTITY in this field. If you only wish to show the dollars sold, enter DOLLARS.

If you wish to show both dollars and quantities enter BOTH in this field or leave the field blank. If this option is selected, two lines for each rep will appear on the report. The first line will display the dollars and the second line the quantities. If no option is selected both the quantity and dollars will appear on the report.

Category Enter categories if you want to limit the output to certain part categories.

Co Code Enter the company codes you wish to appear on this report. If left blank all company codes will be included.

Last Status Message Contains the last status message generated by the program.

Last Status Date The date on which the last status message was generated.

Last Status Time The time at which the last status message was generated.

Version 8.10.57