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:

• Global Buy/Sell Basis Names - Define global basis names for standard pricing.

• Cost Of Goods Sold Basis Name - Assign a basis name to your cost of goods sold (COGS).

To create a price line:

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

2. In the Price Line ID 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 special characters.

   2. Asterisks (*)

   3. Ampersands (&)

   4. Tildes (~)

   5. At signs (@)

   6. Carats (^)

   7. 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.

3. 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.

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

5. In the Local Basis area, populate 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 Rates control 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 Currencies control 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.

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

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

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

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

7. In the Default PDW field, define a default template for importing product data into the PDW.CATALOG, if necessary.

8. 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.

9. 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.

10. 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.

11. 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:

See Also:

Units of Measure Guidelines in Pricing

Restricting User Access to Pricing Information

Price Line Overview