PD Pricing Setup - Price Records - Detail field descriptions

Fields are presented in alphabetical order within each section.

General

Active

This option indicates if the record is active or inactive. When you create a record, the record is active by default. When you clear the option, the record is inactive and is not used in the pricing hierarchy. When you reactivate a record, it is used in the pricing hierarchy if it meets one of the conditions:

  • The End Date field is blank.
  • The current date falls within the start and end date range.
Allow with Vendor on Sale Rebate

Select this option to allow a pricing modifier to be applied if a vendor on sale rebate record is found.

Based On

When you select % Current in the Price Type field, select one of these values to calculate the price levels:

  • Base Price or List Price: The price multipliers are multiplied against the corresponding value from the Product Warehouse Product Setup record.
  • Cost: The price multipliers are multiplied against the cost from the Product Warehouse Product Setup record, based on the Mark Up From field in SA Administrator Options-Product-Cost.
  • Margin: The price levels are calculated to result in the margins that you specify in the Price field in the grid. The margins must be less than 100. The cost from the Mark Up From field in SA Administrator Options-Product-Cost is used in the calculation.

    For example, the replacement cost is used to determine the price based on the Mark Up From field. The replacement cost for the product is 120. The margin percentage is 30%. This calculation is used to determine the net price:

    • 120 / 70% = 171.43 net price
    • where 171.43 - 120 = 51.43 margin amount
    • and
    • 51.43 / 171.43 = 30 margin percentage
  • Rebated Cost or Rebated Margin: A rebate record is required for the product. The price is based on the cost or margin after the rebate is applied. For example, a product costs $20 and there is a $5 rebate. The rebated cost is $15 (cost – rebate).
Note: The value from the Multiplier field in Product Setup is the default value for this field.
Break On

You can set up price breaks by levels of discounts or prices, based on the quantity that is purchased. When the Price Level field in Customer Setup-Ordering is zero, pricing is not used. When it is greater than zero, the corresponding quantity break record is used.

When you select Price, pricing is based on the price or pricing factor in the Price field at the level purchased.

When you select Discount, pricing is based on the discount factor in the Discount field at the level purchased.

When you select None, pricing is based on the price, pricing factor, or discount factor at the level selected in Customer Setup-Ordering.

You can update the Price and Discount fields in the Levels grid in the Price Detail section. The Price Break column is available in the Level grid if you select Price or Discount.

Break Per

Use this field to determine how to apply the minimum quantity and maximum quantity requirements. When you select Order, the actual quantity is set to zero at the beginning of each new order.

When you select Contract, Monthly, or Yearly, the actual quantity is updated when these conditions are met:

  • You specify or change a product in Sales Order Entry or Sales Shipping Feedback Entry
  • The pricing record is used to price the line item on the sales order.
Commission Type

Use this field to override a sales representative’s standard commission plan to offer a promotional commission to your sales representatives and your customers. The commission from a pricing record is used if the pricing record is applied to a line item during sales order entry. Otherwise, Sales Salesrep Setup records are used to determine commissions.

Contract #

If the pricing record or rebate is tied to a specific contract with a vendor, then specify the contract number.

End Date

Specify an ending date if the prices and discounts on this record apply for a specific length of time. You can use the PD Administrator Remove/Inactive Customer Price Report to inactivate and remove expired pricing records. If the prices and discounts are standard and non-promotional, then leave this field blank so that the record never expires.

Line Reference

When you create a quote record in Sales Customer Pricing Inquiry, a price record can be created and stored as an active quote on the pricing worksheet. If you provided a reference number, then the number is displayed in this field.

A Line Reference field is available at the header level in Sales Order Entry. The value at the header level updates the line reference at line level. If the line reference at the header level is blank, but the pricing record contains a line reference, then the line reference from the pricing record updates the line reference at the line level. The Line Reference field at the header level remains blank.

Modifier Name

Select a pricing modifier to apply to the pricing record. Pricing modifiers are set up in PD Pricing Modifier Setup. The correct percentage from PD Pricing Modifier Setup is applied to an order line that qualifies for this pricing.

Price Effective Date

