How do I Set up a Shadow File Price Escalation?
From Catalyst
Summary
This article explains how to set up a Shadow File Price Escalation.
More Information
Price escalations can be used to calculate the cost or retail price of an item as it is copied from the Shadow File into the main Stock File.
For instance, if a specific supplier price file only contains cost prices the escalation can automatically set the retail price based on a numerical formula e.g. Cost plus a percentage markup.
Go to " Stock Control Maintenance Options Shadow File Maintenance Price Escalations Maintenance".
- At "Shadow Supplier", enter the two digit code for the supplier of the file or press <F1>/<Shift+F1> to scroll through supplier codes.
- At "Calculation:", enter a number e.g. 01. This allows you to create more than one formula for a supplier.
 | You can set up to 100 different escalations for each Shadow Supplier, i.e. "0-99", although this is unlikely! |
- At "Description" enter a brief description of what your escalation is going to do e.g. 'Set RRP to Cost + 30%'.
- At "Destination", enter the price to set.
- 'S' to set a retail sales price
- 'P' to set a cost price.
- At "Price Code", enter the Price Code you want the escalation to apply to and then press <Enter>.
- If you are calculating sales prices you may choose to apply the pricing to the standard retail price, in which case leave the price code field blank, or a specific price code e.g. TRA - Trade Prices. <F1>/<Shift+F1> or <Ctrl+F1> to find a code to use.
- If you are calculating cost prices you should specify the supplier and whether to apply the changes to cost price 1, 2 or 3 on the supplier record. Use <F1>/<Shift+F1> or <Ctrl+F1> to find your supplier or enter their account code. Then specify which cost price to set (usually cost price 1 is the default used when ordering parts).
- At "Decimal Places", enter the number of decimal places the calculation should round to e.g. retail prices are usually best rounded to 2 places.
- Enter your "Formula" for the calculation.
 | Press <F11> to see a list of the variables you can use for the price escalation and an example calculation. |
- Once completed press <Esc> and click [Accept].
| The escalation will be applied when you copy a stock code into your main stock file, or when you choose to re-sync your main stock and shadow files. |
See also
- Available Parts Files
- What is updated with a parts/price update?
- Parts Files
- What is a Shadow Stock code?
- Creating a stock item
- Shadow supplier default settings - group
