Difference between revisions of "How do I Set up a Shadow File Price Escalation?"

From Catalyst
Jump to: navigation, search
(New page: {{Incomplete}} == Summary == This article explains how to set up a Shadow File Price Escalation. Shadow File Price Escalations may be useful in lots of situations, for instance if a Shad...)
 
 
(24 intermediate revisions by 7 users not shown)
Line 1: Line 1:
−
{{Incomplete}}
 
 
== Summary ==
 
== Summary ==
−
This article explains how to set up a Shadow File Price Escalation.
+
This article explains how to set up a Shadow File Price Escalation.  
−
 
−
Shadow File Price Escalations may be useful in lots of situations, for instance if a Shadow File only has a Cost Price and no Retail Price the Escalation can Automatically set the Retail Price for you.
 
  
 
== More Information ==
 
== More Information ==
−
To set a Shadow File Price Escalation you need to go to {{Menu|Stock Control|Maintenance Options|Shadow File Maintenance|Price Escalations Maintenance|}}
+
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.
  
−
*At {{DataPrompt|Shadow Supplier:}} enter the two digit shadow file code that you want to set the Price Escalation for and then press {{KeyPress|Enter}}.
+
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.
−
*At {{DataPrompt|Calculation:}} enter a number for your Price Escalation then press {{KeyPress|Enter}}.
 
  
−
{{Note|text=You can set up to One Hundred different Price Escalations for Each Shadow File '''"0-99"'''.}}
+
Go to {{Menu|{{ST}}|Maintenance Options|Shadow File Maintenance|Price Escalations Maintenance}}.
 +
* At {{DataPrompt|Shadow Supplier}}, enter the two digit code for the supplier of the file or press {{KeyPress|F1}}/{{KeyPress|S-F1}} to scroll through supplier codes.
 +
* At {{DataPrompt|Calculation:}}, enter a number e.g. 01. This allows you to create more than one formula for a supplier.
  
−
*At {{DataPrompt|Description:}} enter a brief description of what your Price Escalation is going to do.
+
{{Note|text=You can set up to 100 different escalations for each Shadow Supplier, i.e. '''"0-99"''', although this is unlikely!}}
−
{{Example|text=Set Retail Price}}
 
−
*At {{DataPrompt|Destination:}} enter the where the Price Escalation will apply. '''"S"''' is for a Sales or Retail Price, '''"P"''' is for a Purchase Price.
 
−
*At {{DataPrompt|Price Code:}} enter the Price Code you want the Escalation to apply to and the press {{KeyPress|Enter}}, leave this Blank to modify the standard sales price.
 
−
*At {{DataPrompt|Decimal Places:}} enter how many decimal places you require from the calculation then press {{KeyPress|Enter}}.
 
−
*At {{DataPrompt|Formula:}} enter the calculation for your Price Escalation the press {{KeyPress|Esc}} and then a popup screen will appear choose the {{KeyPress|Accept}} option.
 
−
{{Tip|text=If you press {{KeyPress|F11}} while you are at {{DataPrompt|Formula:}} you will see a list of the variables you can use for the price escalation and an example Calculation.}}
 
  
−
{{FAQ}}{{KB_Tags|Shadow File,Price Escalation,Retail Price,Cost Price,Set,Calculate}}{{KB_ST}}
+
* At {{DataPrompt|Description}} enter a brief description of what your escalation is going to do e.g. {{DataValue|Set RRP to Cost + 30%}}.
 +
* At {{DataPrompt|Destination}}, enter the price to set.
 +
** {{DataValue|S}} to set a retail sales price
 +
** {{DataValue|P}} to set a cost price.
 +
* At {{DataPrompt|Price Code}}, enter the Price Code you want the escalation to apply to and then press {{KeyPress|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 [[How do I Set up Price Codes?|price code]] e.g. TRA - Trade Prices. {{KeyPress|F1}}/{{KeyPress|S-F1}} or {{KeyPress|C-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 {{KeyPress|F1}}/{{KeyPress|S-F1}} or {{KeyPress|C-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 {{DataPrompt|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 {{DataPrompt|Formula}} for the calculation.
 +
 
 +
{{Tip|text=Press {{KeyPress|F11}} to see a list of the variables you can use for the price escalation and an example calculation.}}
 +
 
 +
* Once completed press {{KeyPress|Esc}} and click {{Button|Accept}}.
 +
 
 +
{{Note|text=The escalation will be applied when you copy a [[How do I load a shadow part into the main parts file?|stock code]] into your main stock file, or when you choose to [[Shadow supplier default settings - group#Updating Items in the Main Stock File|re-sync]] your main stock and shadow files.}}
 +
 
 +
== See also ==
 +
* [[Parts Files|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 ]]
 +
 
 +
{{KB_Tags|shadow file, price escalation, retail price, cost price, set, calculate}}
 +
{{How}}{{KB_ST}}

Latest revision as of 11:28, 30 May 2022

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


Feedback
Thank you for using our Knowledge Base, we value your feedback. Did you find this article useful? 'Yes' or 'No'
Keywords AND Misspellings
shadow file, price escalation, retail price, cost price, set, calculate
Retrieved from "https://www.catalyst-uk-support.com/kb/index.php?title=How_do_I_Set_up_a_Shadow_File_Price_Escalation%3F&oldid=43514"