Understanding Basis Codes for Purchase Order Adjustments

Note: Basis codes 3, 4, and 9 are not supported for basket pricing for purchase orders.

This table describes how to configure basis codes, factor values, and formula names for purchase order 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 Supplier Price or Inventory Cost	The system multiplies the supplier price or inventory cost 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 Supplier Price or Inventory Cost	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	If you enter Basis Code 3, the system issues an error. For purchase order adjustments, you must use Basis Code 1 to choose a percentage of the supplier price or cost.
Cost Plus Amount	If you enter Basis Code 4, the system issues an error. For purchase order adjustments, you must use Basis Code 5 to add an amount to the unit cost.
Add on Amount	The system adjusts the supplier price or inventory cost 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 supplier price or inventory cost 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 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. If you plan to use the unit cost in the F4075 table as a 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. Each component must be identified by a special character. 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, the formula. 90*&GOLD represents the adjusted price of the item is that 90 percent of the current price of gold. 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 F4311 or F43121 (for Receipt adjustments) tables 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 of these tables 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. Note: Oracle is not responsible for providing custom programs and does not provide support for custom programs.

Note: If you are using JD Edwards EnterpriseOne Advanced Pricing and Procurement, you must enter a Supplier Group name instead of a Customer Group.