Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Run a price book run for all products (see Creating a price book run)
  2. Add quantity on hand to the price book run log
  3. Filter the price book run log to only show products where the list price has changed
  4. 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)
  5. Sort the price book run lines list view by the  "Difference Percentage" column
  6. Review the large positive and large negative changes on the spreadsheet
  7. For product where you do not want the data to change to match the price book:
    1. Go to the product
    2. Go to Settings > Catalogue Update tab
    3. 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)

...