PD Pricing Setup - Rebate Records - Detail field descriptions

Fields are presented in alphabetical order.

Based From

This field is displayed if you selected Net for the Rebate Calculation Type.

The price or cost that you select for this field is compared to the value in the Amount field. The difference is calculated as the rebate.

Based On

This field is displayed if you selected Percent for the Rebate Calculation Type.

The price or cost that you select for this field is multiplied by the value in the Rebate % field to determine the rebate amount. The options that are available for this field depend on whether you track rebates through Purchase Order Entry or Sales Order Entry.

If purchase orders are used to update rebate amounts in Accounts Payable, you must select a cost in the Based On field.

For nonstocks, you can either select a price or actual cost. Rebates based on other cost types, such as Standard, Last, or Replacement cost, cannot be applied to a nonstock product. Customer rebates or vendor rebates that are based on sale can use any price or cost for this field. If the rebate amount is a percent, it is multiplied against the price of the product that is sold to the customer or the cost of the product. The rebate does not effect on the actual price that is charged to the customer.

Cap Sell Amount

Specify the highest price at which you can sell the product and retain the entire rebate on a Share rebate. The vendor determines this price.

You can specify a dollar amount or a percentage. If you specify a percentage, the Multiplier from the vendor record determines the value that is multiplied by the Cap Sell Amount percentage to convert the Cap Sell Amount into a dollar amount. This calculation is performed when a order line is created, not when the record is set up, thereby using the most current price.


Cap Sell Amount	Type	Rebate Multiplier	Rebate Multiplier amount	Cap Sell Amount = Cap Sell % * Amount designated by the Multiplier
152	$	Not used	Not used	$152
100	%	Base Price	$165	$165
115	%	Cost (Last)	$148	$170.20

You can select Base Price, List Price, or Cost (for Pricing) as the multiplier. The base and list price values are derived from Product Warehouse Product Setup or Product Catalog Setup records. The Cost (for Pricing) value is determined by the Mark Up From field in SA Administrative Options-Products-Costs. You can select Average, Standard, Replacement, or Last. If the Include Addons option is selected, addon costs are included in the cost and used in the rebate calculation.

If you specify a percentage for the Cap Sell Amount, you can accommodate different or fluctuating prices in situations where the rebate applies to multiple products or the price changes.

Capitalize Rebate

Select this option to include the rebate as part of the cost of the product. If the rebate is not capitalized, clear this option.

Contract Cost

This option is available only on the rebate-related price types: Product Rebate, Rebate Type Rebate, Product Price Type Rebate, Product Line Rebate, and Product Category Rebate. You must also select Vendor on Sale to make the Contract Cost option available.

If the Contract Cost option is selected, the Contract # field becomes a required field. When the Contract Cost option is selected, a Vendor Contract Pricing record with a contract cost is created, instead of a line-level rebate record.

Contract Number

Specify the contract number that the rebate applies to.

End Date

Specify the date that the rebate record expires. This is an optional value. If this field is blank, the rebate never expires. If you specify an end date, you can then use the PD Administrator Remove/Inactive Customer Price Report to inactivate and remove the record.

Manual Rebate

If this option is selected, the Vendor on Sale rebate must be applied manually to a line item in Sales Order Entry.

The status of this option depends on these conditions:

If the Use Contract Line # option was selected and a contract line number was specified in PD Pricing Setup-New , this option is selected and you cannot clear it.
If the Use Contract Line # option was not selected but a customer was specified in PD Pricing Setup-New, and a contract number is specified in the General section, you can select this option to create a manual rebate.
If the Use Contract Line # option is not selected and a customer was specified in PD Pricing Setup-New, and a contract number is not specified in the General section, this option is cleared and you cannot select it.

Margin % Guaranteed

This field is displayed if you selected Margin in the Rebate Calculation Type field.

If your vendor guarantees the margin, specify the percent that is guaranteed.

The line item price and the cost that is specified in the Margin Cost field initially calculates the margin. If the actual margin is equal to or greater than the guaranteed margin in this field, the rebate amount is zero. If the margin is less than what is specified here, the rebate amount required to meet the guaranteed margin is calculated.

