faq:price_updates
Differences
This shows you the differences between two versions of the page.
| Last revisionBoth sides next revision | |||
| faq:price_updates [2007/09/12 11:53 (17 years ago)] – created cliff | faq:price_updates [2007/09/12 15:26 (17 years ago)] – cliff | ||
|---|---|---|---|
| Line 10: | Line 10: | ||
| The crux of the problem could be described as not being able to have 2 standard costs. The first standard cost would be for setting you pricing for customers, and the second standard cost would be for setting the cost of the item on a PO. We are limited to one standard cost though. The way to work around this limitation is to load the pricing as a fixed price. Since in this scenario we don't have the list price in the file we are importing, we need to find a way to set the list price even though it's not provided. I will explain the process for this below and then do a summary of the entire process for this scenario. | The crux of the problem could be described as not being able to have 2 standard costs. The first standard cost would be for setting you pricing for customers, and the second standard cost would be for setting the cost of the item on a PO. We are limited to one standard cost though. The way to work around this limitation is to load the pricing as a fixed price. Since in this scenario we don't have the list price in the file we are importing, we need to find a way to set the list price even though it's not provided. I will explain the process for this below and then do a summary of the entire process for this scenario. | ||
| + | === Loading List Price by Markup When no Cost is Available === | ||
| + | We need to use the Table Adjustment ability in data loads. The first thing to consider in order to understand how this works is that we are loading the cost field for your regular cost file into the list price. We then **Transform** the field we have labeled as list. The **Transform** process simply allows us to mark up the cost field 100% making it equal the list price. This is why we chose List Price on our cost column. | ||
| + | |||
| + | Once you understand that we are choosing to load your regular cost into the list file, you just need to read the help file on the table adjustments. Please search for the Keyword phrase of **Data Load Functions** into the index search in the help file. The function to select is **%increase by Percentage**. The From and To values need to encompass the entire range of costs. The Value is 100 to represent a 100% markup. | ||
| + | |||
| + | There are more complex rules that this that can be put into place using XSL stylesheets if you have access to a Developer that can write XSL stylesheets. If this is not someone you have available to yourself, please contact your sales representative to have a quote for this work put together. | ||
faq/price_updates.txt · Last modified: 2021/08/03 05:28 (3 years ago) by anemenzo