Working with Repricing

This chapter provides an overview of repricing and discusses how to:

• Review Price and Adjustment Changes

• Work with the Basket Master.

• Apply adjustments to items in an enhanced basket.

• Create order-level adjustments.

• Reprice sales orders.

• Reprice purchase orders and receipts.

• Revise adjustments.

Understanding Repricing

You can set up adjustments to reprice sales orders. You reprice sales orders for these reasons:

• To allow additional discounts or markups on groups of items.

• To give different pricing to special items or customers.

• To give global discounts based on the total quantity, weight, or amount of items within a product family.

You set up repricing based on the amount of the order, weight of the items, or the total quantity of all items in an order. In the definition for each adjustment, you must specify whether you want to use the adjustment for basket or order repricing. You can repeatedly reprice an order line. You must set a reprice processing option in the reprice program you use to enable order detail lines to be repeatedly repriced.

Note. You can only use reprice adjustments for sales orders. If you use JD Edwards EnterpriseOne Advanced Pricing and Procurement, you cannot reprice purchase order adjustments.

Reviewing Price and Adjustment Changes

This section provides overviews of these reports:

• Price Adjustment Maintenance (R41840).

• Orders Affected by Price Change (R40821).

The reports list all adjustments and the changes made to the adjustments. The reports also include any new adjustments, effective dates, and new factor values.

Note. When running the adjustment reports, you must include the Unit of Measure field in data selection so that the system applies the update or addition adjustment value consistently.

The Price Adjustments Maintenance program includes the versions for these adjustment reports:

• Price Adjustment Report.

• Price Adjustment Revisions Report.

• Future Adjustments Additions Report.

You can run the Price Adjustments Maintenance program (R41840) in proof or in final mode. Run the program in proof mode to review the report and make changes before you run the program in final mode. You can run this program in proof mode as many times as necessary.

When you set up the version of the Price Adjustments Maintenance program, you can choose fields that the system selects from the based-on table. Choosing specific fields is especially helpful if you do not want to print or update all of the information.

You can also print the Orders Affected by Price Change Integrity report (R40821) to review orders that could potentially change due to changes to adjustments.

Understanding the Price Adjustment Report

When you run the Price Adjustments Maintenance program, the system prints only existing adjustments for each record that it selects. It does not make changes or updates. To run this version, leave all processing options blank.

Understanding the Price Adjustment Revisions Report

You can make individual changes to adjustments using the Price Adjustment Detail Revisions form. Alternately, you can change adjustments or add adjustments using the Price Adjustments Maintenance program. The system bases new adjustments on the current adjustment selected by the report writer.

You choose the Price Adjustments Revisions version of this report. You can run this version in proof or final mode.

When you run this program, the system prints a report that shows the old and new factor values for each adjustment. You create this version by entering an adjustment factor and setting up processing options.

Understanding the Future Adjustments Additions Report

To create new adjustments, select the Future Adjustments Additions version of the Price Adjustments Maintenance program. In the processing options for this version, enter the effective dates of the new adjustments. You can also specify whether the system updates the Price Adjustment Detail table (F4072) in the processing options.

The system bases new adjustments on the existing adjustment with the most recent expiration date. It assumes that the adjustments you want to create will be effective on a future date. To avoid problems, do not create adjustments for past dates. Do not change the sequencing for versions that create new adjustments. Changing sequencing causes the system to use the incorrect record.

You can change the new adjustment before the system writes it to the table. To do this, enter the adjustment type and factor in the processing options. The system uses this information to change the new adjustment.

If you leave the adjustment type and factor blank, the system copies the adjustments from the current adjustment. It does not create a new adjustment. You must specify a from and a through date or the system does not process the information.

Proof mode prints a listing of the additions that occur if you process these adjustments. Final mode lists the additions made when you selected final.

Understanding the Orders Affected by Price Change Report

The Orders Affected by Price Change integrity report (R40821) lists the orders that could potentially change based on changes to adjustments, variables, or formulas since the order creation date.

Print the Orders Affected by Price Change for sales orders only.

Understanding Pricing at Settlements

You can change a price adjustment made during receipts entry. The system records the appropriate journal entries to record these variances.

See Processing Advance Payments.

Working with the Basket Master

This section provides an overview of the basket master, lists a prerequisite, and discusses how to

• Set up basket master information.

