Creating Price Lines

Create price lines for your products before setting up your product file. Generally, a price line is a group of items whose prices are updated at the same time when the vendor distributes a new price sheet. For example, you can define price lines by vendor lines, major segments within vendor lines, major commodity lines, sales performance reporting or product ranking, or products with unique sets of units of measure.

Within each price line you must determine which local basis names to associate with the price line. The local basis names are then cross-referenced with global basis names.

Before creating price lines, set the following control maintenance records:

To create a price line:

  1. From the Maintenance > Price Maintenance menu, select Price Line to display the Price Line Maintenance window.

  1. In the Price LineID field, enter a price line ID to display an existing price line, or click the New Price Line button and enter the name of the new price line. Price line IDs cannot contain the Closedspecial characters.

    1. Asterisks (*)

    2. Ampersands (&)

    3. Tildes (~)

    4. At signs (@)

    5. Carats (^)

    6. Pipes ( | )

Note: You cannot define a price line ID that has the same name as the ID assigned to an existing product family. This restriction prevents conflict when using the price line or product family search.

  1. In the Description field, enter information for the price line describing the type of products in the price line and the product's manufacturer or vendor.

  2. Use the left pane fields define your price line details:

Field

Description

UM Defaults area

Enter the unit of information, as needed:

  • UoM Desc - In the UoM Desc field, enter the abbreviation for the default physical unit of measure (UOM) represented in this price line, such as "ea" for each. Then, on subsequent lines, enter additional default units of measure that pertain to products in this price line, such as "bx" for box, and "ct" for carton, if necessary.

  • S, P, T, A, and I - Select the transaction type or types (S, P, T, A, and I) check box used for each unit of measure description:

  • S - Sales Orders

  • P - Purchase Orders

  • T - Transfer Orders

  • A - Inventory Adjustments

  • I - Inquiry/Inventory

For example, if you buy and sell in box (bx) units, select both the S and P check boxes for the bx UoM description.

Units of measure set in Product Maintenance for individual products override these settings.

Budget Group

Select from a list of budget groups to assign to the price line, if necessary.

If a product is not assigned to a budget group in Product Maintenance, the system looks to the associated price line for a budget group.

Duty Code

Assign a duty harmonizing code to the products in this price line, if necessary.

Minimum Price Basis

Enter the global basis to be used to determine the Closedminimum sell price for a product.

The Minimum Sell Basis represents the minimum price a user can use when overriding the sell price to the customer. This check occurs before any GP% check that could be set up in the system.

Note: In Sales Order Entry, if a user tries to manually override a selling price using the Unit Price field, the GP% field, the Subtotals option, or Job Bid Maintenance, the system compares the price entered to the price specified in the Minimum Sell Price field. The user cannot change the price to be less than the minimum price defined. You must have the SOE.MIN.SELL.PRICE authorization key assigned.

Use Price Branch for Costing

Select the check to use the sales order's pricing branch instead of the shipping branch to update the cost of goods sold (COGS) on an order. The Pricing Audit for a sales order indicates whether the cost of an item is based on the pricing branch.

Select this check box if you have lines that have different costs based on the market they serve.

Cut Product Price Line

Select the check box to allow product cuts for products in this price line.

Note: Setting a price line to allow cutting indicates that all products in that line can be cut. However, the system uses standard hierarchy rules to determine the status of a line and settings at the product level override settings set at the price line level. Because these rules still apply, you can have a price line set to allow cuts, but tag individual products on that line to not allow cuts.

Require Mill Test Reports

Select the check box if you want Mill Test Report heat number information to be required when using products in this price line.

Note: Any new products created in this price line will also require heat numbers.

For more information about Mill Test Reports, see Selling Products Requiring MTR Documents or Providing MTR Documents to Customers

Calculate Rebate On Order Date

Select the Calculate Rebate On Order Date check box if you prefer a calculation of the rebate based on costs at the time of the order. The rebate calculates on the date you create the order.

The Eclipse system, by default, calculates rebates on the ship date. However, the cost of goods sold (COGS) can change from the time when you enter the order to the ship date. The change in COGS can affect the rebate amount.

