1. Home
  2. /
  3. V7.9 Documentation
  4. /
  5. IP1 Product Documentation
  6. /
  7. User Guides
  8. /
  9. Database Title
  10. /
  11. Price & discount
  12. /
  13. Price file maintenance

Price file maintenance

Multiple prices may be held for each Title and price level by the use of effective dates. This capability allows you to maintain price changes on the system well prior to them becoming effective and without the need to interrupt normal operations.

In order to satisfy electronic product pricing requirements, this program allows 10 price breaks per Title. This allows absolute price banding, where the quantity determines the absolute price to charge. Prices can be recorded as positive or as negative values. A negative price would be used for Rebate purposes.

The Price File can be accessed in two ways:

  1. Via the Title Masterfile on the Database Management Module when adding and maintaining Titles.
  2. Via the Price File on the Database Management Module.

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 toggle function Lock Price/Unlock Price is displayed to allow lock/unlock the prices for maintenance.

Maintain pricing details for an item

  1. In the menu, expand Base Modules > Distribution > Masterfiles >Database Management > Database Management > Item Masterfiles > Price & Discount and double-click IM Price Masterfile. DSM030 Price File Maintenance panel appears. 
  2. Enter the item number and click OK. The existing price codes for the selected item appears on the next panel. 
View the fields on this panel
Field Description 
Price code A Price code usually reflects a Price List. 
Curr This field identifies the currency in which the special price of the title is calculated.  
TOS 

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. 
Ext Prc

This is defined in control file TMSDS/ PR-PRCD.

It can have value as Y=Extend, N=Normal, V=Virtual

For virtual price maintaining the price is not allowed
Description

Short description of the price code.
Price

This field defines the selling prices/prices excluding tax.  All customers are assigned a default pricing code.  This determines which price sales orders and other transactions are charged at.

The first Price Break contains the basic price code and equates to the Unit of Measure on the Title Masterfile. If the price of the title changes with the quantity ordered, enter the quantities with the appropriate prices in the Price Break
  1. Select the price code to maintain and click option Select. DSM030B Price File Maintenance panel appears.
View the fields on this panel
 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. 
Form The price formula is based on the quantity breaks within the Price File Maintenance screen which consists of 10 price breaks.

Formula 1 = Unit price. This is a set price for bulk titles purchased. If more titles are required the price will increase.

For example: We will charge a customer $50000 for 10 titles (ABC). If an additional title is required then they are charged $2000 per title ABC.

Formula 2 = Absolute. This is a set price, the highest price you pay for titles ABC. For example: For 10 ABC titles you pay $50000 and if you require any additional you pay $2000 per title, but if you purchase 50 ABC titles for $60000 that is the most you pay. This is the absolute price.
Qty

The system allows different prices to come into effect depending on the quantity of the title ordered. You are required to complete one or more fields of the Price Breaks. By leaving the Price Breaks blank the system defaults to one price no matter the quantity purchased by the customer. 
Prc

This field defines the selling prices/prices excluding tax. All customers are assigned a default pricing code. This determines which price sales orders and other transactions are charged at.

The first Price Break contains the basic price code and equates to the Unit of Measure on the Title Masterfile. If the price of the title changes with the quantity ordered, enter the quantities with the appropriate prices in the Price Break. 
RRP This shows the title’s recommended retail price (RRP). The RRP is shown on inquiries.
Price break  There are 10 Price breaks. It is used to divide quantities to different Prices. For Ex. From a total of 100 Quantity, first 50 are sold at Rs. 100 each and last 50 at Rs. 150 each.
  1. Enter the required information.
  2. Click OK to confirm the changes.
Print Friendly, PDF & Email