This is a code 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

The Sub-details Function key gains access to the Title’s additional price codes.  Displayed for each code is the description, percentage rate, the rate the price needs to be marked up by, whether the RRP should not be updated or calculated at the given RRP rate or copied from the original price code and the RRP update rate.

The price basis field contains a code that identifies which price basis is used for the calculation and re-calculation of 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:

Basis

A = invoiced trade landed cost (The title’s landed cost in the trade currency divided by the quantity invoiced, from the shipping file)

B = Invoiced base landed cost (The title’s landed cost in the base currency divided by the quantity invoiced, from the shipping file)

1 = Invoiced gross trade unit cost (The title’s unit cost excluding discount in the trade currency from the Shipping file)

2 = Invoiced gross base unit cost (The title’s unit cost divided by the exchange rate, excluding discount, in the base currency from the Shipping file).

3 =Invoiced net trade unit cost (The title’s unit cost including discount, in the trade currency from the shipping file).

4 =Invoiced net base unit cost (The title’s unit cost, including discount, divided by the exchange rate in the base currency from the Shipping file.)

Note: Price basis 1, 2, 3, 4, A and B which are using a shipping invoice buying price are only relevant in the ‘Shipping Repricing’ (DSO050) where a specific shipping number needs to be entered.

Prices can be calculated based on the unit cost held on the Title Masterfile.

5 =Masterfile gross trade (Unit cost/Buying Price) (The gross unit cost held on the Title Masterfile in the trade currency.)

6 =Masterfile gross base (unit cost/Buying Price) (The gross unit cost held on the Title Masterfile, divided by the current exchange rate in the base currency).

7 =Masterfile net trade unit cost (The net unit cost held on the Title Masterfile, minus the discount in the Trade currency)

8 =Masterfile net base unit cost (The net unit cost held on the Title Masterfile minus discount divided by the exchange rate, in the Base currency)

C = Overseas price in the trade Currency (from the Title Masterfile)

D = Overseas price in the Trade Currency divided by the current exchange rate (from the Title Masterfile)

E = Overseas price in the Trade Currency minus the ex-factory discount divided by 100 (from the Title Masterfile)

F = Overseas price minus the discount rate divided by the exchange rate in the base currency

Other Calculation methods are:

O= As per definition – The title’s price as defined in the Percentage Increase/Decrease option pricing definition.

9 = Current weighted average landed cost (for the calculation of the average landed cost the system divides the total quantity stored in all warehouses by the total cost this stock represents.

G= Estimated Landed Cost – into the future by using the future buying prices plus landing charges.

This is a user defined field defining the particular rounding method.

Example:

000 = Zero rounding method

001 = Nearest rounding method to .05 cents.

003 = Nearest rounding method to .50 cents. 

This field determines the upper limit of a cost range to which this pricing definition will apply for the cost range.

Example 9999999.00 will apply to all costs if you enter 100.00 then any value up to this figure will be applied in the definition. This definition is used if the cost is less than or equal to this cost break.

The selling and or Recommended Retail Price will only be recalculated if the variance between the current cost and the weighted average is greater than (% up) or less (% down) the nominated %’s.

For Example, if % up is 10% and % down is 3% and weighted average is $100, the selling price will only be calculated if the current cost is greater than $110 ($100 +10%) or less than $97 ($100-3%).

Another Example is if % down is 0%, then the selling price will be calculated if the current price falls below $100. 

This is a similar concept to ‘Ignore Cost Variance’.  A new selling price and/or Recommended Retail Price will only be generated if the new selling price variance in relation to the old price is greater than the % up or lower than the % down.

Example: % up = 5%, % down = 2%

Old selling price is $100, new selling price will only be generated if selling price is greater than $105 ($100 +5%) or less than $98 (100 less 2%). 

This is the Price variance allowed after auto price calculation.  Variances outside the nominated range will display the price change as auto approval = No.

Example: 20% up 0.00% down = if any prices are within this tolerance level then the approval flag in maintenance screen is set to =Yes or if any prices are outside this tolerance level then the approval flag in the maintenance screen is set to = No.

If a price is suggested (Example: gets past above tests) Ignore cost and Price Variances.

If new price is higher then old price and (new price – old price) * 100 / old price is less than or equal to ‘Auto approve price up’ then the approved flag on the suggested price is set to Yes.

If new price is higher than old price and the ‘auto price up’ = 999 then the Approved flag on the suggested price is set to Yes.

If old price is higher than New price and

(Old price – New price) * 100 / Old price is less than or equal to “Auto Approve Price DOWN’ then the Approved flag on the suggested price is set to Yes.

If old price is higher than New price and the ‘Auto Approve Price DOWN’ = 999 then the Approved flag on the suggested price is set to Yes. 

Set this flag to Yes to calculate for titles that do not have an existing price, a suggested price is then calculated.

If an existing price is not found for a title, and a suggested price is calculated, the Approved flag on that suggest price is set to Yes.  This is displayed in the approval screen. 

Valid price calculation methods are:

1= markup on unit cost

2 = GP%

3 = fixed

Mark up:

New price = Unit cost * (1 + rate/100)

Rate = (New price – cost) * 100 / Cost

GP%:

New price = Cost / (1 – Rate/100)

Rate = (new price – Cost) * 100 / Price

Fixed:

New price = Rate. 

This field determines the percentage rate or price the original price that needs to be marked up by.

Example 250% = Price of $4.41 by 250% = 11.025 + 4.41 = 15.435 this will round up to 15.44. 

This is the rate at which the recommended retail price is to be updated.

Example 0% = This will create the RRP price equal to the selling Price if the update RRP field is set to 1.

New RRP = New price * ((RRP rate/100) + 1)

RRP rate = (RRP Rate – New price) * 100 / New price.