Related topics
In this program you can generate statistics for sales order related information. DC1 Distribution allows you to generate various types of statistics, depending on your needs. See Maintain and print statistics for sales for more information.
Options
| Select this option to access the Sales statistics file printout routine. |
Selection fields
- Spec
- This column lists the sales statistics specifications that have been defined.
- Description
- This column lists the descriptions of the sales statistics specifications.
Work with sales stat specifications (DMR80004)
This panel displays a number of Item-related keys that can be used in the statistics. Additional keys can be found on the next panel.
Note: The Item segment 1 field will only be displayed if Item segmentation is activated in the system (as defined in the DIS control file).
- Spec
Seq
Work with sales stat specifications (DMR80005)
This panel is only displayed if Item segmentation is activated in the system (as defined in the DIS control file). On this panel there are additional Item-related keys (Item segment 2 through 4) to be defined in the same manner as those on the previous panel.
Seq
Work with sales stat specifications (DMR80006)
This panel is only displayed if Item segmentation is activated in the system (as defined in the DIS control file). On this panel there are additional Item-related keys (Item segment 5-6 and Primary segment) to be defined in the same manner as those on the previous panel.
Seq
Work with sales stat specifications (DMR80007)
This panel contains Customer-related keys to be defined in the same manner as those on the previous panel.
Note: The sequence figures must be entered in an uninterrupted sequence starting with 1. If an error message is indicated for the sequence on this panel the error might be on the previous pages, or there might be an inconsistency between the two.
Seq
- Date
- The range selection is used for indicating this period. The year to date values are calculated from January 1 in the indicated year. Enter the dates from which and to which the previous information selected for the statistics printout should be included on the printout. The dates entered in this selection can be overridden when actually printing the statistics from the statistics print routine.
Work with sales stat specifications (DMR80009)
On this panel you can define to show period or year-to-date information for the following current and/or past year information:
- Total sales value
- Net sales value
- Profit
- Quantity
Values
The following information that can be included on the printout is displayed in the form of a 4×4 matrix. The information corresponding to each value is automatically updated by the system when the user performs any sales associated transactions.
The following values are available:
- Total sales value is the sales value before any discounts.
- Net sales value is the turnover, i.e. total value less discounts.
- Profit is the profit amount for the sales calculated by subtracting the cost value from the net sales value. The cost value is calculated according to the defined cost method in the DIS control file.
- Quantity is the quantity sold.
Periods
The different values can be printed for the following periods:
- the given period
- from the beginning of the year to the end of the period
- the corresponding period the previous year
- from the start of past year to the end of the period past year
The preferred values are selected by entering the valid codes for YES, NO, or % in the matrix. YES means that the total value for the corresponding key will be printed. NO means that no information for the corresponding key will be printed. By entering % the total value for the corresponding key will be printed as well as the percentage of the total value that each line represents for the selection.
Note: In regards to the four Profit related fields, an additional code can be entered, namely an asterisk (*). By entering an asterisk (*) in any of these fields, the profit margin will be printed.
- Internal orders
- Enter a code indicating if Internal replenishment orders should be included in the printout.
Code Description 0 All orders will be included. 1 Only Internal replenishment orders will be included. 2 No Internal replenishment orders will be included.
- Edit code (1, 2, 3)
- This code determines the presentation of the figures.
Code Description 1 with decimals (2 for amounts, 0-3 for quantities) 2 without decimals 3 rounded to hundreds, printed with thousand separators The amount 457114.55 will be printed as follows:
1 457,114.55 2 457,115 3 457.1 Be aware that the higher the edit code, the more columns on the list.
- Print details
- Indicate if the invoice/reception line details from the Statistics file should be printed. Normally this field should be set to NO.
- Characters per inch
- Enter the number of characters per inch that should be used for the list. Valid entries are 10 and 15. Remember that 15 allows more columns but is not accepted by all printers.
Work with sales stat specifications, Copy (DMR80010)
- Spec
- Displays the statistics specification you selected to copy.
- New spec
- Enter the new statistics specification you are defining.