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.

**NOTE** Price Books take precedence and drives the price on the order.

Create a price book for a percentage markup over cost

1. In the Utilities module, click Utilities.
2. Select Price Book Editor and click Run It.
3. The Price Book Editor will display. Click New.
4. Type the name in the Price Book field.
5. Select Fixed %.
6. In Percentage, type the percentage.
7. Select Higher.
8. In Based on, select Cost.
9. Click Save.

Price Book for specific prices on inventory or service items

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

Assign Price Book to Customers

1. Go to Customers module > Customers.
2. Open a customer record.
3. Select the Rates tab.
4. Locate the Price Book field and select the price book you want to assign to the customer.
5. Click Save.

6. Click Actions > New Service Order.
7. In the order, select the Order Items tab.
8. Click New Material or New Service to select item that is on the price book.
9. In the Add Items to Order window, notice two things (circled in image below):
a. Locate the Price Book field (1). You should see that field auto-populated with the price book assigned to the customer.
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.

Price Books Commissions

Item by Item Commissions

You can add items to a price book and have a specific commission rate for each item or a specific flat commission for each item. When the pricebook is applied to an order or invoice, the commissions will be based on the PriceBooks.

In the example below, there is a PriceBook created called Commission Rates. In the Sales Commission % column you will see the commission % for the salesperson on each item. Notice you can have different rates for different items. Also notice in the Partner Discount column there is a flat rate for two of the items.

If that PriceBook is assigned to an order and some of those items included in the PriceBooks are placed on the order, you will see the commissions populate on the Totals tab. (image below)

You will also see the commission on each individual item on the Commission tab. Open the Inventory, Service, or Labor tab. Click the Commission tab.

Total Order Commissions by PriceBooks

If your salespeople, technician's or partners receive a commission rate that varies depending on customer or specific orders, you can create multiple PriceBooks with the overall commission rate. Assign the correct rate to a customer record. Going forward, any order created for that customer will use the commission rates defined in the PriceBooks.

In the example below, there is a PriceBook called Commission Rates Fixed. Notice the commission rates are filled out for Salesperson and Partner.

For every order that this PriceBook is applied to, these commission rates and fixed amounts will be used for every item placed on the order. The commissions will show on the Totals tab.