Related topics
- About setting up sales price lists
- Allocate matrix pricing for items in a sales price list
- About unit handling in DC1
- Setting up the item matrix functionality
This program can be accessed via the following:
- Item file
- Work with sales price lists
In this program sales price information, held in a price list, is defined for an item, as well as discounts and any quantity dependent prices that are either predefined (i.e. held in a quantity dependent limit code) or uniquely defined against the item.
Sales prices are entered for a combination of item, currency, unit and price list for a single period, or multiple periods via validity dates (from-to dates). If accessing the routine from the Item file, depending on the option you have chosen, some fields may already be completed with defaults. Some may also be protected, i.e. the cursor will bypass them when you work your way through the fields. This will not apply if accessing the routine from the Work with sales price list routine where no fields, except the Y/N ones, will have defaults.
Sales prices for a price list can be defined in one of the following five different ways:
- Price
A fixed price can be defined. - Cost basis
The sales price will be calculated based on the cost price of the item together with a margin or mark-up combined with a factor or percentage.Note: There are several ways of defining what the cost price of the item is, such as standard cost at item level or average cost at warehouse level. The full list of these can be found in the Cost bases table.
For example:
A sales price may be calculated by applying a 20% mark-up on the standard cost at item level. - Qty limit disc.
Using a Limit code based upon quantity, discounts can be applied according to the quantity sold (volume discounts). - FOC
Items can be offered free-of-charge. - Qty dependent prices
Sales prices are defined according to the volume of goods sold.
Quantity dependent prices are defined on this panel by setting the Qty dep price field to YES and clicking Quantity dep prices to access the Qty dep sales prices panel where information regarding quantities and pricing/markdown is defined.
Note: Sales prices do not have to be defined. However, during Sales/Quotation order entry, the system will prompt the employee registering the order, to enter a sales price for the item.
Options
| Delete | Select this option to delete/inactivate a record.
Note: If you select this option to delete a sales price for a matrix base item or a specific matrix item, you will be prompted with the Delete matrix sales price panel directly after the confirmation of the deletion where it will be possible to delete the price from corresponding matrix items. |
| Quantity dep prices | Select this option to define quantity dependent prices for this particular item, currency and price list combination. This function key will not be displayed in Enquiry mode. |
| Allocate matrix price | This option is only displayed if the following is true:
Select this option to allocate matrix prices from a matrix base item or from a specific matrix item. |
Function keys
| Show current/historic/all periods | Toggle the sales prices per current/historic and all periods. |
| View controls | Access the View controls window. From this window you can, e.g., set up the number of text lines that should be displayed as well as define sequences and views. |
- Item
- Displays the item code and description.
- Currency
- Displays the currency and description.
- Sales unit
- Displays the sales unit and description.
- Catch weight
- This field is only displayed if the CTCH-WGT (Catch weight) function is activated in the Function control file. The setting is retrieved from the Item file maintenance, Units panel. If the Catch weight flag is set to YES for the sales unit on that panel, this field will be set to YES and cannot be changed here. It denotes if the catch weight handling will be used for the item/unit on sales orders. See About catch weight handling for price units for more information.
- Price list
- Displays the sales price list and description.
- From date
- This column lists the start date of the price validity period (including any quantity dependent prices).
- To date
- This column lists the end date of the price validity period (including any quantity depended prices).
- Price
- This column lists the sales price of the item.
- Prc unit
- Only displayed if the PRCUNIT (Price unit handling) function is activated in the Function control file. This column lists the unit in which the price is presented. See About price unit handling for more information.
- Basis
- This column lists the code indicating how your company wishes to define the basic cost of an item.
- FOC
- This column lists the code for YES if this price is free of charge.
- Manual
- This column is displayed if the CLA-COPR (Classification costing/pricing) function is activated in the Function control file and lists the code for YES if a price was manually entered; not if the price was automatically downloaded via Item classification or via the Download prices function key on the Item file maintenance, Sales prices panel.
Item file maintenance, Sales price per period, Details (DIR83604)
Work with sales price lists, Items, Sales price per period, Details (DIR83604)
The details of the sales pricing per period are entered here.
Forward Maintenance
If this panel is accessed from the Forward Maintenance program then it will be titled Work with forward maintenance proposals, New values, Items/Sales prices.
Function keys
| Quantity dep prices | Define quantity dependent prices for this item, currency and price list combination. This function key will not be displayed in Enquiry mode. |
| Allocate matrix price | This function key is only displayed if the following is true:
Allocate matrix prices from a matrix base item or from a specific matrix item. |
- Item
- Displays the item for which price are being entered/maintained.
- Currency
- Displays the currency in which the prices are expressed for this item/price list.
- Catch weight
- This field is only displayed if the CTCH-WGT (Catch weight) function is activated in the Function control file. The setting is retrieved from the Item file maintenance, Units panel. If the Catch weight flag is set to YES for the sales unit on that panel, this field will be set to YES and cannot be changed here. It denotes if the catch weight handling will be used for the item/unit on sales orders. See About catch weight handling for price units for more information.
- Price list
- Displays the sales price list.
- From date
- Enter the start date of the validity period for the prices.
- To date
- Enter the end date of the validity period for the prices. This date can be changed once a price is created, even when the functionality for Short term pricing is activated. When a price with overlapping dates is created, a warning message will be displayed to inform the user about this situation.
- Manual
- This field is displayed if the CLA-COPR (Classification costing/pricing) function is activated in the Function control file and is automatically set to YES if a price was manually entered; not if the price was automatically downloaded via Item classification or via the Download prices function key on the Item file maintenance, Sales prices panel.
- Sales price
- Enter the sales price of the item.
- Price unit
- Only displayed if the PRCUNIT (Price unit handling) function is activated in the Function control file. Displays the unit in which the price is presented. See About price unit handling for more information.
- Promotions
- The setting in this field is defaulted from the corresponding field in Work with sales price lists for the sales price list, but can be changed. Set this flag to YES if the sales price list is eligible for promotional pricing, i.e. being allowed to be compared against prices from sales promotions. When a price is automatically retrieved for a sales order line, the retrieved price will be compared to the pricing from a sales promotion, if such promotion pricing exists, to get the lowest price. If this flag is set to NO, no comparison against promotion pricing will take place.
- Basis
- Select a code from the Cost bases table to indicate how your company wishes to define the basic cost of an item.
- Margin/Mark-up
- Enter a value indicating the method (i.e. Margin or Mark-up) that you want to use to generate the sales price from the cost price.
Value Description 1 Margin 2 Mark-up Note: This field is used in conjunction with the Factor/Percentage, and Value parameters and can only be completed if the Sales price field is blank.
The following formulae are used to calculate a sales price based upon margins and mark-ups:
Margin
Base Price / ((100 – %) / 100) = Sales Price
Base Price / (1 – Factor) = Sales PriceMark-up
Base Price x ((100 + %) / 100) = Sales Price
Base Price x (1 + Factor) = Sales PriceFor example:
- If the Cost Basis selected on this panel is ACI Average Cost/Item
- If the average cost of the item value = 10 GBP (defined on the Item file maintenance, Inventory information panel (DMR00302)
- If the Margin/Mark-up method selected for calculating the sales price is Mark-up
- If the type of mark-up used in the calculation is a factor and not a percentage (defined in the Factor/Percentage field)
- And the Value of the mark-up is defined at 1.5
- Then the sales price will be calculated as:
- 10 * (1 + 1.5) = 25
- Factor/Percentage
- Enter a value indicating how you want the Margin or Mark-up to be calculated. Note: This field is used in conjunction with entries in the Margin/Mark-up and Value fields.
Value Description 1 Factor. The Mark-up or Margin will be multiplied by a factor.
Note: You enter the value of the factor in the Value field.2 Percentage. The Mark-up, or Margin value will be increased according to a percentage.
Note: You enter the value of the percentage in the Value field.
- Value
- This field is used in conjunction with the entries in the Margin/Mark-up, and Factor/Percentage fields. Note: This field is not mandatory when basis is used, i.e. it is possible to leave the field blank (zero) in which case the calculated sales price will be equal to the cost price.
- If the value of Margin/Mark-up is 1 and the value of Factor/Percentage is 1, enter the margin factor.
- If the value of Margin/Mark-up is 1 and the value of Factor/Percentage is 2, enter the margin percentage.
- If the value of Margin/Mark-up is 2 and the value of Factor/Percentage is 1, enter the mark-up factor.
- If the value of Margin/Mark-up is 2 and the value of Factor/Percentage is 2, enter the mark-up percentage.
- Qty dep prices
- Indicate if quantity dependent prices are allowed. To enter the details click the function key for Quantity dep prices. Set the field to YES or NO to include/exclude the limits from the detail level. Note: To include limits from higher level, leave the field blank.
- Matrix limits
- This field is only displayed if the item on the panel is either a matrix item or a matrix base item (and provided that the ITEMMTRX (Item matrix) function is activated in the Function control file). Set this field to YES if the quantity limits that are defined shall be compared to the total ordered quantity for the whole matrix (i.e. not for the single matrix item).
- Qty limit code
- By using this field a quantity dependent discount can be applied according to the quantity entered on the sales order or quotation line. Enter a quantity based code from the Limit codes table, indicating the discounts to apply to the quantity entered on the sales order or quotation line.
- FOC
- Indicate if the item is free of charge.
- VAT included
- Indicate if VAT is included in the sales price of the item. This code is defaulted to the sales order line, where it can be changed.
- Incl VAT% code
- Enter the VAT handling code for the VAT percentage, if any, which is included in the sales price. If the VAT included field is set to NO, this field must be blank. If you are maintaining an existing entry, the information can be changed or deleted.
- Main discounts
- A price list could be connected to a sales pricing method (type = normal), contract or promotion; all of which could hold discounts. If you want to prevent any discounts from the main pricing source from being picked up for this price list (other than the ones flagged with YES below for this price list) set this flag to NO. If you want all discounts from the main pricing source to be picked up for this price list, set this flag to YES.
- Chain discounts
- This field is only displayed if the Chain discount field is set to YES in the DIS control file. Set this flag to YES if chain discounts can be applied on top of prices and discounts generated from this sales price list for this item/unit/currency combination. The actual chain discounts to be applied are set up in the Sales pricing methods file as type C (Chain discount).
- Order summary disc
- This field is only displayed if the Order summary disc field is set to YES in the DIS control file. Set this flag to YES if order summary discounts can be applied on top of prices and discounts generated from this sales price list for this item/unit/currency combination. The actual discounts to be applied are set up in the Sales pricing methods file as type O (Order summary line discount) and H (Header discount).
- Retail method
- This field is used to generate the retail price from the sales price. The retail price is a recommended value that will be printed on the invoice. Enter a value indicating the method that you want to use to generate the retail price from the sales price.
Value Description 1 Margin 2 Mark-up 3 Value Note: This field is used in conjunction with the entries in Retail value, and Retail factor/perc.
The following formulae are used to calculate a retail price based upon margins and mark-ups:
Margin
Base Price / ((100 – %) / 100) = Retail Price
Base Price / (1 – Factor) = Retail PriceMark-up
Base Price x ((100 + %) / 100) = Retail Price
Base Price x (1 + Factor) = Retail PriceFor example:
- If the Cost Basis selected on this panel is ACI Average Cost/Item
- If the average cost of the item value = 10 GBP (defined on the Item file maintenance, Inventory information panel (DMR00302)
- If the method selected for calculating the retail price is Mark-up
- If the type of mark-up used in the calculation is a factor and not a percentage (defined in the Retail factor/perc field)
- And the Value of the mark-up is defined at 1.5
- Then the retail price will be calculated as:
- 10 * (1 + 1.5) = 25
- Retail factor/perc
- This field is used to determine the recommended retail price that will be printed on the invoice sent to the customer. Note: This field is used in conjunction with the entries in Retail method, and Retail value. Enter a value indicating how you want the Retail Method (e.g., Mark-up, Margin) to be calculated.
Value Description 1 Factor. The Mark-up or Margin will be multiplied by a factor.
Note: You enter the value of the factor in the Retail value field.2 Percentage. The Mark-up or Margin value will be increased according to a percentage.
Note: You enter the value of the percentage in the Retail value field.
- Retail value
- This field is used to generate the retail price from the sales price. The retail price is a recommended value that will be printed on the invoice. Note: This field is used in conjunction with the entries in Retail method, and Retail factor/perc.
- If the value of Retail method is 1 and the value of Retail factor/perc is 1:
Enter the margin factor. - If the value of Retail method is 1 and the value of Retail factor/perc is 2:
Enter the margin percentage. - If the value of Retail method is 2 and the value of Retail factor/perc is 1:
Enter the mark-up factor. - If the value of Retail method is 2 and the value of Retail factor/perc is 2:
Enter the mark-up percentage. - If the value of Retail method is 3
Enter the fixed retail price.
- If the value of Retail method is 1 and the value of Retail factor/perc is 1:
Item file maintenance, Sales price per period, Copy (DIR83605)
Work with sales price lists, Items, Sales price per period, Copy (DIR83605)
On this panel you can create new sales prices per period by copying an existing.
- Item
- Displays the item code and description.
- Currency
- Displays the currency and description.
- Sales unit
- Displays the sales unit and description.
- Price list
- Displays the sales price list and description.
- From date
- Displays the start date of the validity period for the record being copied.
- To date
- Displays the end date of the validity period for the record being copied
- New from date
- Enter the new start date of the validity period.
- New to date
- Enter the new end date of the validity period.