Price Maintenance

---

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

Prices can be maintained for by item for each price book, each unit of measure, and each currency, where 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 will be using the Markup Indicator that is selected in Module Control. You can select:

Markups & Margins are not used

Greentree determines the selling price (to default to a transaction line) for an item based on what is entered by the user into the Price field in the Selling Price Maintenance form. Any date range or quantity break discounts will 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 be used in this calculation is specified in Module Control - you can select to apply a markup percentage to the last, average, or standard cost for an item. This is a system-wide parameter.

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

Example: If the cost of an item is $5.00 and a markup percentage of 60% is applied, the price will be $8.00. The calculation is $5.00 x 1.60.

% Entered & Shown as Margin

Greentree determines the selling price (to default to a transaction line) for an item by applying a margin percentage to the item's cost value. The base cost to be used in this calculation is specified in Module Control - you can select to apply a margin percentage to the last, average, or standard cost for an item. This is a system wide parameter.

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

Example: If the cost of an item is $5.00 and a margin percentage of 60% is applied, the price will be $12.50. The calculation is $5.00 ÷ (1-0.60).

Value Entered & Shown as Margin

This option means that Greentree determines the selling price (to default to a transaction line) for an item by applying a margin value to the item's cost value. The base cost to be used in this calculation is specified in Module Control - you can select to apply a margin value to the last, average, or standard cost for an item. This is a system-wide parameter.

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

Example: If the cost of an item is $5.00 and a margin value of $6.00 is applied, the price will be $11.00. The calculation is $5.00 + $6.00.

If you do not want to set up individual prices for every item, you can select one of the margin or markup options, and assign a % or value at a price book and/or a price book/IN analysis code level.

Prices defaults to item lines during transaction entry, where applicable, for example, SO Entry, POS Entry AR Invoice Entry, JC Issues (where the selling price is used).

The tax inclusive price value displays to the number of decimal places specified as the pricing Decimal Unit in Module Control. However, the tax exclusive price always display to four decimal places, regardless of the Module Control unit.

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, where an item was selected. Otherwise, enter or select the item to view or maintain prices.

Description

This is the description of the inventory item.

Price Book

Select the price book to apply to the selling price that is being maintained. Price books are defined in Price Book Maintenance, and must be selected at a line level during transaction entry 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 where Default Price Book function is in use.

You can change the default price book when entering transactions.

Location

If you are maintaining 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 where no location-specific price can be found during transaction entry.

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 will be 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 will be applied during transaction entry.

Currency

Select the currency to apply to the selling price that is being maintained. 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 being maintained.

Rate

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

Amount

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

Price (tax excl)

If the pricing Tax Type option selected in IN Module Control is Exclusive, you can edit this field. Otherwise, Greentree 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 in Inventory Module Control.

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

Price (tax incl)

If the pricing Tax Type selected in Inventory Module Control 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 in Module Control.

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

Markup%, Margin%, Margin value

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

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

Review date

Enter a date that you want to review the price for this item.

Active

Select this option to indicate that the price is available for Greentree to use during transaction entry. If this is not selected, Greentree will not take this price in account when searching for a price to return as a default to transaction lines.

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, this is a quick way of creating a new line, and then changing 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 (where a markup or margin is being applied). If the item's cost has changed and the price has not been recalculated using this button, the price displayed will not take the cost update into account.

Date ranges

Click this button while on the price line that it applies to, 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.

• 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

---