SA Administrator Options - Products - Pricing field descriptions

Enable Price Types

Select the price types to use on customer pricing record in PD Pricing Setup. Your options are:

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

You must select Customer/Product Price Type before you can select Customer/Product Line, Customer/Product Category, or Customer/Rebate Type.

Note:  Because the number of price types you select affects Sales Order Entry performance, only set up the price types that your company uses. All selected price types are checked within the pricing hierarchy, even if you do not use them. The fewer options that you select, the faster Sales Order Entry can process pricing inquiries.

Options

Auto Calculate Foreign Currency
Select this option to automatically calculate and display the amounts on a sales order in the customer’s currency if the customer is a foreign customer. This option eliminates the need to create pricing records in foreign currency or to use a manual calculator during order entry to calculate the prices in foreign currency.

The foreign currency calculation uses the currency specified for the customer in the Currency field in Customer Setup-General and the Sales Exchange Rate specified in SA Currency Setup. The sales exchange rate is determined when the order is created and is maintained throughout the life cycle of the order

If the Auto Calculate Foreign Currency option is enabled and customer is a foreign currency customer, then all the prices, discounts, etc. are stored in the currency set up for the company. These prices, discounts, etc., are then converted to the current foreign currency exchange rate when an order is created. Costs and margins on an order are always displayed in domestic currency.

If Auto Calculate Foreign Currency is not selected and the customer is a foreign currency customer, then you are expected to create pricing records in foreign currency to see the product price in the customer’s currency during order entry. If the pricing records in foreign currency are not available, then prices are displayed in the currency set up for the company.

Standard currency codes such as USD, MEX, CAD are prominently displayed throughout the functional area in the Sales and Transfer modules to make you aware that the transaction is a foreign currency transaction.

Note: If a customer’s currency is foreign, then the foreign currency is displayed on the ship to record even if the ship to is considered domestic by location.
Pricing By Division Group

Select this option to create PD Pricing Setup and PD Pricing Sheet Setup records for division groups. You can set up pricing records for warehouses in a group of divisions with a similar pricing structure with a blank warehouse to control the pricing for all such warehouses. Pricing by division groups is an alternative to pricing by regions, where you have some warehouses that should not share pricing records. This allows you to create a single price record or pricing sheet record that is applied to sales orders in multiple warehouses instead of creating a price record for each warehouse.

Pricing By Region

Select this option if to create pricing records for regions in PD Pricing Setup and PD Pricing Sheet Setup.

In the pricing level hierarchy, region falls between the warehouse or company levels. If you enable regional pricing functionality, you can still set pricing records by warehouse but an individual record can only be set at one level.

To use the region functionality, you must set up regions in SA Table Code Value Setup. Optionally, you can specify the region in which a warehouse is located in Product Warehouse Description Setup-General.

Pricing By Ship To/Job

Select this option to display the Ship To/Job field in the customer’s PD Pricing Setup record. This enables you to record the ship to and job for these price types:

  • Customer/Product
  • Customer/Product Price Type
  • Customer/Product Line
  • Customer/Product Category
  • Customer
Pricing By Warehouse

Select this option to create PD Pricing Setup, PD Special Price Type Discount Setup, and PD Whole Order Discount Setup records for warehouses that require a unique pricing structure to be competitive. You can set up pricing records for warehouses with a similar pricing structure with a blank warehouse to control the pricing for all such warehouses. Alternatively, you can set the base prices, price types, list prices, and costs for each individual warehouse.

Note:  After you establish Pricing and Discounting records by warehouse, do not change this option. Maintaining individual warehouse records makes the pricing system larger and more cumbersome to maintain. Because costs, list prices, base prices, and price types are stored at the warehouse level, warehouse-level Pricing and Discounting records are often unnecessary.

If you do not select this option, pricing by warehouse is not supported, and the Product Warehouse Description Setup record is ignored.

  • Example:
  • There are four warehouses. Three warehouses maintain a similar pricing structure for a product. One warehouse needs specific pricing to remain competitive in their market. You can specify the warehouse on the PD Pricing Setup, PD Special Price Type Discount Setup, and PD Whole Order Discount Setup records for the fourth warehouse to reflect the special pricing required.
  • The pricing records for the warehouses with a similar pricing structure can be set up with a blank warehouse to control the pricing for all three warehouses. You can also use the base prices, price types, list prices, and costs at the warehouse level. Do not change this option after you have established Pricing and Discounting records by warehouse.
Promotional Pricing

Select this option to use promotional pricing. Promotional pricing is only valid with the Product and Product Price Type pricing records. If you are using these price types, you can designate Product or Product Price Type customer pricing records as promotional.

In Sales Order Entry, the standard pricing hierarchy is used to find a valid price. The Product and Product Price Type pricing records are checked first for promotional pricing. After the promotional price has been determined, the system price is calculated. The system price is determined starting with Customer/Product pricing records. The promotional price and the system price are then compared. The lowest price is used as the product price.

If Use Multiple Level Best Price is selected in SA Administrator Option-Products-Multiple Level, a multiple level price can take precedence over promotional pricing.

Rebate Sub Type

Select this option to allow rebate sub types to be specified on these pricing records in PD Pricing Setup and PD Mass Maintenance Entry:

  • Type 2 Customer/Product Rebate
  • Type 4 Customer Type/Rebate Type

Pricing records with rebate sub types are included in the pricing hierarchy that is used for system pricing. Type 2 and Type 4 pricing records with a rebate sub type are higher in the hierarchy than Type 2 and Type 4 pricing records that only include rebate types.