• Create basket-level adjustments.

Understanding the Basket Master

Use the Basket Master program (P4550) to enter and maintain baskets. You can define all characteristics of a basket, including the basket name (set up in user defined code (UDC) 40/PI) and all of the items and item groups that are part of the basket. The same item can be part of multiple baskets, and you can apply multiple baskets to a qualifying order.

You also can use the Basket Master program to define the item characteristics, such as criteria for accumulations and adjustments, as well as pricing rules for the items and item groups.

When you set up the criteria for accumulations, you specify a basket accumulation rule (set up in UDC 45/BA) that determines how the system applies adjustments to the baskets. The basket pricing rule (set up in UDC 45/BP) that you specify also determines how the system applies adjustments.

Basket Master Information

To use enhanced basket functionality, you must perform setup tasks for determining how the system applies the basket adjustments. First, you must indicate which items and item groups belong in the basket. You must also specify a basket accumulation rule and a basket pricing rule for the items that are contained in the basket. By doing so, you can specify discounts that apply to a particular item or item group as opposed to specifying a single discount for the entire basket.

The options for the basket accumulation rule are:

• 0: Include the item or item group in basket summary; no minimum required.

• 1: Include the item or item group in basket summary; minimum required.

• 2: Exclude the item or item group from basket summary; no minimum required.

The options for the basket pricing rule are:

• 0: Standard basket adjustment.

• 1: Exception pricing.

• 2: Neither standard nor exception pricing.

The Basket Master program allows you to specify the unit of measure for accumulation, the basket accumulation rule, the basket pricing rule, and effective and expired dates as default information in the header portion of the form that displays by default into the detail area, where the contents of the basket are itemized.

The system stores master basket information in the Basket Master Header table (F4550).

Basket-Level Adjustments

Basket repricing allows you to modify the price for items based on a basket repricing group. The system searches the detail lines of a sales order to determine whether the items are in a basket repricing group. When it finds items that belong to the group, it updates the order line with the new price.

You reprice sales orders:

• Through a batch program after order entry.

  The system bases new prices on the price in the original sales order detail line. It performs basket repricing first and then order repricing.

• Interactively during order entry by choosing the appropriate option from Sales Order Entry Detail (P4211).

  The batch program performs basket repricing first and then order repricing.

• Automatically at order entry when you set the Auto Order Repricing processing option on the Process tab if the Sales Order Entry Detail program.

When you enter an order for items included in the basket repricing group, the system applies the item base price with adjustments. To use the reprice adjustment, select the appropriate function to reprice the order. Changes to the base price reflect the repricing adjustment.

You can also indicate whether the adjustment is an enhanced basket adjustment by selecting the appropriate option. If you specify an enhanced basket adjustment, the system provides you with the Adjustment Per Basket Item form, where you can enter the exception adjustment details. Otherwise, the system applies standard basket repricing.

Prerequisite

To enable enhanced basket functionality, ensure that you have selected the Enable Basket Master option in the Price Adjustment Definition program (P4071).

Forms Used to Work with Basket Master Information

Setting Up Basket Master Information

Access the Basket Master Revisions form.

Creating Basket-Level Adjustments

Access the Modify Adjustment Controls form.

Applying Adjustments to Items in an Enhanced Basket

This section provides an overview of item-level adjustments in enhanced baskets, lists a prerequisite, and discusses how to apply adjustments to items in an enhanced basket.

Understanding Item-Level Adjustments for Items in an Enhanced Basket

The enhanced basket repricing feature enables you to create item-level (including item group-level) adjustments for the items in an enhanced basket so that you can apply various discounts to the items or item groups rather than applying one standard adjustment to the entire basket. You enter exception information by using the Price Adjustment Detail Revisions program. The information that you can enter depends on the basket accumulation and the basket pricing rules you set up in the Basket Master program.

After you enter exception information for the items or item groups in the enhanced basket, you cannot delete or change the corresponding records using the Basket Master program. If you need to change basket master information, you must first delete the exception information using the Price Adjustment Detail Revisions program.

If you specify that a minimum quantity of an item or item group is a requirement in the basket accumulation rule and you do not specify that minimum quantity when entering exception information, the system does not apply the adjustment.

Prerequisite

Ensure that you have chosen the option for enabling the enhanced basket repricing feature on the Price Adjustment Definition form. You access this form when working with the Price Adjustment Type program.

