From the Home tab: under links, select Processes.
|
Quantum VS Help: File Maintenance |
The Add Automatic Forward Prices process enables you to update price and/or cost details for a range of products in advance of a specified date. You have the option of (a) altering the Gross Price held on any or all Price Bands by a specified percentage, (b) updating the Regulator Discount held on any or all Price Bands, and/or (c) updating Supplier Buying Costs and/or Buying Terms.
Note: This process adds the new product prices/costs to the Forward Price file - see Understanding Price Changes And Unapplied Prices. The Apply Forward Prices process must then be run to apply the new prices/costs to the product records.
To run the Add Automatic Forward Prices process:
1. Either:
From the Home tab: under links, select Processes.
Or: From the Toolbar - Main Menu: select Tools > Show Processes.
OR: Click the appropriate module on the Mega Menu then - under processes - select the required Process.
The Processes record opens in a new tab, listing all Processes by Name and Category.
2. Use your mouse or [Tab] key to select the Add Automatic Forward Prices process:
3. In the area to the right you must enter the criteria for the process.
Note: You may use your [Tab] key to move from one field to the next.
First, select one of the following Sequence options:
Product: to run the process on a range of products based on their Product Code; or
Section Order: to run the process on a range of products based on their Section Order code.
4. In the From and To fields below, enter the first and last Product code or Section Order code in the sequence of products you wish to apply the changes to.
If you enter nothing in the From / To fields, the process will be run on your whole Product list.
Note: A Product Code is a unique code comprising up to eleven characters. For example: 0502GRA0005. Product Codes are entered on the Product Code field of the Product record (Main tab). For further details see Defining Product Codes And Descriptions.
Note: The Section Order code represents a sequence of up to ten alphanumeric characters or spaces, sometimes shown divided by a '/' (e.g. PAINT/00001). The first five characters represent the Section Name, which is entered on the Section Name field of the Product record (Main tab). The following five characters represent the Section Order Code which is entered on the Section Order Code field of the Product record (Main tab). If either is fewer than five characters in length, enter a space for each missing character.
If you don't know the Product Code you may enter it automatically using the Finder. To do this:
place your cursor in the From/To field;
click [F3] to make Products active in the Finder;
in the Finder, locate the product you wish to add (see Finding Products); then
double-click on the product line in the Finder to add the Product Code.
5. Change Gross Sell Price: To adjust the Gross Sell Price of the selected products by a specified percentage, check the appropriate Band field (e.g. Band 1 - 12). Then enter the Percentage Change to be applied to the Gross Sell Price on the selected band in the field below. (You may enter a negative value to decrease the price.)
If you want the price change values to be rounded, select one of the following Rounding Type options:
Round Up
Round Down
Round To Nearest
then select a Rounding Value (a value greater than zero up to 99.99) in the field below.
The default value is None - no rounding will be applied.
6. Change Regulator Discount: To adjust the Regulator Discount value of the selected products by a specified percentage, check the appropriate Band field (e.g. Band 1 - 12). Then enter the percentage Discount on the selected band in the field below.
7. Change Costs: To alter the Supplier Cost/Buying Terms of the selected products, check this field to enable the 'costs' fields below.
Now enter your 'costs' criteria as necessary, using the following as a guide:
|
Field |
Definition
|
|
Buying Terms Method
|
Select the method for changing Supplier Buying Costs and terms, from the following options:
|
|
Supplier Account
|
If you selected 'Match To A Supplier' above, select the Supplier to be used.
If you don't know the Supplier Account Code you may enter it automatically using the Finder. To do this:
|
|
Change Base Cost / Base Cost % Change
|
To adjust Base Costs for the selected Supplier and Products, check this field then enter the percentage change to be made in the field below.
|
|
Change Standard Cost / Standard Cost % Change
|
To adjust Standard Costs for the selected Supplier and Products, check this field then enter the percentage change to be made in the field below.
|
|
Change Buying Terms
|
Check this field if you wish to change Buying Terms for the selected Supplier and Products. This will enable the following fields:
|
|
Band / Buying Discount Type / Buying Discount
|
For each Price Band on which you are adjusting Buying Terms, select the applicable Buying Discount Type from the following options:
Then enter the amount of Buying Discount to be applied.
Note: See Manual Pricing: Updating Supplier Costs For A Product for an example of how the Amount, Base Discount and Chain Discount are used in adjusting Supplier Buying Terms. |
|
Buying Settlement Discount
|
To alter the Settlement Discount value for the selected Supplier and Products, enter a new Settlement Discount value here.
|
|
Update Standard Cost
|
Check this field to update the standard Cost Price for the selected Products/Suppliers.
|
|
Effective Date
|
Select the date on which the forward price changes will become effective.
|
8. Enter the Effective Date - the date on which the new price/cost details changes will become effective for the selected products.
9. Click Start on the Toolbar - Sub Menu to begin running the process.
10. When the process has finished running, a Status message will be shown. Click OK to close this message. You may now close the Processes tab if you wish.
At this point the new product prices/costs have been added to the Forward Price file but have not yet been applied to the product records.
To apply the price/cost updates you will need to run the Apply Forward Prices Process. The Forward Prices will then be applied to each product record on the appropriate Effective Date.
Note: To view unapplied prices - i.e. prices/costs which have been added to the Forward Price Record but not yet applied to the product record - see Viewing Unapplied Prices For A Product.
