Price Book Maintenance

Use this form to set up inventory price books. When a sales transaction (and in some cases, an issue transaction) is processed for an inventory item, a price book must be specified on the line, so that Greentree Desktop can calculate the selling price.

Price books are an efficient way of setting up prices if multiple items have the same pricing structure. You can use item analysis codes to group items together for pricing, so that markups and margins can be applied at a high level, instead of having to be defined at an item level.

For transactions involving customers, the default price book assigned to the customer on the Integration tab on the AR Customer Maintenance form defaults to the transaction line.

For inventory transactions that do not involve customers, if a selling price applies (for example, issue to a job), the default price book assigned on the Defaults tab on the Inventory Module Control form is used. You can change price books when entering a transaction.

Options Reference

Each option and field on the form is described below. Mandatory options and fields are highlighted in red.

Code

Enter a unique code, up to 15 alphanumeric characters to identify the price book.

Description

Enter a description for the price book, up to 30 alphanumeric characters.

Tax Code

Select a default tax code for transaction lines when this price book is selected.

Always use Markup/Margin from Analysis Code

This option is enabled if markups or margins are being used. The label for this option changes, depending on whether a markup or margin is being used.

If you select this option, Greentree Desktop always uses the markup or margin assigned on the Analysis Code Maintenance form when determining the selling price for an item if this price book is used. This is applicable if there is no price defined specifically at the item level.

Markup/Margin Value

This option is enabled if markups or margins are being used. The option label changes depending on whether a markup or margin is being used.

Enter the default markup or margin to use when Greentree Desktop is calculating the selling price for an item if this price book is used.

To change the markup or margin at an analysis code level, enter the details in the table on this form.

Always Recalculate price based on margin value and costing level

Select this option to always have the price calculated based on cost and the markup or margin percent or margin value in the inventory analysis code.

Is Active

Select this option to use this price book when you enter a transaction.

Analysis Code Table

Enter the details of a markup or margin at an analysis code or price book level into this table. Greentree Desktop applies the markup or margin using the item's analysis code, and the price book entered into the transaction line when it calculates the selling price for an item.

Note: If an item has a specific price set up for it on the Price Maintenance form, that price is used first.

You can also apply a Discount % to an analysis code or price book markup or margin line. When a selling price is calculated using this criteria, the discount percentage specified is applied, and the discount value displays separately on the transaction line.