Use this field to locate a price sheet. Specify a date, and then click Sheet Prices to view the prices on the sheet. This field is available if you select % Sheet in the Price Type field.

Price Sheet

Use this field to locate a price sheet. Specify a sheet, and then click Sheet Prices to view the prices on the sheet. This field is available if you select % Sheet in the Price Type field.

Price Type

Select one of these values to indicate what the price record is based on:

  • % Current

    Select this value to multiply the price multipliers against the base price, list price, or cost from Product Warehouse Product Setup, based on the Based On field.

  • Amount Actual

    Select this value to group products with identical prices. Amounts are valid records that are product based, such as these:

    • Customer/Product Price Type
    • Customer/Product Line
    • Customer/Product Category
    • Customer Price Type/Product Price Type
    • Product Price Type
  • % Sheet

    Select this value to base the pricing record on a vendor price on a pricing sheet. When you select this option, the Price Sheet and Sheet Date fields are displayed. Specify a value in one of the fields and then click Sheet Prices to view the prices on the sheet. Pricing sheets are set up in PD Pricing Sheet Setup.

Promotional

If the Promotional Pricing option in SA Administrator Option-Products-Pricing is selected, then this field is available when you create a product or product price type record. Select this option to indicate that the price is promotional. In Sales Order Entry, the best non-promotional price is compared to the promotional price. The lowest price is used for the line item.

Reference

Select a reference code to apply to the record. Reference codes are set up in SA Table Code Value Setup.

Terms Discount

Discounts can be based on order or lines. Both types of discounts are set up in SA Table Code Value Setup. The order-based terms can be specified on the Customer Setup record and the line-based terms can be specified on Product Setup or PD Pricing Setup records. The default for this option is based on the same option in Product Setup. If a terms discount does not exist on the Product Setup record, then this option is selected. To apply product-specific cash terms, clear this option and specify the terms discount percent in the Terms Discount % field.

Terms Discount %

Specify the percent of the terms discount. If a default value is displayed, then it is from the Terms Discount % field in Product Setup. If product-specific terms discounts are used in Sales Order Entry, then specify the percent of the terms discount in this field.

Price Detail

Base Price

The base price from the Product Warehouse Product Setup record.

Cost

The cost from the Product Warehouse Product Setup record, based on the Mark Up From field in SA Administrator Options-Product-Cost.

List Price

The list price from the Product Warehouse Product Setup record.

Discount

Specify the discount factor for the pricing level.

Price

Specify the price or pricing factor for the pricing level.

Price Break

Specify the ordered quantity at which the pricing level applies. This column is not displayed if you selected None in the Break On field.

Extended

Actual

This field is valid for Customer/Product and Vendor Contract pricing records. It is used in conjunction with the Maximum Quantity and Break Per fields.

Do not specify a value in this field. The value increases each time a sales order or purchase order line uses this record until the Break Per selection is reached. When the Break Per field is blank, this field is not updated. When you select Monthly or Yearly in the Break Per field, the first order must qualify for the minimum quantity before the order quantity begins to accumulate. Changing, deleting, and canceling line items on an order that affect the actual quantity cause it to decrease.

The actual quantity plus the current quantity ordered is used to determine the correct quantity break level when these conditions are met:

  • This record is based on quantity breaks.
  • The value in the Break Per field is Contract, Monthly, or Yearly
Based on

If you set up a price record with minimum and maximum quantities, then select the unit that the quantities are based on. You can select Stocking Unit, Weight, Cube, or SPC Unit. If you select SPC Unit, then verify that all products that are assigned to this price type have the same value in the Special Price/Cost Unit field in Product Setup. Any product that does not is assigned a factor of 1.

Hard Maximum

If you specified a maximum quantity, then select this option to prevent the price from being applied after the maximum quantity is reached. A warning indicating that the maximum quantity was reached is displayed to the user. Additionally, an Event Manager event is triggered to notify the manager that the customer was given the price after reaching maximum quantity.

Hard System Price

