...
- Run a price book run for all products (see Creating a price book run)
- Add quantity on hand to the price book run log
- Filter the price book run log to only show products where the list price has changed
- Look at the "Difference Percentage" column on the price book run lines. (This column uses a formula newvalue/oldvalue*100 to calculate the percentage change for relevant fields)
- Sort the price book run lines list view by the "Difference Percentage" column
- Review the large positive and large negative changes on the spreadsheet
- For product where you do not want the data to change to match the price book:
- Go to the product
- Go to Settings > Catalogue Update tab
- Set ignore changes to sell prices and ignore changes to cost prices to be true
...
You should not run price book runs on a regular basis. Once you have one good price book run posted you should turn on automatic overnight updates. Then you do not have to load a catalogue or price book run ever again!
See Also:
Child pages (Children Display) |
---|
...