The Special Price feature enables management to set up special prices by customer or by Group of customers. The Special Prices File is used to store Contract Prices or prices relating to other special deals. These Special Prices apply to selective Titles only, can be calculated in local and foreign currencies, and take priority over the prices stored in the normal Price file. All customer classifications can have individual price rates for particular periods of time. Each price can be individually maintained and can have several chronological entries through the use of the effective and expiry date fields. Formula based pricing allows for customer based prices to be absolute banded prices and not just unit based prices.
The control file TMSDS/PR-AUTH can register authorized user for price maintenance. If this control file does not exist or there is no entry, then all users are allowed price maintenance. If there are entries in the control file, but the user is not registered in it, then all prices will be locked except expiry date in the last entry is allowed to be changed. But the user can still create a new price.
If the user is registered in the control file, then a new function Lock Price/Unlock Price is displayed to allow lock/unlock the prices for maintenance
Add special price for customer(s)
- In the menu, expand Base Modules > Distribution > Masterfiles >Database Management > Database Management > Item Masterfiles > Price & Discount and double-click IM Special Price File. DSM040 Special Price File Maintenance panel appears.
| Field | Description |
| Customer key level | Customer key levels are predefined system codes, summarizing customer data into different levels, that is, the codes can refer to customers only, groups of companies the customers belong to, or to sales representatives dealing with certain customers. |
| Customer class type |
The entry of a Customer Class Type in Minimum Margin Maintenance depends on the selection made in the Customer Key Level field. For example, Customer Key Levels of CA, CZ, C1, C2, C3, C6, C8 and C9 do not require an entry in this field. Customer Key Levels that requires entry here are: C5 and C7. If for example C5 is selected, prompt for valid Customer Classification Type codes in TMSDS/CC-TYPES. Examples of both user and system defined choices are: CC-ACTYP = ACOUNT TYPE CC-BG = BUYING GROUP CC-DTOS = TYPE OF SALES CC-PKG = PROMOTION PACKAGE |
| Customer key | Depending on the selection made in Customer Key Level, an entry may be required in this field. Customer Key Levels that require entry here are: CY, Z, C1, C6, C8. These could refer to groups of companies the customers belong to, sales representatives dealing with certain customers, etc. |
| Exchange code | This field identifies the currency in which the special price of the title is calculated. |
| Type of sale |
Type of Sale Defaults from the previous selection and may be blank if the Price Code does not include a Type of Sale code. The Type of Sale (TOS) code identifies a transaction as being a certain type of sale, such as a Special Sale, Complimentary, Service, etc |
- Enter the required fields and click OK.
- Select an item and click option Select.
| Field | Description |
| Effect | This is the date the discount takes effect. This allows for multiple discounts to be entered in advance but only take effect when the due date is reached. Multiple dates allow for pre-entry of pricing structures. This caters for entering a new price prior to the effective date. When the effective date is reached, the order entry programs pick up the new price. A price history can be maintained in this way. |
| Expiry | This date is part of the Price Break definition and indicates to the system when a particular price expires. When an expiry date is reached, the system looks for the next effective date. An expiry date can be entered when a new price is to take effect. The Effective date of the new price must be entered. |
| Fix prc | Fix Price flag indicates whether backorders supplied after the special price expires should retain the special price or be supplied at the current price. |
| Fix dc | This Fix Discount flag indicates whether backorders supplied after the special price expires should retain the special discount or be supplied at the current discount. |
| RRP | This shows the title’s recommended retail price (RRP). The RRP is shown on inquiries. |
| Quantity Breaks | There are 5 Quantity breaks. It is used to divide quantities to different Prices. |
| Form | In Special Price File Maintenance a Formula code can be entered if formula based pricing is applicable. Customer based special prices can be absolute, fixed price no matter the quantity ordered or unit price which caters for price variations depending on quantity |
| Firm sl |
Indicate if the special price is flagged as a firm sale indicating that this title cannot be returned or refunded. Yes = a firm sale updates the transaction file No = the title is not a firm sale. |
- Enter the required information.
- Click OK to confirm the changes.
