This process is used to create and update sales price lists. Sales price lists include sales prices for items and are used when entering customer order lines for automatic customer order line pricing. Sales price entries (for sales prices) can also be defined for sales price lists and internal inspection entries for sales price.
Sales price is the price paid by the customer per sales price unit of measure and sales price quantity. This price per item can be entered in for example, the item file or a price list. During customer order entry, the sales price is automatically retrieved according to a specified order of priority. This price can be manually changed for each order line if allowed by the customer order type.
The process can be started when the following prerequisites are met:
The section below describes the activities in this process.
Define Costing Model
To calculate a price list, it must first be connected to a costing model. Costing models describe how prices are calculated by using markups or markdowns.
A calculation base is entered for each costing model. Examples are the sales price from the item file or the purchase price. The markups and markdowns are calculated from the selected calculation base.
The costing model is entered in 'Sales Costing Model. Open' (OIS022) and then connected to a price list in 'Sales Price List. Open' (OIS017/G).
When prices for items in a price list are to be calculated, the values are retrieved from the calculation base. The values from the base are then adjusted with the markups or markdowns defined for the model in 'Sales Costing Model. Open Lines' (OIS023).
Define Sales Price List
Sales price lists are entered in 'Sales Price List. Open' (OIS017). Unique IDs for the price lists are made up of a combination of price list code, currency code and start date.
The validity date (start and end dates) of the price list can be used to plan price changes and time-limited sales campaigns in advance. This is done by defining a price list using different periods for a combination of price list code and currency.
By specifying a campaign for a price list or selection of items, different campaigns can be followed up in the sales statistics.
In most cases, the sales price is only one of the factors determining how much a customer will pay for an item. Other factors affecting the price include discounts and bonus agreements. Each price list indicates whether these factors should be included in the calculation of the sales price.
However, it is possible to make exceptions for each item included in the price list.
If a price list should contain only a limited selection of items, the selection is made on the F panel in 'Sales Price List. Open' (OIS017).
On the E panel in 'Sales Price List. Open' (OIS017), the security level for the price list is defined. This level determines whether it is permitted to enter items not included in the price list's specified item selection.
There are three security levels:
When a price list is calculated/updated in 'Sales Price List. Update' (OIS310), it is shown how the item selection was made. The selection can be limited even further to include the items to update.
In the 'Manual update' field in 'Sales Price List. Open' (OIS017/E) it is indicated whether sales prices may be changed manually for items included in a price list. Note that the value entered in the 'Sls price rule' field in 'CO Type. Open' (OIS010/J) overrides the value entered in panel 'Sales Price List. Open' (OIS017/E).
If the price list is blocked for manual changes, it must be calculated using a sales price costing. When this calculation is requested by specifying option 16 = Price list update, the update alternative is selected in the 'Function sel' field in 'Sales Price List. Update' (OIS310/E). You can choose to
The price list is later recalculated and updated according to the selection. See the description of linked price lists below.
One or more price lists can be connected to another price list (basic price list). In this way, several active price lists can be used at the same time. For example, a general price list can be the base for several lower-level price lists that deal with different market segments or regions.
A price list is connected to a basic price list by entering it in the 'Basic prc list' field in 'Sales Price List. Open' (OIS017/G) for the price list to be connected. The result is that the linked price list uses the basic price list's items and prices as the basis for calculating sales prices.
In order for the linked price list to be affected by the basic price list, it must be connected to a costing model with calculation base 6 (Basic price according to another price list).
If the 'Auto calc' field is activated for the linked price list in 'Sales Price List. Open' (OIS017/G), the linked price list can be updated automatically when the basic price list is updated. This is done by specifying an alternative for automatic updating in the 'Function sel' field in 'CO Charge. Open' (OIS030/E) when updating the basic price list. If several price lists are connected to the basic price list, these are displayed and the price lists to be updated can be selected.
Scales are used to calculate quantity-dependent sales prices. The scale indicates how a price changes depending on the quantity entered during order line entry.
The scale is creating by entering ascending limit values. Each limit has a price adjustment factor. This factor is a percentage that is multiplied by the item's basic price. Therefore, when the basic price for an item is changed, the scale does not need to be updated or changed.
Scales are entered and updated in 'Sales Price Scale. Open' (OIS024). They are general and can be used by different items and price lists at the same time.
To connect a scale to a price list, at least one key for scale factors must be entered in panel 'Sales Price List. Open' (OIS017/E).
A key is a field that acts as a general selection key in order to qualify a scale for a price list. One or more values are then entered for the key, and are specific for that key. For example, if item group is used as the key, different item group identities can be entered as values.
After a key is entered, a heading is displayed for the field selected as the key in 'Sales Price List. Connect Price Scale' (OIS026). This program is accessed by specifying option 12 = Scale keys in 'Sales Price List. Open' (OIS017).
When a value is entered for a key in program 'Sales Price List. Connect Price Scale' (OIS026), the scale to use if an item matches the selection key is also specified. See the example below.
Note that each scale is defined for both a scale U/M and a price U/M. Therefore, the item's price U/M in a price list must correspond to the price U/M for which the scale is entered.
When items and prices are automatically generated in a price list, the scale's price U/M is used if it is valid for the item. If it is not valid, the scale will not be used. Instead, the price U/M and the price quantity will be retrieved from the item file.
A company uses different scales for different item groups. Group 1 uses Scale 1, and Group 2 uses Scale 2. MMITGR (item group) is then entered as a key in the Key field in 'Sales Price List. Open' (OIS017/E).
In 'Sales Price List. Connect Price Scale' (OIS026/B), Group 1 is entered as a value. In panel 'Sales Price List. Connect Price Scale' (OIS026/E), it is specified that Scale 1 should be used for item group Group 1. Group 2 is then entered as a value in 'Sales Price List. Connect Price Scale' (OIS026/B) and Scale 2 in 'Sales Price List. Connect Price Scale' (OIS026/E).
Result: Scale 1 will be used to calculate the sales price for all the items in the price list belonging to item group Group 1. All items belonging to Group 2 will be calculated according to Scale 2.
A round-off category can be specified for each price list in 'Sales Price List. Open' (OIS017/E). This defines how prices are to be rounded off.
Note that both the basic price and graduated prices are rounded off according to the specified category. However, a basic price that is not rounded off is used to calculate prices according to the scale.
The basic price per item can be updated for each price list in 'Sales Price List. Open Basic' (OIS021). This program is accessed by specifying option 11=Basic prices in 'Sales Price List. Open' (OIS017).
In 'Sales Price List. Open Basic' (OIS021), the price calculated for an item in a price list can be changed. Information such as U/M, quantity and scale U/M can also be entered or changed.
If no scale is used for the price list, graduated prices can be entered for an item in 'Sales Price List. Enter Graduated Prices' (OIS018). This program is accessed by specifying option 11=Grad prices from program 'Sales Price List. Open Basic' (OIS021).
Prices can also be updated manually in 'Sales Price. Simulate' (OIS325). The simulation result is proposed as the basic price. This proposal can be changed before an update is made.
Simulate Costing Model
The main purpose of simulating item prices is to check that a costing functions correctly. The simulation is made for an item in a price list according to a specified costing model.
The sales price for an item is calculated from a specified costing base, with markups/markdowns according to the selected costing model.
The figure below illustrates how the sales price costing is structured.
A costing model contains a costing base and costing element. The costing elements can either be type 1 elements (for calculating the basic price) or type 2 elements (order-dependent elements for calculating markups or markdowns during customer order entry). Type 2 elements do not affect the calculation of prices in the price list.
When the sales price is simulated for an item, the costing model to use is specified.
When a costing model is retrieved from the price list or entered in the 'Costing model' field, the model's costing base is retrieved and displayed in the 'Base' field. The costing base is used to retrieved the starting price to use in the simulation. In this way the same price costing can be used in different price lists even if the base itself varies. Examples of a costing base are the sales price in the item file or the purchase price.
If a price list uses a sales price costing based on a purchase costing (costing base 4), a purchase costing must be entered for the price list in (OIS017/G).
The main purpose of price simulation is to calculate a basic price for an item, in other words a price in the price list. Through changing the costing model or costing rates, different results can be obtained.
The available costing elements are listed in 'Sales Price. Simulate' (OIS325), and can be obtained via F4 = Browse.
When simulating the sales price, it is possible to take into account order-dependent costing elements. This is done by changing the values for the fields entered for the order-dependent element's keys. In this way, it is also possible to simulate the markups or markdowns that are normally first calculated when entering an order line.
Order-dependent costing elements are used to mark up/down the price list's basic price during customer order entry. For example, such an element can be used to vary freight costs depending on the ordered quantity, method of transportation, country, etc.
If a costing model uses a purchase costing as a base, the purchase costing can be displayed. By doing this, the calculation can be followed from the purchase price up to the final sales price.
Different scenarios can be simulated by varying information such as supplier, purchase price, discounts, order quantities, etc.
If a costing model has another price list as a base, the sales price can be simulated in these two ways:
If price list 2 uses price list 1 as the base, and price list 1 is based on a cost price according to the purchase costing, the total calculation for price list 2 is displayed as follows:
Update Sales Prices
Sales prices for items included in a sales price list can be updated in four ways:
Report Processing for Sales Price
It is possible to create and run sales price reports in 'Sales Price Report. Open' (OIS530). One example of a report is an internal inspection report for sales prices for analysis of gross profit.