This routine recalculates current sales prices and saves the new prices in the Item file. A validity period can be specified for the newly calculated price.
Any, or all, of the following fields can be used by this function to define either a single or a multiple sales price calculation criteria:
- Item price group
- Supplier
- Currency
- Unit
- Price list
These fields are the defining parameters of the sales price calculation function. By selecting one or more fields a selection criteria is created. The sales price calculation will be applied only to what matches the criteria.
Note: Items which have a Mark-up factor defined, or where FOC is set to YES, will not be updated by this program.
- Item price group
- Enter a code from the Item price group table indicating for which price group new prices should be calculated.
- Supplier
- Enter the supplier number, indicating for which supplier new prices should be calculated.
- Currency
- Mandatory entry. Enter a code from the Currency table, indicating the currency for which new prices should be calculated.
- Unit
- Enter a code from the Unit table indicating for which unit new prices should be calculated.
- Price list
- Enter a code from the Sales price list table indicating for which price list new sales prices should be calculated.
New price
Enter, in the fields below, from when the new prices should apply and the price change as a percentage.
- From date
- Enter the starting date from which the new prices are valid.
- To date
- Enter the end date to which the new prices are valid.
- Change in %
- Enter the price change as a percentage. Note: You are allowed to enter a negative value if the current prices should be reduced.
Price adjusting
In the fields below you define how the new prices should be adjusted. Note: The system will default the price adjusting information defined in the Currency table, but can be changed.
- To value
- Enter, in ascending order, the break levels for price adjustment to the values in the corresponding Adjust to field. Normally the last field shall contain the maximum value (all 9’s).
For example:
To value= 1000
Adjust to = 10If the new price of an item is calculated to 975, the price will be rounded up to even 10, i.e. 980.
Note: The values must be entered in ascending order (from lowest to highest).
- Adjust to
- Enter, for each price range, the adjustment value that a price in the specific price range shall be adjusted to.