Select this option to prevent a user from overriding the price in Sales Order Entry, Sales Customer Pricing Inquiry, or Product Inquiry-Pricing. When this option is selected, any Multiple Level Customer Price Types that may apply are skipped. When this option is clear and Multiple Level Customer Price Type records are found, the limitation is honored if the option is selected for the 'best price' in one of the levels.

You can override a hard system price if Yes is selected in the Allow Override of Hard System Price field in SA Operator Setup-Entry Options. If you attempt to change a hard system price but are not allowed, then this message is displayed: System Price Override Not Allowed - Hard Price Set (PDSP.

Last Used Date

The date that the pricing record was last used to provide a calculated price in an inquiry or entry function. This field is a read-only.

Maximum Quantity

This field is used in conjunction with the Minimum Quantity field. Specify a maximum amount of the product that a customer can order. After the maximum quantity is reached, the prices and discounts from this record no longer apply. The next qualifying pricing record is then selected in Sales Order Entry.

The value in the Actual field determines if the maximum quantity has been reached. When the actual quantity plus the quantity being ordered exceeds the maximum quantity, the order line is updated with the price and discount from this record. When the next order is placed, the customer no longer qualifies for the prices and discounts on this record.

Leave this field blank if the prices and discounts always apply, unless a minimum quantity has been specified or the ending date has expired.

Minimum Quantity

Specify the minimum amount that a customer must order to qualify for the prices and discounts on this record. Typically, this field is used with these types of pricing records:

  • Customer/Product
  • Customer/Product Price Type
  • Customer/Product Line
  • Customer/Product Category
  • Customer

Use the Break Per field to specify whether the minimum quantity is per order, month, or year. If the minimum quantity is not reached, then the next qualifying pricing or discounting record is selected in Sales Order Entry.

The value in the Actual field is used to determine if the minimum quantity has been reached. It is recorded when the first order qualifies for the prices and discount. Thereafter, the actual quantity is compared with the maximum quantity. Leave this field blank if all orders, regardless of the quantity ordered, qualify for the prices and discounts on this record.

Override Tolerance Down

Specify the percent below the price that is tolerated. You can use an override tolerance if the Hard System Price option is cleared.

Override Tolerance Up

Specify the percent above the price that is tolerated. You can use an override tolerance if the Hard System Price option is cleared.

Round

If you selected % Current in the Price Level field, then select a method to round the calculated price in Sales Order Entry. You can round a price up, down, or to the nearest target that you select in the To field. If a price rounding value is selected in SA Administrator Options-Products-Pricing, then it is the default value in this field.

Sales Cost

Select one of these values to determine how the sales cost is calculated:

  • % Current: Calculates the sales cost, based on the values in the Sales Cost Based On and Sales Cost Amount fields. You can select this value for Level 1-4 pricing records.
  • Actual Amount: Uses the value in the Sales Cost Amount field as the sales cost. You cannot select this value for Product Price Type pricing records, Levels 2 and 4. A stocking unit must be set up for the product in Product Setup. Otherwise, physical unit and special price costing conversions may not be correct.
Note: When you specify sales costs information, the value in the Based On field in the General section cannot be Base Price or List Price.
Sales Cost Amount

If you selected % Current in the Sales Cost field, then specify the percentage to use to calculate the sales cost. The percentage is multiplied by the price or cost that you selected in the Sales Cost Based On field. For example, if you specify 15 in this field and Base Price is selected in the Sales Cost Based On field, then the sales cost would be 15 percent of the base price listed on the warehouse product record.

If you selected Actual Amount in the Sales Cost field, then specify the sales cost of the product.

If you select values in the related sales cost fields on this page but leave this field blank, then a sales cost is not calculated.

Sales Cost Based On

If you selected % Current in the Sales Cost field, then select a price or cost to base the calculation on. The prices and costs are from Product Warehouse Product Setup. If you selected Actual Amount in the Sales Cost, then select None.

To

Use this field in conjunction with the Round field. Select the number of decimals to round the price to in Sales Order Entry. If you select User, then the User Target field is displayed.

User Target

This field is displayed if you select User in the To field. Specify the two-decimal value to which to round prices. For example, if you specify .95 in this field, then all prices are rounded up or down to the nearest to .95. For example, $1.95, $2.95, $34.95.