Setting Up Price Books


Click your browser's 'Back' button to return to the previous page.

Changing your pricing structure is a snap when using Price Books. You can easily implement markups or markdowns by simply switching to another Price Book.

 

Overview

The Price Book Rates tab stores pricing adjustments, which when selected on a Quote, automatically modifies the prices from the Product Catalog

by the Adjustment Rate defined for it.

 

Start out by defining your base price, which is the actual dollar amount of the prices in the Product Catalog, then calculate the Adjustment Rate for other sales regions, such as Countries or Territories, using currency exchange rates and any other markup or markdowns you want to make. When Territory Security (in Administration/Advanced Security) is used for external sales people, you can specify one or more Price Books as the ONLY rates they'll have available to write quotes on.... completely hiding rates for other regions and the base prices in the Catalog itself.

 

Printing Product Catalogs by Price Book

The Print menu in the Product Catalog allows users to print a report option based on a specific Price Book, using the "Print by Price Book" menu item.

 

IF THERE IS MORE THAN ONE PRICE BOOK defined on the Price Book Rates tab, the user will be prompted to select the Price Book to use.  The selection list defaults to the Standard rate (Adjustment Rate = 1), which prints the selected report using the prices that have been entered in the Product Catalog and Product Catalog Items.

 

Choosing a different Price Book prints the selected report, too, but adjusts the standard pricing according to the Adjustment Rate associated to the selected Price Book. 

 

Printing Reports

In the Product Catalog print menu, you may see "Reports", which displays all available reports NOT related to the Product Catalog (ie  'Part Number List'), and consequently doesn't need a Price Book choice to print it.  The "Reports by Price Book" item shows the Reports that DO print Product Catalog information, and when selected, will also prompt you for a Price Book so it can apply a different rate to the prices before you see it in Print Preview.  Please note that if there are any other selections to make, such as there is when you're printing reports "By Product Line" (or something) for example, you'll be prompted to choose those items first, then will be prompted for the Price Book selection.

 

This printing feature automatically adjusts all of the price fields on the Product Catalog Items:  "Catalog Price", "Item Price", "Additional Price", "Reduced Price", "Item Total", plus any calculated fields that are added in the DataQuery (in the Report Designer) WHERE THE CALCULATED FIELD NAME ENDS WITH "_Price" (example: "List_Price").

 

Printing Reports in Sales

When printing a report for the current record, such as a quote, the Price Book selection defaults to the Price Book defined on the Quote record you're currently on.  For example, if my Quote uses the "Standard + 10%" Price Book, the "Standard + 10%" item will be selected in the Price Book prompt.  Of course, you can always pick another Price Book from the list, but it's logical that you would want to print the report that matches the pricing structure you're using.

 

The report is then displayed using the information from the Product Catalog that matches the Product Line and Product Name on the current Quote, and then adjusting the pricing according to the Price Book you selected.

Click your browser's 'Back' button to return to the previous page.

 


Crow River Tech, LLC. Copyright© 2010. All Rights Reserved

Microsoft Windows XP/Vista/7, SQL Server 2005, Access, Outlook and Excel are trademarks of Microsoft Corporation. 

Any other product names are trademarks of their respective companies.