Price Maintenance

---

Use the form to view and edit item prices. Details entered into the form depend on the pricing options specified on the Module Control form. If you have selected the option to record pricing at a location level, you can edit prices by location. If you have selected the option to record prices at a master level, only one price is applicable to all locations.

You can edit prices by item for each price book, each unit of measure, and each currency if the Foreign Currency module is in use.

You can also enter date range and quantity break pricing, including discounts, to manage special prices — for example, promotions.

The way an item price is calculated is using the Markup Indicator that is selected on the Module Control form. You can select:

Markups & Margins are not used

Greentree determines the selling price for an item based on what is entered by the user in the Price field on the Selling Price Maintenance form. Any date range or quantity break discounts also apply if they exist and are current.

% Entered & Shown as Markup

Greentree determines the selling price (to default to a transaction line) for an item by applying a markup percentage to the item's cost value. The base cost to use in this calculation is specified on the Module Control form. You can apply a markup percentage to the last, average, or standard cost for an item.

When you enter the markup percentage in the Markup% field, Greentree Desktop calculates the price and displays it at the pricing line level. Any date range or quantity break discounts applies if they exist and are current.

For example, if the cost of an item is $5.00 and a markup percentage of 60% is applied, the price is $8.00. The calculation is $5.00 x 1.60.

% Entered & Shown as Margin

Greentree determines the selling price for an item by applying a margin percentage to the item's cost value. The base cost to use in this calculation is specified on the Module Control form. You can select to apply a margin percentage to the last, average, or standard cost for an item.

When you enter the margin percentage in the Margin% field, Greentree Desktop calculates the price and display it at the pricing line level. Any date range or quantity break discounts applies if they exist and are current.

For example, if the cost of an item is $5.00 and a margin percentage of 60% is applied, the price is $12.50. The calculation is $5.00 ÷ (1 - 0.60).

Value Entered & Shown as Margin

Greentree determines the selling price for an item by applying a margin value to the item's cost value. The base cost to use in this calculation is specified on the Module Control form. You can select to apply a margin value to the last, average, or standard cost for an item.

When you enter the margin value in the Margin Value field, Greentree Desktop calculates the price and displays it at the pricing line level. Any date range or quantity break discounts also apply if they exist and are current.

For example, if the cost of an item is $5.00 and a margin value of $6.00 is applied, the price is $11.00. The calculation is $5.00 + $6.00.

You can select one of the margin or markup options, and assign a percentage or value at a price book and/or a price book/IN analysis code level so you don't need to set up individual prices for every item.

Prices default to item lines when you enter a transaction — for example, SO Entry, POS Entry AR Invoice Entry, JC Issues (if the selling price is used).

The tax inclusive price value displays to the number of decimal places specified as the pricing Decimal Unit on the Module Control form. The tax exclusive price always displays to four decimal places, regardless of the Module Control setting.

Code

This is the inventory item code that the prices apply to. It defaults in read-only format if the Price Maintenance form is accessed from the Inventory Item Maintenance form, if an item was selected. Otherwise, enter or select the item to view or edit prices.

Description

This is the description of the inventory item.

Price Book

Select the price book to apply to the selling price. Price books are defined on the Price Book Maintenance form, and must be selected at a line level when you enter a transaction for relevant transactions. A default price book is assigned to all customers, which defaults to transaction lines for that customer.

You can also set up alternative price books to default to transaction lines based on specific customer/item combinations if the Default Price Book function is in use.

You can change the default price book when entering transactions.

Location

If you are editing prices at a location level, select the location that the price applies to. A price may be also set up against a empty location which is used if no location-specific price can be found when entering a transaction.

Unit of measure

The default value is the stocking unit of measure for the item. If you are setting a price for a unit that is not the stocking unit of measure (for example, the selling unit of measure), you can change it. If Variable Dimensions are in use, and the unit of measure has a weight dimension for it, a notation is visible in red text next to the unit of measure field.

Variable Weight Item

This indicates that the selling price is a unit price per unit of weight, and relevant calculations is applied when you enter a transaction.

Currency

Select the currency to apply to the selling price. If you are using the Foreign Currency module, you can set up prices for different currencies.

Tax code

Select the tax code to apply to the selling price.

Rate

The default value is the tax rate of the selected tax code. This field is read only.

Amount

This field displays the tax value for the price. This field is read only.

Price (tax excl)

If the pricing Tax Type option selected on the Inventory Module Control form is Exclusive, you can edit this field. Otherwise, Greentree Desktop calculates the price using the tax inclusive price and the tax code, and display in read-only format. This price always display to 4 decimal places, regardless of the pricing Decimal Unit selected on the Inventory Module Control form.

If markups/margins are in use, this price calculates using the item's analysis code, and/or selected price book if a markup/margin is set up at this level.

Price (tax incl)

If the pricing Tax Type selected on the Inventory Module Control form is Inclusive, you can edit this field, otherwise it is calculated using the tax exclusive price and the tax code, and display in read-only format. This price displays to the number of decimal places specified as the pricing Decimal Unit on the Module Control form.

If markups or margins are in use, this price calculates using the item's analysis code, and/or selected price book if a markup or margin is set up at this level.

Markup%, Margin%, Margin value

This field is labeled depending on which Markup Indicator is selected on the Module Control form. Enter the markup percentage, margin percentage, or value.

Note: This value can be assigned at an analysis code level, in which case it does not need to be re-entered here. This applies if a group of items with the same analysis code are all subject to the same pricing structure.

Review date

Enter a date to review the price for this item.

Active

Select this option to indicate that Greentree Desktop can use the price when you enter a transaction.

Copy price

Click this button to save the current price line for an item, and enter a new line, using the pricing details of the current line. For example, if all parameters are the same, but you just want to change the location, create a new line and then change the location only.

Re-calc price

Click this button to recalculate the price displayed for an item, if you know that the base cost has changed (if a markup or margin is being applied). If the item's cost has changed and the price has not been recalculated by clicking this button, the price displayed do not take the cost update into account.

Date ranges

Click this button while on the price line to add date range and/or discount details to the price. You can set a price for a specific period of time — for example, to use during a promotion.

Quantity breaks

Click this button while on the price line that it applies to, to add quantity break and/or discount details to the price. You can set a price that depends on the quantity that is sold — for example, to give customers a discounted price if they order in larger quantities. You can also specify a date range that a quantity break price applies to.

Add new price

Use this to save the current pricing line, and proceed to enter a new line.

Table

All price lines of the item displays in this table. You can enter or edit Line Details: into the table instead of using the form. Press Shift-F2 while on a line to delete it.

Note: If the Point of Sale Module is in use and the POS User Preferences for the user does not have the IN Maintenance option Pricing selected, this form are not accessible for the user using Inventory Item Maintenance.

• Module Control
• Date Ranges
• Quantity Breaks
• Analysis Code Maintenance
• IN Unit of Measure Maintenance
• Variable Dimensions - Calculation of line price
• Price hierarchy
• Price Book Maintenance

---