This program holds template header information (i.e. name of the template and description). The template code established herein is referred to in the Maintain calculation program, whereby the associated formula information is used in the calculation.
Options
| Lines | Select this option to work with lines for the template. |
Selection fields
- Template
- This column lists the existing templates.
Work with item price calculation templates (DMR75604)
The template header information is defined on this panel (i.e. name of the template and description). The template code established on this panel is referred to in the Maintain calculation program, whereby the associated formula information is used in the calculation.
- Template
Work with item price calculation templates, Copy (DMR75605)
- Template
- Displays the template you selected to copy.
- New template
- Enter the new template that you are creating.
Work with item price calculation templates, Deletion (DMR75608)
Work with item price calculation templates, Lines (DMR75611)
This panel displays the lines that exist for a template. Per line, formula information can be established to be used in the calculation, created in the Maintain calculation program, for a specific interval of items. You can add, change or delete entries.
Options
Function keys
| Renumber | Renumber lines. |
Selection fields
- Line
- This column lists the line numbers that are associated with the selected template.
- Sum to line
- Displays the line number being summarised followed by a plus (+) or minus (-) sign displaying if the lines are being added to or subtracted from either the current line or some other line.
- % of
- Displays the standard value percentage to be used as the default for the item in this line.
- Value
- Displays the standard price value or percentage value being used as the default for the item in this line.
Work with item price calculation templates, Line, Detail (DMR75614)
The information for the line is to be entered/maintained on this panel. This information determines how the calculation is to be calculated, i.e. the formula. When in the Maintain calculation program, a template is referred to whereby the formula is used in the calculation for a specific interval of items.
To simplify matters when establishing line information, the most common method for doing so is to start backwards, i.e. define the line which is to be the sum of the others.
For example:
If 3 lines are to be established, the third line (line 30) would first be defined as the summarised line, with the second (line 20) and first (line 10) being referred to the third line. No set rule need be followed when establishing the other lines, as many scenarios can be created. It is most logical, however, to first establish those lines that are to be referred to.
- Line
- Enter the line number that is to be associated with this template code. To simplify matters, this should be done in intervals of 10. The possibility exists to renumber the lines at a later time, if desired. For existing records, this field cannot be changed.
- Sum to line
- When defining information in this field, three stipulations must be followed:
- the line number being entered must already exist
- the line number being entered must have a higher line number than the line in which you are working (i.e. in the Line field)
- the line number being entered must have the Summarised line field must be set to YES
Calculations are created by summarising the value of lines to other lines, i.e. summarised lines. It is possible to summarise every line to two different summarised lines. In this field enter one or two line numbers that the line in which you are working (i.e. displayed in the Line field) is to be summarised to (i.e. added to (+) or subtracted from (-)).
- Sum to +/-
- When you summarise a line to another you can decide if the summation shall occur with an increase or decrease (i.e. added to/subtracted from). Enter a plus (+) or minus (-) sign under the Sum to line for which the Line number in which you are working (i.e. the Line field) is to be summarised to. If a positive summation is to occur, no sign need be entered.
- Summarised line
- Indicate if the line in which you are working, (i.e. defined in the Line field), is to be the sum of other lines. Note: If this field is set to YES, the following fields must not be completed: Price to retrieve, Standard value amount, Standard value percentage and From line.
- Price to retrieve
- Via the aid of identification codes, you can decide the price data that is to be retrieved from the Item file to be used in the calculation. Valid identification codes for the field are displayed in a window by clicking the prompt window to the right of the field. Note: When calculating new sales prices from purchase prices, supplier discount is used. If this field is completed, the Price to update field, below, must be left blank.
- Price to update
- Price data in the Item file can be updated from a calculation by entering an identification code for the actual line. Valid identification codes for the field are displayed in a window by clicking the prompt window to the right of the field.
Note: If the code for Retail price is defined in this field, the update of this information in the Item file will only be done as an amount. Therefore, if this field in the Item file was defined as a percentage, this information will be replaced with the updated amount information and the code indicating the type (i.e. percent) will also be changed to indicate amount.
Note: If this field is completed, the Price to retrieve field, above, must be left blank.
- From/To Warehouse
- This field is mandatory if:
- the Price to retrieve (for the From warehouse) is set to 07 (standard cost) or 10 (standard purchase price).
or
- the Price to update (for the To warehouse) is set to 10 (standard purchase price).
Note: If the values of the Price to retrieve or Price to update parameters have been defined as above and this field is left blank, then the system will retrieve the value of the Main warehouse from the DIS control file.
This warehouse field controls how the Standard cost or Standard purchase price is retrieved by the Item file update routine (DMR751). These parameters are defined in the Item file at both the item level and the warehouse level. How the system retrieves the costs also depends upon how the Cost per warehouse controlling parameter is defined in the DIS control file.
- If Cost per warehouse is set to NO in the DIS control file.
Enter a warehouse code. This will update all of the costs that have been defined for it at the warehouse level. No bookkeeping transactions will be produced.If a value is not entered in this field then the cost will be updated at both the item and warehouse level for all warehouses. If the Cost type is set to 2 (Standard cost) this will also create bookkeeping transactions to adjust your stock value for all warehouses. Note: If the Cost per warehouse parameter is set to NO in the DIS control file you can still calculate the cost prices per warehouse. Simply run a separate update for each warehouse.
- If Cost per warehouse is set to YES in the DIS control file.
Enter a warehouse code. This will update all of the costs that have been defined for it at the warehouse level. No bookkeeping transactions will be produced. If Cost type is set to 2 (standard cost) bookkeeping transactions will be created to adjust your stock value for this warehouse.If a value is not entered in this field then the cost will be updated at item level for all warehouses. No bookkeeping transactions will be created.
- the Price to retrieve (for the From warehouse) is set to 07 (standard cost) or 10 (standard purchase price).
- Price list
- If the Price to retrieve or Price to update fields have defined a code for Sales price or Retail price then this field is mandatory. Enter a code from the Sales price list table indicating the sales price list to be used.
- Display line
- Indicate if this line information is to be displayed when working in the Maintain calculation program to help with maintenance. If nothing is entered the system interprets it as a YES setting, meaning that the line is displayed.
- Std value amount
- If the value for the line is not to be retrieved via the identification code method, (i.e. as defined in the Price to retrieve field), a default standard value can be entered in this field. Enter the standard value to be used as the default for the item in this line.
- Std value percentage
- If the value for the line is not to be retrieved via the identification code method, (i.e. as defined in the Price to retrieve field), a default standard value % can be entered in this field. Enter the standard value % to be used as the default for the item in this line. If this field is completed, the From line field must also be completed indicating from which line this percentage is to be calculated.
- From line
- Completion of this field is dependent upon two scenarios:
- If the entry in the Price to retrieve field has been defined with the code for Retail price, this field is mandatory. This field in the Item file can be defined as a percentage or an amount. If defined as a percentage it is important that a line number is defined in this field indicating to which line number this percentage is to be referred. This is due to the fact that a percentage value on its own has no meaning. This line’s value must be calculated as a percentage of another line.
If, however, the value in the field in the Item file contains an amount, the entry in this field will be ignored during the creation of a calculation in the Maintain calculation program and the retrieved price will be handled as normal.
- If a Standard value percentage has been defined in the field above, this field is mandatory, indicating from which line the percentage should be calculated.
- If the entry in the Price to retrieve field has been defined with the code for Retail price, this field is mandatory. This field in the Item file can be defined as a percentage or an amount. If defined as a percentage it is important that a line number is defined in this field indicating to which line number this percentage is to be referred. This is due to the fact that a percentage value on its own has no meaning. This line’s value must be calculated as a percentage of another line.
Work with item price calculation templates, Lines, Copy (DMR75615)
- Line
- Displays the lines you selected to copy.
- New line
- Enter the new lines that you are creating.