With this rebate calculation feature activated, the system calculates rebates according to the order creation date for those products in that price line.

 

  1. In the Local Basis area, Closedpopulate each column as needed.

    Column

    Do the following...

    Basis Names

    Enter the local basis names for this price line.

    UoM

    Enter the default unit of measure for the price per unit of measure for this basis name. This entry is the default for the product record's Per UM field for products in this price line. You can change the per unit of measure at the product level, if necessary.

    Currency

    Select the currency from the list that you want to display on the Product Price Sheet Maintenance window, where values are assigned to basis names, or leave the field blank to use the base currency defined in the Base Currency For Exchange Ratescontrol maintenance record.

    You can maintain costs and prices for a price line in the base currency, a foreign currency, or a mixture of both.

    Currencies are defined in the Valid Foreign Currenciescontrol maintenance record.

    View Level

    Assign the user view level (0-9) according to how restrictive you require access to the price or cost associated with this basis name. This field works with the OE.PRICE.VIEW.LEVEL authorization key assigned to a user. The higher the number, the more restrictive the access.

    The highest level for a selling price is typically 5, with levels 6-9 assigned to costs.

    You are allowed to edit a basis field whose view level is lower than the level assigned to the authorization key. For example, if you have an authorization of 9 entered for the OE.PRICE.VIEW.LEVEL authorization key, you can edit all cost and price basis fields. If you have an authorization of 5 entered for the authorization key, you can edit only those basis fields that have a view level of 5 or lower.

    Note: If a view level of zero (0) is assigned to a local cost basis name for a price line, users who have not been assigned the OE.PRICE.VIEW.LEVEL authorization key can view that cost basis and corresponding cost for any product assigned to the price line.

    Inherit from Default Sheet

    Indicate if you want to use the default price sheet settings.

    For information about how price sheet hierarchies work, see How Eclipse Handles Price Sheet Hierarchies in this documentation.

  2. In the Basis field, cross-reference the local basis names with the basis names listed in the Global field, as shown below.

  1. A - Local basis names are defined on this screen and cross-referenced with global basis names.

  2. B - Global basis names are defined in the Global Basis Names control maintenance record.

  3. C - Cross-reference local basis names with global basis names here.

  1. In the PDW Setup area, set the default information for PDW pricing:

Field

Description

Default PDW

Define a default template for importing product data into the PDW.CATALOG, if necessary.

Enable Historical Price Sheets

Select the check box if you want historical data from price sheets available when using this price line.

 

  1. In the Inventory Account Override field, assign a G/L override account to the price line. This overrides a normal G/L posting for the products in the price line.

  2. An account assigned at this prompt displays in the Inventory Account Override column on the Order Entry window. You can override this entry in Product Maintenance.

  3. In the Nonstock area, to include nonstock items in this price line, select Include, otherwise, select Exclude.

Note: You must assign the OE.NSTK.UM.EDIT authorization key to any users to allow access to change the product unit of measure in the UM column on the NonStock Entry screen.

  1. Save your changes and exit the window, or click the New Price Line button to create a new price line.

More Options for Creating Price Lines

The following options are available after you have created a price line:

To...

Use this menu path...

Write or retrieve miscellaneous notes about the price line.

Edit > Notes

Display data applicable to the branch entered in this field.

Edit > Branch Data

Override the global tax exception groups.

Edit > Tax Exception Groups

Displays a view-only dialog box that shows the ranking method assigned to the five ranks in each branch for this price line, the date and time of the last ranking, and ID of the user who ran the ranking assignment.

Edit > Ranking

Set up the points program for customers to reward them for purchasing a target dollar amount of selected products.

Edit > Points

Apply a minimum gross profit percentage (GP%) to the price line to ensure that profits exceed that amount.

Note: The system compares the price entered to the price specified in the Minimum Sell PriceBasis field in Sell Price Maintenance. You cannot change the price to below this basis unless assigned the SOE.MIN.SELL.PRICE authorization key.

Edit > GP%

Write a return policy message for products in this price line. The system displays this message when a user enters a negative order quantity in Sales Order Entry for an item in this price line.

Edit > Return Policy Message

Link to a vendor's web site for more information about products in this price line.

Edit > Product External Reference

Restrict bill-to customers from buying products within certain geographic zones.

Edit > Product Zones

Delete a price line. The system prompts for conformation.

You cannot delete a price line if it has any product records assigned to it.

File > Delete

See Also:

Units of Measure Guidelines in Pricing

Restricting User Access to Pricing Information

Price Line Overview