Form Used to Apply Adjustments to Items in an Enhanced Basket

Applying an Adjustment to Item in an Enhanced Basket

Access the Adjustment Per Basket Item form.

Creating Order-Level Adjustments

This section provides an overview of order-level adjustments and discusses how to create an order-level adjustment.

Understanding Order-Level Adjustments

You use order repricing to reprice items based on order groups. The system uses information in each detail line of an order to determine items in an order group. For items that belong to the group, the system creates an adjustment for the order as a whole and creates a new order detail line with the amount of the adjustment.

You can use order-level repricing to add a line for freight costs. The weight, number, or some other variable of the items you enter determines the amount of the additional line item. The line the system adds is for freight costs.

When you enter an order using Sales Order Entry (P4210) for items in the order repricing group, the system applies the item base price with adjustments. To use the reprice adjustment, select the Reprice Order option from the Form menu on the Sales Order Detail Revisions form. Changes to the base price reflect the repricing adjustment. You can also apply the line item to order groups.

Form Used to Create an Order-Level Adjustment

Create an Order-Level Adjustment

Access the Price Adjustment Definition form.

Repricing Sales Orders

This section provides an overview of repricing sales orders and discusses how to apply basket- or order-level adjustments.

Understanding Sales Order Repricing

You can provide a discount for the customer by repricing sales orders. You reprice the order using one of these three methods:

• Reprice after inquiring on an order.

• Reprice at basket or order level.

• Reprice automatically.

Repricing After Inquiring On Order

After accepting the order and re-inquiring on the order, click Form and then Reprice Order.

Repricing at Basket or Order Level

You can evaluate a sales order and apply basket-level and order-level adjustments by running the Order and Basket Level Pricing program (R42750). The system writes basket adjustments to the Price Adjustment Ledger File table (F4074) and displays the information in the Price History program (P4074). A basket adjustment may produce free goods, which the system adds as a new detail line to the sales order. Order-level adjustments are not written to the F4074 table. The system adds an order-level adjustment as a new detail line to the sales order. Order level adjustments may create free goods, which the system adds to the sales order as a new detail line.

You can use the Reprice from Scratch processing option on the Process tab in the Order and Basket Level Pricing program to remove existing basket and order adjustments before recreating them. If you do not want to change or delete free goods when re-pricing from scratch, set the Preserve Free Goods processing option on the Process tab.

Reprice Automatically

After accepting the order and re-inquiring on the order, click Form and then Reprice Order.

Repricing Purchase Orders and Receipts

This section provides an overview of repricing purchase orders and receipts and discusses how to:

• Set processing options for Reprice Procurement/Receipts (R45620).

• Reprice purchase orders and receipts.

Understanding Repricing Purchase Orders and Receipts

Occasionally you might want to change your pricing and include those changes on a batch of purchase orders or receipts that you select. Using the Reprice Procurement/Receipts program (R45620), you can you change the base price or price adjustments and the system processes these price changes on purchase orders and receipts records. You choose a version of this program to indicate whether you want to process purchase order records, receipt records, or both. If a purchase order record or receipt record fails to update, the system creates an error message identifying the record and sends this message through the Workflow process. When you update prices on purchase orders, the system processes each line in the purchase orders and then saves only changes to the lines in the Purchase Order Detail File table (F4311). When you update prices on receipts, the system processes each line in the receipt and then saves only changes to the lines in the Purchase Order Receiver File table (F43121). Additionally, when the adjustment amount changes, the system updates the variances into the proper general ledger accounts. The system does not reprice purchase order lines that are:

• Closed

• Received

• Transfer Orders

• Direct Ship Orders

• Intercompany lines.

• Lump sum lines.

• A price override set, without the Apply on Override Price option set.

• A price override set and the Apply on Override Price option set without the Procurement Pricing on Override Price system constant set.

The system does not reprice receipt lines that are:

• Reversed.

• Matched to a voucher (partially or fully).

• Transfer orders

• Direct ship orders

• Intercompany orders

• Landed costs lines.

• Lump sum lines.

• Lines that are in receipt routing.

The report includes several features:

• A message indicating that the system did not reprice a line and the reason.

• Contract Code column if a Contract ID exists for any one of the purchase order or receipt lines.

