Load Price Levels
(Load Price Levels)
Access
Use this routine to apply the values in one or
more price
levels to one or more selected products. The system
selects products based on
the criteria you specify at the prompts below,
retrieves the selected products'
current Pricing
Level Table, and
calculates the selected
price levels using formulas in the Pricing
Level Control Table.
ProductEnter the code for one or
more products for which you want to load price levels. If you click on
the Search button, you access
the Product/Description/Vendor
Model Word Search window, from which you can choose a product. If
you click on the Action button,
the Multiple Product Selection window appears from which you can select
one or more products. To load price levels for all products, leave the
field blank. Your selection appears to the right of the field.
If you select a single product at the Product field, the Group, Category,
Vendor, and Collection fields are not active. Those fields are used to
restrict your product list if you select multiple products.
GroupEnter the code for one or
more product groups for which you want to load price levels. If you click
on the Search button, you access
the Group search window from which you can search for and select one or
more product groups. If you click on the Action
button, the Multiple Product Group Selection window appears from which
you can select one or more product groups. To load price levels for all
groups, leave the field blank. Your selection appears to the right of
the field.
CategoryEnter
the code for one or more product categories for which you want to load
price levels. If you click on the Search
button, you access the Category search window from which you can search
for and select one or more categories. If you click on the Action
button, the Multiple Category Selection window appears from which you
can select one or more product categories. To load price levels for all
categories, leave the field blank. Your selection appears to the right
of the field.
VendorEnter the code for one or
more vendors for which you want to load price levels. If you click on
the Search button, you access
the Vendor Cross Reference window from which you can search for and select
a product. If you click on the Action
button, the Multiple Vendor Selection window appears where you can select
one or more vendors. To load price levels for all vendors, leave the field
blank. Your selection appears to the right of the field.
CollectionEnter
the code for one or more product collections for which you want to load
price levels. If you click on the Search
button, you access the Collection search window from which you can search
for and select a product collection. If you click on the Action
button, the Multiple Collection Selection window appears where you can
select one or more product collections. To load price levels for all collections,
leave the field blank. Your selection appears to the right of the field.
Price LevelEnter
the code for one or more price levels you want to update for the products
selected above. If you click on the Action
button, the Multiple Price Levels Selection window appears where you can
select one or more price levels. To select all price levels, leave the
field blank.
Level Price Rounding
When loading price levels, the system rounds off level price calculations
using the following rules:
The initial calculation
is done using a 2 digit [cents] rounding factor with a 5/4 normal
rounding.
The next calculation is
done using a 5/4 normal rounding function to get the Selling Price
to a whole dollar number. Thus, the system rounds all prices are rounded
to whole dollars.
The next calculation is
an adjustment based upon the unit dollar amount as follows:
a. If the unit dollar amount
is 0, replace it with 0.
b. If the unit dollar amount
is 1 to 5, replace it with 5.
c. If the unit dollar amount
is 6 to 9, replace it with 9.
Thus, all adjusted selling prices are in whole dollars and end in a
0, 5 or 9.
Example
For example, assume pricing level two for a given product is 100.00.
Price
Level |
Base
Level |
Multiplier |
Calculation |
Rounding |
3 |
2 |
2.00 |
2
* 100.00 = 200.00 |
Price
is rounded to $200.00. Dollar amount is 0 so that is replaced
by a 0. Price is set to $200.00. |
5 |
2 |
1.34 |
1.34
* 100.00 = 134.00 |
Price
is rounded to $134.00. Dollar amount is 4 so that is replaced
by a 5. Price is set to $135.00. |