What is updated with a parts/price update?

From Catalyst
Jump to: navigation, search

Summary

This article explains what is updated as parts of a Parts\Price update.

More Information

The purpose of our parts/price update service is to update your copy of Platinum with the latest details and prices supplied by various manufactures. The information that it updates follows quite a complex set of rules to ensure that important data in your files is not over written.

Shadow File

The "Shadow File" is a master file containing all the parts/prices from the various manufactures you deal with; the updates change information in this file. This information is then copied into your "Main Stock Data Files" for individual stock lines that you actually deal with.

All fields in the shadow are updated unless you have the "Sales Prices Uplifted Only" setting set to 'Y'. When this is set the "Retail Price" will only go up; if the parts/price update wants to take the price down then this will be ignored.

The cost price will be subjected to any "Supplier Discounts" you have set up for the "Stock Code", "Supplier" and "Cost/Discount Group". If you do not have any set up then the cost price as supplied will be used. This works both ways, such that any cost price supplied by the update will be ignored if you have an applicable "Supplier Discount" set up. You should take care then to ensure these are kept up to date.

Main Stock File

  • Once the shadow file has been updated following the above rules, the update checks to see if the stock line is in your main stock data files. If it is then the "Retail Price", supersession information and supplier packing details are updated. The description of your stock line is only set to that of the shadow file if the description on your main stock data file is blank. The short description will only be set if it too is spaces and you have the setting "Set Short Desc. In Shadow Copy" set to 'Y'. The V.A.T. rate is set if the V.A.T. rate on your main stock data file is zero. The Stock Group will be set to that of the "Cost/Discount Group" on your shadow file if it is blank.

Cost Prices

  • Cost prices are only updated under certain circumstances. No cost prices are ever set if the "Cost Price" on the shadow file is zero (this would indicate that we have not been supplied with the cost price nor given any discount structure to apply to the retail prices by the manufacturer; in these cases you are advised to set up a Supplier/Discount system to set your cost prices). The "Standard" cost price is only set if your current total stock level (across all depots) is zero. The "Supplier" cost price is always set as long as you have a "Shadow Supplier" set linking the two character supplier code on the shadow file to your six character supplier code in your purchase ledger.

Price Escalations

  • Any price escalations you have set are then applied to set any other price ranges you may have for that stock line.

After all of that the update moves on to the next stock line in the update.

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
price, price update, parts update, shadow file