• Harvest Name column if the JD Edwards Grower Management system is active and if a Harvest ID exists for any one of the purchase order or receipt lines.

• Totals by harvest block if the JD Edwards Grower Management system is active.

Using JD Edwards EnterpriseOne Advanced Pricing and Blend Management

If you use the JD Edwards Blend Management system, you can use the Reprice Procurement/Receipts program (R45620) to change the base prices on receipts. For example, you might make changes to a contract in the JD Edwards Grower Management system and apply those prices to all receipts that correspond to the contract. You might also add additional charges, such as hauling charges to an adjustment and apply those prices to all receipts.

You can run the Reprice Procurement/Receipts program (R45620) from the Contracts Detail program (P43C11). Only if purchase orders exist that correspond to the contract, can you click Reprice PO/Receipts on the Contract - Harvest form to run the Reprice Procurement/Receipts program.

You determine which version of the Reprice Procurement/Receipts program runs by setting the Reprice Purchase Orders/Receipts Batch (R45620) processing option on the Versions tab of the Search for Contracts program (P43C00) If you choose XJDE0001, only corresponding receipts reprice. If you choose XJDE0002, only corresponding purchase orders reprice. If you choose XJDE0003, corresponding purchase orders and receipts reprice. If you need to create a version of this program to suit your business needs, it is recommended that you copy only one of these versions.

See Managing Grower Contracts.

Setting Processing Options for Reprice Procurement/Receipts (R45620)

Use these processing options to control repricing of purchase orders and receipts.

Process

Although processing options are set up during EnterpriseOne implementation, you can change processing options each time you run a program.

Versions

Although processing options are set up during EnterpriseOne implementation, you can change processing options each time you run a program.

Print

Although processing options are set up during EnterpriseOne implementation, you can change processing options each time you run a program.

Repricing Purchase Orders and Receipts

Enter BV in the Fast Path.

Revising Adjustments

This section provides an overview of adjustment revisions, lists prerequisites, and discusses how to:

• Add adjustments during order entry.

• Change price level breaks during order entry.

• Review customer rebate information.

Understanding Adjustment Revisions

Adjustment revisions allow you to make additional adjustments and to revise adjustments to purchase and sales order adjustments.

You can add an adjustment that applies to the current order detail line. You might do this in response to a negotiated discount; you can create a manual adjustment for any amount.

During sales order entry, you can change the level of discount a customer receives for an order. The price-level change applies only to the current order.

Based on the rebate accrual adjustment definition, the system calculates rebates based on the total amount, quantity, or weight of multiple orders, which accumulate to a volume history file. During order entry, you can access the volume history file to provide additional information to the customer.

Pricing and availability of inventory items is crucial for placing a sales order. Use the Work with Price and Availability form to review pricing and availability of inventory items. Using this form, you can quickly review the price adjustments the system applied to an order line for a specific item.

You can also review the quantity breaks defined for an adjustment type or specify a different quantity break for the current order. To access the Adjustment Quantity Break form during sales order entry, access the form through the Work with Price and Availability form.

You can access the Check Price and Availability program (P4074) from the Sales Order Entry program. If you use Advanced Pricing, you must enter a version of Check Price and Availability in the processing options.

When making a change, you must also enter a code to provide a reason for the change.

Using JD Edwards EnterpriseOne Advanced Pricing and Procurement

For purchase orders, you can use Check Price and Availability to check price adjustments before entering a purchasing order. Use the Work with Price and Availability form to review pricing of inventory items. Using this form, you can quickly review the price adjustments the system applied to an order line for a specific item.

You can also review the quantity breaks defined for an adjustment type or specify a different quantity break for the current order. To access the Adjustment Quantity Break form during purchase order entry, access the form through the Work with Price and Availability form.

You can access the Check Price and Availability program from the Row menu in the Purchase Orders program (P4310).

Prerequisites

Before you complete the tasks in this section:

• Set the Advanced Sales (or Procurement) Pricing field to yes on the Pricing Constants form.

• Set processing options in the Sales Order Entry program (P4210) to display prices and enable price changes.

• Set up a sales order that contains price adjustments.

Forms Used to Revise Adjustments

Adding Adjustments During Order Entry

Access the Price History form.

Changing Price-Level Breaks During Order Entry

Access the Check Price and Availability form.

Reviewing Customer Rebate Information

Access the Rebate Volume History form.