Special Price Type Discounts

Do not select this option if you do not use price group discounts. PD Special Price Type Discount Setup records are used in Sales Order Entry to calculate new line item discounts. All line items with the same product price type are added together to qualify for a better discount. This occurs at the end of each order and each time a line is changed that affects the discount.

If you change the setting of this option, open orders are posted out-of-balance to General Ledger during invoice processing.

Use Rebate Pricing Records Before Price Type

Select this option to override the standard pricing hierarchy to prioritize Type 4 rebate records over Type 4 Product Price Type records.

These Type 4 rebate records are used before the Type 4 Customer Type/Product Price Type records:

  • Customer Type/Rebate Sub Type
  • Customer Type/Rebate Type

Use the Level 2 Pricing Hierarchy Override Hierarchy list to override the pricing hierarchy for Level 2 pricing records.

Use Sales Cost

Select this option to use sales costs as the product cost on sales order lines. Sales costs are based on your vendor contracts, and can be set up on Level 1-4 PD Pricing Setup records. A sales cost is used when a line is priced by a pricing record with a sales cost.

Level 2 Pricing Hierarchy

To select an alternate pricing hierarchy for Level 2 pricing records, click and hold a pricing type in the Override Hierarchy selection table and drag it to the desired position. When you click Save, the order in the Override Hierarchy list is the new order in which Level 2 pricing records are applied to an order line's price in Sales Order Entry.

Use the Default Hierarchy list as a reference only. This list represents the default order of the Level 2 pricing records. It cannot be modified.

Note: All four Level 2 price types are displayed in the Override Hierarchy list even if you did not select all types in the Enable Price Types section.

Defaults

Last Available Price Record Used

This value is used to determine the next available number for a pricing record. Each time you create a pricing record, a search for the next available record is performed starting with the value in this field. You can specify a value, but it is not required. When you create a new pricing record, the number of the record updates the field when you save the record.

Price Rounding

Price rounding is used whenever prices are calculated from base price, list price, or cost figures. The value selected in this field works in conjunction with the Pricing Target in PD Pricing Setup. Indicate whether to round the price, up or down, to the pricing target amount, or nearest, up or down, depending on which is nearest to the pricing target. Sales Order Entry uses the Pricing Round in PD Pricing Setup to determine how to round the price.

Select the most common price rounding calculation that you use. It is used as the default setting for the Round field on each new PD Pricing Setup record.

Price Target

There are several values available for the default Price Target. Each target specifies the format of the price displayed in Sales Order Entry. This option works with the Price Rounding option to round the price up, down, or nearest to $100, $10, $1, or out to five decimal positions. Select .00001 for exact pricing. Because the Price field in Sales Order Entry and the default price target .00001 extend to the fifth decimal position, the exact price is calculated without rounding. If you select User, you must specify a User Target amount in PD Pricing Setup. This is an example of how price targets work when you select Nearest for the Price Rounding option:

Price Price Target value Price result
$135.87629 100 $100.00
$135.87629 10 $140.00
$135.87629 1 $136.00
$135.87629 .1 $135.90
$135.87629 .01 $135.88
$135.87629 .001 $135.876
$135.87629 .0001 $135.8763
$135.87629 .00001 $135.87629

Select the most common price target that is used. It is used as the default setting for the To field in the Extended section on each new PD Pricing Setup record.

Vendor Contract Pricing

Purchasing

Purchase Order Price Allocation

The below options determine the selection of Vendor Contracts in Purchasing and the records that are visible for selection from a contract list:

  • Manual Contract Allocation: Specify the contract number to search for and apply a specific contract pricing record. Operator must manually select the contract to be used on the order as the contract list is not presented.
  • Lowest Price Allocation: Specify this option to generate a list of Vendor Contract records to select from. The list is generated based on the vendor on the order and ordering warehouse. The contract list displays the contracts in the ascending order.
  • Lowest Price Including ARP Warehouses: Specify this option to generate a list of Vendor Contract records to select from. The list is generated based on:
    • The vendor on the order and ordering warehouse.
    • The Ordering Warehouse of the item is an ARP Vendor or VMI type.
    • he Ordering Warehouse is the ARP Warehouse for the item and those warehouses.
    The list includes the additional Warehouse specific Contracts for the Warehouses attached to the ordering warehouse. The contract list displays the contracts in the ascending order.

To use this functionality, you must also set up the access control for an operator in the Vendor Contract Pricing Access for Purchasing field on the SA Operator Setup - Entry Options screen.

Auto Assign Vendor Contract on RRAR
Select this option to automatically apply the active vendor contract with the lowest price to each PO line item on the Purchase Entry Recommended Replenishment Action Report (POERR). The PO line is automatically repriced using the price from the selected contract. This functionality is only available when you select Lowest Price Allocation or Lowest Price Including ARP Warehouses option in the Purchase Order Price Allocation field.

System

Vendor Product Pricing

If you use PD Pricing Setup for vendor pricing, select this option. The vendor's prices are your costs. They are used to calculate quantity discounts that are recorded with the Product Warehouse Product Setup quantity break order method. Vendor product pricing is used to set up special product prices and discounts to be used in Purchase Order Entry and by the Purchase Entry Recommended Replenishment Action Report.

Enable Product Line
Select this option to view and use the Product Line as a record type on the PD Pricing Setup screen. By default, this check box is clear. If you define vendor contract records at the product line level in the PD Pricing Setup screen, then you can use the vendor product discounts for all products tied to a particular product line.