Editing Price Books

Price Books are used to assign customer specific pricing during order entry. You can assign a price book to a customer and all orders created for the customer will use the pricing rules assigned in the price books. An example of a price books is “30% higher than cost” or “10% less than retail”. You may also have a price book for customers that have special service pricing, different than your standard service prices.

<br>'''**NOTE**''' Price Books take precedence and drives the price on the order.
<br>

== Create a price book for a percentage markup over cost ==
1.       In the '''Utilities''' module, click '''Utilities'''.
<br>2.       Select Price Book Editor and click '''Run It'''.
<br>3.       The Price Book Editor will display. Click New.
<br>4.       Type the name in the Price Book field.
<br>5.       Select '''Fixed %'''.
<br>6.       In Percentage, type the percentage.
<br>7.       Select '''Higher'''.
<br>8.       In Based on, select '''Cost'''.
<br>9.       Click '''Save'''.
<br>[[File:PriceBook_Markup.png]]

== Price Book for specific prices on inventory or service items  ==
1.       In the '''Utilities''' module, click '''Utilities'''.
<br>2.       Select Price Book Editor and click '''Run It'''.
<br>3.       The Price Book Editor will display. Click '''New'''.
<br>4.       Type the name in the Price Book field.
<br>5.       Click '''Save'''.
<br>6.       Click '''Add From Inventory''' to add inventory items to the price book.
<br>7.       Select the inventory items you want to add to the price book.
<br>8.       Enter the special price book price in the '''Price''' column (circled in image below).
<br>9.       Click '''Add From Services''' to add service items to the price book.
<br>10.   Select the service and back in the Price Book Editor, edit the price in the''' Price''' column.
<br>11.   Continue adding from inventory items and services items until you are finished.
<br>12.   Click OK at the bottom of the Price Book Editor.
<br>[[File:PriceBook_StockPrice.png]]

== Assign Price Book to Customers ==
1.       Go to '''Customers''' module > '''Customers'''.
<br>2.       Open a customer record. 
<br>3.       Select the '''Rates''' tab.
<br>4.       Locate the Price Book field and select the price book you want to assign to the customer.
<br>5.       Click '''Save'''.
<br>[[File:AssignPriceBookToCustomer.png]]
<br>6.       Click '''Actions''' > '''New Service Order'''.
<br>7.       In the order, select the''' Order Items''' tab.
<br>8.       Click '''New Material''' or New Service to select item that is on the price book.
<br>9.       In the Add Items to Order window, notice two things (circled in image below):
<br>a.       Locate the Price Book field (1). You should see that field auto-populated with the price book assigned to the customer.
<br>b.      Notice the price in the Price field (2). This price is calculated based off the rules setup in the price book. You can see the price change if you select a different price book.
<br>[[File:PriceBookOnItem.png]]


== Price Books Commissions ==
You can set commission rates on an item by item basis by using Price Books.

The Price Book below has two items on it. Each item has a commission percentage or flat rate commission assigned. 

[[File:PriceBookEditor(1).jpg]] 

When adding an item to the order or proposal with the Price Book selected, the commission tab is filled out based on the commission defined in the Price Book.

[[File:CommissionsTab.jpg]]
 

The Totals tab will show the Commission totals for the order or proposal.


[[File:TotalCommissions.jpg]] 

Users that do not have permission to view commissions won’t see the commission tab or the commission totals. Permission is set in the User Group > Administrative Clearances tab > Commissions. 


'''Setup PriceBooks with Commissions'''
<br>1. Go to '''Utilities''' module > '''Utilities'''.
<br>2. Select '''Price Book Editor''' and click '''Run It'''.
<br>3. Click '''New'''.
<br>4. Enter a name in the '''Price Book''' field.
<br>5. Click Add From Inventory, Add from Service, or Add Labor to select the specific material, service or labor.
<br>[[File:AddInventoryService.jpg]] 
<br>6. Once the item is added to the Price Book, it will be listed on the grid shown below.
<br>[[File:CommissionOnGrid.jpg]] 
<br>7. Locate the commission columns. Enter either the commission percentage or the flat rate commission for each item. 
<br>8. Click '''Save'''.


<h3>Assigning Price Book to items on an order</h3>
<br>'''You can assign a Price Book to a customer''' - all orders or proposals created for that customer will be assigned to the Price Book and then all items added to the order will be assigned to the Price Book.

 
'''You can assign a Price Book to an order or proposal''' - assign a Price Book to an order or proposal then all items added to the order will be assigned to the Price Book.


'''You can assign a Price Book to a specific item on an order or proposal''' - on each individual item you are adding to an order you can assign a Price Book.