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

From Catalyst
Jump to: navigation, search
(Bulk update)
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
−
{{Review}}
 
−
 
 
== 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.  
  
 
== More Information ==
 
== More Information ==
−
Shadow File Price Escalations may be useful in lots of situations - for instance if a "Shadow File" only has a {{DataPrompt|Cost Price:}} and no {{DataPrompt|Retail Price:}} the Escalation can automatically set the Retail Price for you.
+
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.  
−
 
 
−
Go to {{Menu|{{ST}}|Maintenance Options|Shadow File Maintenance|Price Escalations Maintenance|}}.
 
  
−
*At {{DataPrompt|Shadow Supplier:}}, enter the two digit Shadow File code for whom you want to set the Price Escalation 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 Supplier, i.e. '''"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|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.
  
−
*At {{DataPrompt|Destination:}}, enter the type of Price Escalation that will apply. {{DataValue|S}} is for a Sales or Retail Price, {{DataValue|P}} is for a Purchase Price.
+
{{Tip|text=Press {{KeyPress|F11}} to see a list of the variables you can use for the price escalation and an example calculation.}}
−
*At {{DataPrompt|Price Code:}}, enter the Price Code you want the Escalation to apply to and then 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, then press {{KeyPress|ESC}} and {{KeyPress|Accept}}.
 
  
−
{{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.}}
+
* Once completed press {{KeyPress|Esc}} and click {{Button|Accept}}.  
  
−
{{Note|text=Your Price Escalation will be applied when you copy a [[Creating a stock item#Summary|Stock Code]] into your main Stock File, or when you re-Sync your Stock and Shadow File.}}
+
{{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 ==
 
== See also ==

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"