Global repricing allows for the automatic calculation of prices by Title, starting from a selected date. The price basis code determines the unit cost to be used in the calculation of the Title’s price. The repricing routine may range from all Titles down to one specific Title or Title classification. The price definition tables and the rounding tables are used to calculate a suggested new selling price.
The price calculation program can be set up using TMSDS/PO-COST to use the buying price file to override the Title Masterfile when calculating title prices. TMSDS/PO-COST must have DSO300 defined and ‘B’ for buying price file and for the first character of the control description and buying price ID for the last three characters.
This program will assume today’s date if the effective date is zero.
When pricing changes are made, this Global Repricing process must be run for the changes to become effective and before the Auto Price Recommendation Report is run for Review.
The system automatically converts the price basis requested when running the ‘Global Pricing’ (DSO020) as per the following.
| Entered price basis | Price basis used by the system |
| 1. (Shipping invoice gross trade buying price) | 5. (Title master gross trade buying price) |
| 2. (Shipping invoice gross base buying price) | 6. (Title master gross base buying price) |
| 3. (Shipping invoice net trade buying price) | 7. (Title master net trade buying price) |
|
4. (Shipping invoice net base buying price) |
8. (Title master net base buying price) |
| A. (Shipping invoice trade unit cost) | 9. (Title master unit cost) |
| B. (Shipping invoice base unit cost) | |
| G. (Estimated Landed Cost) |
Price basis 1, 2, 3, 4, A, and B which are using shipping invoice buying price are only relevant in the ‘Shipping Repricing’ (DSO050) where the user will need to enter a specific shipping number.
Automatic calculation of prices by item
- In the menu, expand Base Modules > Distribution > Masterfiles > Auto pricing > Update Process and double-click AUP Global Repricing-Title. DSO020 Auto Price Calculation by Title panel appears.
| Field | Description |
| Effective date | This date indicates when a particular price comes into effect. |
| Price basis | A price basis code identifies the basis on which prices are calculated and re-calculated for a Title’s price. Prices can be calculated based on the invoiced cost that is the cost as recorded on the shipping invoice when goods are receipted into the warehouse. |
| From and To Price code | Price codes determine at which price sale orders and other transactions are charged. Price codes are established in TMSDS/PR-PRCD. From Price code and To price code are optional fields. |
| Currency code | This represents the currency in which the customer transactions must take place. Currency codes are established in *******/EXC-DSC |
| Type of sale |
This is used for identifying different types of sales such as a Special Sale, Complimentary, Service, etc. It is also used for reports and inquiries. Types of sale are used throughout the Distribution system, and they provide management with the facility to analyse sales for the various types of sale. |
| Item levels 1 to 5 | These item levels form part of item hierarchy. There are 5 level hierarchy codes. These are important for sales analysis, inquiries and reports. They are used in financials and purchase planning. |
| Item | The number is alphanumeric and is a Product code or Item code or a Title or International Standard Book Number (ISBN) that uniquely identifies an inventory item in the system. |
- Enter the required information, as necessary.
- Click OK to confirm.
This automatically calculates prices by item, starting from the selected date.
An Error report (DSO300) is automatically generated with the following messages where applicable.
- cost variance % is within the
- ignore cost variance % range
- price variance % is within the
- record not found on DSSID00P
- record not found on DSIM00P
- record not found on APCM00P
- calculated unit cost is zero –
- qty invoiced is zero
