Understanding Basis Codes for Sales Adjustments

This table describes how to configure basis codes, factor values, and formula names for sales adjustments:

Adjustment Type	Configuration Information
Percentage of New Base Price	The system calculates the new base price on all adjustment definitions in the adjustment schedule through and including the adjustment definition with the New Base Price selection. In the Basis Code field, enter 0. Select Set New Base Price from the Row menu on Price Adjustment Schedule Revisions form. If you do not select Set New Base Price from the Row menu on the Price Adjustment Schedule Revisions form, the systems calculates the new base price as it does for a 1 in the Basis Code field.
Percentage of Base Price	The system multiplies the base price by the factor value. In the Basis Code field, enter 1. In the Factor Value field, enter a positive number for markups or a negative number for discounts.
Percentage of Current Net Price	The system multiplies the current net price by the factor value. In the Basis Code field, enter 2. In the Factor Value field, enter a positive number for markups or a negative number for discounts.
Percentage of Cost	The system multiplies the item cost by the factor value. Before this combination can be calculated, you must identify the item cost in the Cost Method field in the Price Adjustment Detail. In Basis Code field, enter 3. In Factor Value field, enter a positive number for markups or a negative number for discounts.
Cost Plus Amount	The system adds the factor value to the item cost. Before this combination can be calculated, you must identify the item cost in the Cost Method column of the grid area. In the Basis Code field, enter 4. In the Factor Value field, enter a positive number for markups or a negative number for discounts. In the Cost Method field, enter the cost method code.
Add on Amount	The system adjusts the price by the factor value. In the Basis Code field, enter 5. In the Factor Value field, enter a positive or negative number, depending on the penalty parameters.
Add on Variable Amount	The system retrieves the adjustment amount from the F4075 table. Set up variable prices when the price of an item varies frequently, even as often as daily. Use Price Variable tables to set up prices and effective dates. In the Basis Code field, enter 6. In the Formula Name field, enter the code or name that identifies the variable table. By selecting any adjustment detail line and selecting Variables from the Row menu, you can access the Work with Price Variable Tables form. If you plan to use the price in the F4075 table as a base price, make sure the adjustment to which you attach the table is an override adjustment. This ensures that you override any other price with the price from the F4075 table.
Add on Formula Amount	The system calculates the price adjustment using a formula. A special character must identify each component. You define these characters during system setup in the pricing constants. The system evaluates formulas as standard algebraic notations: whatever is inside parentheses is evaluated first, then multiplication, division, addition, and subtraction. For example, 90*&GOLD represents that the adjusted price of the item is 90 percent of the current price of gold.In addition to standard mathematical functions, you can use min (minimum), max (maximum), and average functions to enter additional parameters in the formula. In the Basis Code field, enter 7. In the Formula Name field, enter the code or name that identifies the formula. To return a field name to the formula, include a field from the F4211 table by accessing the File Field Descriptions form. The system automatically inserts the field name and precedes it with the character you specified in the system constants to identify field names. You cannot use all fields from the F4211 table in a formula.
Add on User Program Amount	The system calls a user defined program to calculate the price adjustment. In the Basis Code field, enter 8. In the Formula Name field, enter the program ID for the custom program. The name of the function specified for the level break should be no more than eight characters. In addition, the name of the business function must match the name specified in the Adjustment detail. Note: Oracle is not responsible for providing custom programs and does not provide support for custom programs.
Gross Profit Margin	The system calculates the price adjustment according to the gross profit margin. In the Basis Code field, enter 9. In the Factor Value field, enter the gross profit margin percent. For example, enter 10 to adjust the price by 10 percent.