The To Calculate Margin % Divide By field in SA Administrator Options-Documents-Sales Orders-Processing determines how the margin percentage is calculated.

This is an example of a guaranteed margin calculation if you select Net:

Margin % Guaranteed = 20%
Cost = $10.00
Net = $11.00
Margin % = (Net – Cost)/Net
Margin % = ($11.00 - $10.00)/$11.00 = .09 or 9%
9% < 20%, therefore:
Rebate = (Net x Margin % Guaranteed) – Net + Cost
Rebate = ($11.00 x .2) – 11.00 + 10.00
Rebate = $1.20

This is an example of a guaranteed margin calculation if you select Cost:

Margin % Guaranteed = 20%
Cost = $10.00
Price = $11.00
Margin % = (Net – Cost)/Cost
Margin % = ($11.00 - $110.00)/$10.00 = .10 or 10%
10% < 20%, therefore:
Rebate = [(Margin % Guaranteed x Cost) + Cost – Price]/Margin % Guaranteed + 1)
Rebate = [(.20 x $10.00) + $10.00 - $11.00]/(.2 + 1)
Rebate = $.83

Margin Cost

If you selected Margin in the Rebate Calculation Type field, select the cost to base the margin on.

Price Sheet

Specify the vendor pricing sheet that relates to the Based From value.

Price Sheet Date

The date of the sheet that you specified in the Price Sheet field.

Price Sheet To

Specify the vendor pricing sheet that relates to the Rebate Down To value.

Price Sheet To Date

The date of the sheet you specified in the Price To Sheet field.

Rebate %

Specify a percent that is applied to the price or cost in the Based On field. For example, this rebate is for a product that has a base price of $75.00. You select Base Price in the Based On field and specify 7.00000 in this field. The base price ($75.00) is multiplied by the rebate percent (7%) to calculate a rebate of $5.25.

Rebate Amount

Specify the rebate amount per stocking unit or special price/cost unit. For example, if you specify 5.0000 for a stocking unit of each, the rebate amount is $5.00 for each stocking unit.

If the Foreign Rebates option is selected in SA Administrator Options-Products-Rebates, and the product you are setting up the rebate record for has a foreign currency vendor, the amount is in the vendor's foreign currency.

Rebate Calculation Type

You can base the rebate calculation on an amount, a percentage, a net amount, or a guaranteed margin. The fields available in the General section change in accordance with your selection.

Rebate Down To

This field is displayed if you selected Net in the Rebate Calculation Type field.

You can select a flat rate, price, or cost in this field. If you select Flat Rate, the value in the Amount field is compared to the cost or price in the Based From field. The difference is calculated as the rebate.

If you select a price or cost, the value in the Rebate Percent field is compared to the cost or price in the Based From field. The difference is calculated as the rebate.

Rebate Percent

This field is displayed if you selected a price or cost in the Rebate Down To field.

Specify the percent of the selected price or cost that you want to compare to the Based From cost or price. The difference is calculated as the rebate. For example, if the cost or price of the product in the Based From field is $100.00, the cost or price in the Rebate Down To field is $80.00, and you specify 110.00000 in this field, this rebate calculation is used:

1.10 x $80.00 = $88.00

$100.00 – $88.00 = $12.00

Rebate due is $12.00

Reference

Specify a user-defined value, which is set up in SA Table Code Value Setup, that pertains to this record.

Share Rebate: Select this option to indicate that the rebate record is a Share rebate and to access the related fields.
Share Rebate Percent: Specify the percentage by which the rebate is reduced if the product is sold over the Cap Sell Amount. This percentage is only applied to the amount in excess of the Cap Sell Amount. The default value in zero.
Use Contract Line #: If this option is selected, the rebate applies to a specific line on a contract. The contract number and contract line number are displayed. You cannot edit this field.
Use Rebate Price: If this option is selected, the rebate is a Vendor on Sale that is based on the selling price of the product.