14 Updating Prices

This chapter contains the following topics:

14.1 Updating Base Prices

This section provides an overview of base price updates and discusses how to:

  • Set processing options for the Base/Price Maintenance - Batch program (R41830).

  • Run the Base/Price Maintenance - Batch program.

14.1.1 Understanding Base Price Updates

After you define base prices, you can update them as needed, for example, to change a price or create a price that is effective on a future date. You can use the Base Price Revisions program (P4106) to update base prices individually, or you can run the Base/Price Maintenance - Batch program (R41830) to update multiple prices simultaneously. When you update multiple prices in batch mode, the system either overrides the existing price with a new price or calculates an adjustment to the existing price, depending on how you set the processing options for the Base/Price Maintenance - Batch program.

The system creates new prices based on the valid price that is selected by the batch program. When you run a version of Base/Price Maintenance - Batch in proof mode, the system generates a report that displays the updates that the program makes to the selected records when you run it in final mode.

When you set up a version of this program, you identify the specific fields for the system to select. For example, you can set up a version to select customer, customer group, item, or item group. Or you can exclude certain types of prices that you do not want to update.

Any new prices that the system creates are included in the report, and their effective dates and the old price that the system used as the basis for the new prices. You can run this program in proof mode as many times as necessary.

14.1.1.1 Change Existing Prices

To change multiple prices, you can run the base price revisions version of the Base/Price Maintenance - Batch program. Depending on how you set the processing options, the program either overrides the existing price with a new price that you specify or calculates an adjustment to the existing price. The adjustment can be an addition, a subtraction, a percentage adjustment, or an override amount.

When you run the base price revisions version in proof mode, the system generates a report that displays the updates that the program makes to the selected records when you run it in final mode. You must set the update processing option for this program to perform updates to the Item Base Price File table (F4106).

14.1.1.2 Create Future Prices

To create multiple base prices that you can use on a future date, you can run the future price additions version of the Base/Price Maintenance - Batch program. This version of the program writes new price records to the F4106 table that are based on the effective dates in the price additions processing option for this program. You must specify a from date and a through date or the program ends without creating the new prices.

When you run the future price additions version in proof mode, the system generates a report that displays the updates that the program makes to the selected records when you run it in final mode.

The system creates future prices based on the existing price with the greatest expiration date. Depending on how you set the processing options, the program either overrides the existing price with a new price that you specify or calculates an adjustment to the existing price. The adjustment can be an addition, subtraction, or percentage adjustment. If you leave the adjustment type and factor blank, the system copies future prices from the current price and does not apply any adjustments.

14.1.2 Setting Processing Options for the Base/Price Maintenance - Batch Program (R41830)

Use these processing options to control whether the system updates the Item Base Price File table (F4106), to specify price adjustments, and to specify whether new records are created or existing records are updated.

14.1.2.1 Update

This processing option determines whether the system updates the F4106 table.

1. Update Base Price File

Specify whether the system updates the F4106 table. Values are:

Blank: The system does not update the file.

1: The system updates the file.

14.1.2.2 Adjustments

These processing options specify the type and factor of a price adjustment.

1. Price Adjustment Type

Specify the type of adjustment that the system makes to the F4106 table. Values are:

A: Adjust the price by an amount.

%: Adjust the price by a percentage.

*: Adjust the price to an override price.

2. Amount

Specify an amount or percentage factor for the system to use to calculate the price. Use this processing option with the price adjustment type. For example, if you entered an adjustment type A, enter 10 to increase the price by 10 or –10 to decrease the price by 10. If you entered an adjustment type of percent (%), enter 10 to increase the price by 10 percent or –10 to decrease the price by 10 percent.

14.1.2.3 Date

These processing options control whether base prices are updated or whether new records are created.

1. Effective From Date and 2. Effective Thru Date

Specify the dates that the system uses for updating prices. If the effective from and through dates are entered, the system creates new base price records. If both of these processing options are left blank, the system updates existing base price records.

14.1.3 Running the Base/Price Maintenance - Batch Program

Select Price Management (G4222), Batch Base Price Revisions.

14.2 Updating Taxed Prices

This section provides an overview of taxed price updates and discusses how to:

  • Set processing options for the Sales Order Batch Tax Update report (R45650).

  • Run the Sales Order Batch Tax Update report.

14.2.1 Understanding Taxed Price Updates

If you use taxed prices you can access the Sales Order Batch Tax Update report (R45650) to update newly retrieved and calculated taxed prices and amounts in sales order lines that use taxed prices. Run this report if the internal tax date on a sales order line is not correct or the tax rate for the existing tax date has changed and the sales order must be updated to use the new tax rate.

Review the following considerations when running the Sales Order Batch Tax Update report:

  • The system does not retrieve the base price and apply the pricing adjustments on sales orders again. The system only applies tax to the sales order.

  • If a sales order does not have a taxed price override, then the system retains non-taxed prices and uses those values to calculate tax.

  • If a sales order has a taxed price override, then the system retains taxed prices and uses those values to calculate tax and non-taxed prices.

  • The report displays both old and new unit prices, extended prices, taxed unit prices, taxed extended prices, unit tax amounts and extended tax amounts in the domestic currency. The system does not display foreign amounts.

  • The system updates tax on sales orders that have kit or configurator component lines.

  • The system does not update tax on sales orders that do not use taxed prices, canceled orders, orders that were invoiced and orders on warehouse hold.

If you do not select the Sales Taxed Prices constant, the system displays an error on the report.

See Tax Information

14.2.2 Setting Processing Options for the Sales Order Batch Tax Update Report Program (R45650)

Use these processing options to control system processing and to specify versions.

14.2.2.1 Process

1. Date for Tax Calculation

Specify the date that the system uses to retrieve the tax rate for the sales order lines being processed.

If you leave this processing option blank, the system uses the value in the Tax Date field of the Sales Order Detail Tax table (F4211TX) for the sales order line.

14.2.2.2 Versions

1. Sales Order Entry (P4210)

Use this processing option to specify the version of Sales Order Entry program (P4210) that the system uses to update the sales order. If you leave this processing option blank, the system uses the ZJDE0001 version.

14.2.3 Running the Sales Order Batch Tax Update Report Program (R45650)

Select Price Management (G4222), Batch Update Sales Tax.

14.3 Updating Prices for a Customer

This section provides an overview of customer price updates and discusses how to:

  • Set processing options for the Sales Order Batch Price/Cost Update program (R42950).

  • Run the Sales Order Batch Price/Cost Update program.

14.3.1 Understanding Customer Price Updates

You update prices for a customer to recalculate sales orders based on the most current price or price adjustment. You might do this for items with volatile prices. You can also use this process to update the unit and extended costs of items on sales orders with the most current costs. If multicurrency processing is activated in the system, the system also updates the Foreign Unit and Extended Costs fields.

This table describes the tasks that use the Sales Order Batch Price/Cost Update program to:

Task Description
Update sales order costs. The system replaces the unit and extended costs in any open, unshipped orders with current costs from the Item Cost File table (F4105).
Update sales order prices. The system recalculates the unit and extended prices in the Sales Order Detail File table (F4211) by using the most current base price and price adjustments. The system bases this recalculation on the date that you enter in the processing options.
Replace sales order exchange rates. You can use this program to update the currency exchange rate that the system uses to calculate costs and prices on an order. The system replaces the currency exchange rate that was in effect at the time you entered the order with the existing currency exchange rate.

You can set the processing options for the Sales Order Batch Price/Cost Update program to define which date on the sales order the system uses to determine whether it should recalculate costs or prices. For example, you can base the recalculations on the promised date. Sales order prices can be updated more than once.

When you run the Sales Order Batch Price/Cost Update program, the system updates the order detail information for open sales orders. The system can either replace the current price in the order detail line with the new price or the system can add a nonstock line for the difference between the current price and the new price. You must specify a nonstock line type in the processing options for the system to add a line. If you do not specify a line type, the system overrides the original price with the new price.

After you run the Sales Order Batch Price/Cost Update program, you can review the report, which details the changes to the original unit price and extended price on each sales order.

Note:

You can set the processing options on the Sales Update program (R42800) or the Print Invoices program (R42565) to run the Sales Order Batch Price/Cost program before creating general ledger (GL) records. The system updates all selected sales orders with current costs (if orders have not been shipped), exchange rates, and prices before it creates general ledger records.

14.3.1.1 Taxed Prices

See Tax Information

If you use taxed prices and access the Sales Order Batch Price/Cost Update program (R42950), the system performs different tasks based on the setting in the Price processing option. If the system updates the sales order price, it also updates the tax and taxed price. If the system does not update the sales order price, then it does not update the tax and taxed price.

If you use taxed prices and set the Sales Order Batch Price/Cost Update program to update prices for sales orders with taxed prices (including exchange rate update and currency update), the system performs the following actions:

  • If you do not override the values in the Taxed Unit Price and the Taxed Extended Price fields, the system recalculates and updates the tax amounts and taxed prices based on the non-taxed prices using the current internal tax date from the sales order.

  • If you override the values in the Taxed Unit Price and the Taxed Extended Price fields on a sales order, the system retains the overridden domestic taxed prices and recalculate the domestic tax amounts and the domestic non-taxed prices based on the overridden taxed prices using the current internal tax date on the sales order. The system applies advanced pricing adjustments that do not affect the unit price, such as rebate adjustments.

  • If you override the values in the Foreign Taxed Unit Price and the Foreign Taxed Extended Price fields on a sales order, the system retains the overridden foreign taxed prices and recalculates the foreign tax amounts and the foreign non-taxed prices based on the overridden taxed prices using the current internal tax date from the sales order. The system also recalculates the domestic taxed prices, domestic non-taxed prices, and domestic tax amounts based on the foreign values. The system applies advanced pricing adjustments that do not affect the unit price, such as rebate adjustments.

  • The setting of the Update Price Change To New Line processing option specifies the line type of the new line with the price difference. The setting of the Taxable Y/N check box in the line being processed is passed to the new line with the price difference and this value overrides whether the line type is taxable.

    Therefore, either both lines on the sales order are taxable or not taxable.

  • The system modifies the header section of the report to display the new and old taxed unit price values and taxed extended price for sales orders that have taxed prices.

If you set the program to update prices for sales orders not using taxed prices or to update only non-price fields on sales orders, the Sales Order Batch Price/Cost Update program processes normally.

14.3.1.2 Record Reservation

The JD Edwards EnterpriseOne software provides record reservation capability within the Sales Order Batch Price/Cost Update program (R42950). Record reservation helps to ensure the integrity of the data and prevent data loss. To avoid simultaneous processing of the same records, the system reserves (locks) records for processing by any other program. Thus, the system does not allow you to edit a record that has been locked by a different user or application.

When a program that uses record reservation is interrupted, orphaned reservation records might remain in the Business Object Reservation table (F00095). This can occur, for example, when technicians are working with a server, or when a workstation shuts down without warning. If an interruption stops one of the programs in the Sales Order Batch Price/Cost Update program (R42950) before it releases the reservations that it creates, you cannot update the records until the orphaned reservations are removed.

You can use the Remove Business Object Reservation program (P00095) to release unwanted record reservations. This program stores reservation information in the Business Object Reservation table (F00095).

14.3.2 Setting Processing Options for the Sales Order Batch Price/Cost Update Program (R42950)

Use these processing options to control system processing and system updates, and to specify versions.

14.3.2.1 Process

These processing options specify whether to update costs, exchange rates, and intercompany exchange rates on sales orders.

1. Cost

Specify whether the system updates the cost on a sales order. The system updates a cost change to the original sales order entry line. Costs are updated only if inventory has not been relieved from inventory. Values are:

Blank: The system does not update cost.

1: The system updates the cost.

2. Exchange Rate

Specify whether the system updates the currency exchange rate. When the currency exchange rate is updated, only domestic prices and foreign costs are recalculated. Values are:

Blank: The system does not update the exchange rate.

1: The system updates the exchange rate.

3. Intercompany Exchange Rate

Specify whether the system updates the intercompany exchange rate. Values are:

Blank: The system does not update the intercompany exchange rate.

1: The system updates the intercompany exchange rate.

4. Exchange Rate Based on Date (Release 9.2 Update)

Specify whether the system updates the exchange rate based on the system date or the invoice date. Values are:

Blank: System Date.

1: Invoice Date.

If you set the value of this processing option to 1, the system uses the invoice date to calculate the exchange rate based on the following conditions:

  • If the Print Invoices program (R42565) is run along with the R42950 program, the system uses the invoice date defined in the R42565 processing option settings.

  • If the Sales Update program (R42800) is run along with the R42950 program and if the R42565 program was not run over the order prior to it, the system uses the invoice date defined in the R42800 processing option settings.

  • If the R42800 program is run along with the R42950 program and if the R42565 was already run over the order prior to it, the system uses the invoice date from the Sales Order Detail File table (F4211).

  • If you run the R42950 program individually, the system uses the invoice date from the F4211 table. If the invoice date is blank in the F4211 table, the system uses the system date as the invoice date.

Note:

To use this processing option, you must ensure that the value of the Exchange Rate processing option is set to 1.

14.3.2.2 Price Process

These processing options specify whether the system updates the price on a sales order, defines the effective date used to update prices, and retains the sales order price effective date.

1. Price

Specify whether the system updates the price on a sales order. You can update a price change to the original sales order line, or display it as a separate line by completing the Update Price Change To New Line processing option on the Display/Calculation tab. Values are:

Blank: Do not update the price.

1: Update the price.

2. Price Effective Date

Enter the date from the sales order that the system uses to update prices. Values are:

Blank: Transaction Date

1: Requested Ship Date

2: Promised Ship Date

3: Original Promised Date

4: Actual Ship Date

5: System Date

6: Invoice Date

*: System Constant

3. Retain Sales Order Price Effective Date

Specify whether the system retains the sales order's override price effective date or price effective date from the preference. Values are:

Blank: Use the Pricing Effective Date processing option to determine the price effective date.

1: Retain the price effective date on the sales order if the date was manually overridden by the user, or if the price effective date was determined through the sales price based on the date preference.

14.3.2.3 Display/Calculation

These processing options specify whether the system creates a new line and status for the price change, updates price based on the quantity or split quantity, and handles free goods on the original sales order.

1. Update Price Change To New Line

Specify whether the system creates a new line that details the extended price difference of a sales order line that has a price change. Values are:

Blank: Update change to the original sales order line.

Line Type: Update change to new sales order line using the specified line type.

2. New Line's Override Next Status

Specify a next status for the new order detail line. If you leave this processing option blank, the system uses the original detail-line next-status.

3. Price Based On Original Quantity

Specify whether the price is based on the original line quantity or the current line quantity. When a sales order detail line is split, the user can update the price of the split lines based on the quantity of the original detail line before it was split. For example, a sales order line is entered for a quantity of 10. The customer wants to ship two items to location A, and the other eight to location B. The original line is split into two sales order lines. Values are:

Blank: Update the price based on the current quantity.

1: Update price based on original quantity.

4. Preserve Free Goods

Specify whether the system preserves the existing free good promotion. Values are:

Blank: Cancel the existing free good promotion and include new free goods.

1: Preserve free goods on the order and reprice remaining. No free good processing occurs. Even new free goods are not awarded.

14.3.2.4 Versions

This processing option controls the version that the system uses when calling the Sales Order Entry program.

1. Sales Order Entry (P4210)

Select a version of the Sales Order Entry program that the system uses to update sales order price and costs.

14.3.3 Running the Sales Order Batch Price/Cost Update Program

Select Price Management (G4222), Batch Update Sale Price/Cost.

14.4 Converting Price Levels

This section provides an overview of price level conversions and discusses how to:

  • Set processing options for the Item Sales Price Level Conversion program (R41816).

  • Run the Item Sales Price Level Conversion program.

14.4.1 Understanding Price Level Conversions

You use the Item Sales Price Level Conversion program (R41816) to change the sales price level of an item or a group of items that you have previously entered in the Item Master table (F4101).

You can run this program in proof or final mode. You should always run the Item Sales Price Level Conversion program in proof mode first to identify errors. The program generates a report that displays any problems the system encounters during sales price level conversions. You can correct these errors before you run the program in final mode.

The Item Sales Price Level Conversion program deletes all price records at the previous level and creates new price records at the new level. For example, when converting from the item/branch/plant level to the item level, the program deletes all price records for each item/branch/plant and creates a new price record for the item.

You should not attempt to access the Item Master or Item Base Price File tables when this program is running in final mode.

Because this program is based on the F4101 file, you cannot search on a specific branch/plant.

14.4.2 Setting Processing Options for the Item Sales Price Level Conversion Program (R41816)

Use these processing options to control how the system processes data.

14.4.2.1 Process

These processing options control whether the system runs in proof or final mode, defines the price level that is being changed, prints an exception report, and deletes expired records.

1. Price Level

Specify the new price level to change the sales price level of an item or item group.

2. Branch to Default Price From

Specify the branch/plant from which the system takes the default price.

If the Price Level processing option is 1, enter the branch/plant from which the system retrieves a default price. If the Price Level processing option is 3, enter the branch/plant from which the system retrieves the default price based on the primary location.

Caution:

If moving the price level from Level 2 or 3 to Level 1, and the item exists in one or more branch/plants, but not in the branch/plant that is identified in this field, then the system displays the following message in the output file: Branch does not match Processing Opts. If the program is run in final mode, all of the F4106 records are deleted. The program functions by deleting existing base price records and replacing them with new records based on the from branch/plant that is identified in this processing option. If an item does not exist in the from branch/plant, no F4106 records are created for that item.
3. Proof or Final Mode

Specify whether the system runs in proof or final mode. Final mode updates the files. Values are:

Blank: Proof mode.

1: Final mode.

Note:

It is strongly recommended that you run this program in proof mode before running it in final mode.
4. Print Exceptions

Specify whether the system prints all records or only the exceptions on the report. Values are:

Blank: Print all items.

1: Print only exceptions.

5. Delete Expired Records

Specify whether the system deletes expired records or keeps them for history purposes. Values are:

Blank: Do not delete expired records.

1: Delete expired records.

14.4.3 Running the Item Sales Price Level Conversion Program

Select Sales Order Advanced & Technical Ops (G4231), Sales Price Level Conversion.

14.5 Generating New Base Prices in a Different Currency

This section provides an overview of new base prices in a different currency and discusses how to:

  • Set processing options for the Base Price Generation by Currency Program (R410601).

  • Generate new base price or currency.

14.5.1 Understanding New Base Prices in a Different Currency

You can create new base prices in a different currency for multiple records simultaneously by running the Generate Base Price/Currency program (R410601). This program generates new base prices based on existing records.

The Generate Base Price/Currency program is especially useful if you must create multiple base price records in a different currency. For example, use this program if the company is about to conduct business with a customer who uses a currency in which you do not have base price records. If you must create a new price for an individual record, update the existing record on the Base Price Revisions form. You do not have to run this program.

When you run the Generate Base Price/Currency program, use the processing options to control the currency and exchange rate in which the new base prices are created.

The Generate Base Price/Currency program copies the original base price record, calculates a new amount, and creates a price record with the new currency amount. More specifically, the program:

  • Creates only one new base price record for each unit of measure.

    It does not create a price record for a currency if the record exists. The exception to this rule is when currency codes that are associated with an item have different effective through dates. Depending on the dates, the program might create multiple price records.

  • Runs the Generate Base Price/Currency program first in proof mode, and then in final mode in the following way:

    • Proof

      Review the audit report to ensure that the records are accurate. If the audit report is not accurate, change the processing option and data selection values accordingly and rerun the program in proof mode.

    • Final

      When you are satisfied with the audit report that is created in proof mode, run the program in final mode. Review the new base price records on the audit report. You can also review new records on the Base Price Revisions form. Notice that the amounts are rounded according to the decimal places that are set up in the data dictionary for Unit Price (UPRC).

      If necessary, adjust the new base price records manually on the Base Price Revisions form. For example, if the program creates a new base price for 50,000 JPY as 675.1155 CAD, you might adjust the new amount to 675 CAD.

14.5.1.1 Example: Generating New Base Prices

This example describes an item with base price records before and after you generate a new base price in a different currency.

Before you generate new base prices, an existing item has these base price records:

Unit Price UoM Currency Code
1,000.00 EA USD
1,563.00 EA CAD
642.26 EA GBP

The processing options for the Generate Base Price/Currency program are set in the following way:

  • Run Modes

    • Mode = 1 (final)

    • Date = June 30

  • Currency

    • Convert to = EUR

    • Convert From = USD

    • Exchange rate = 1.02011

    • Method = 1 (multiplier)

Even though several currency amounts are associated with the item, the program generates only one new EUR amount based on the USD price.

The Generate Base Price/Currency program generates a new price record for 1,020.11 EUR, based on the 1,000.00 USD record. The original 1,000.00 USD record remains so that you can continue to invoice customers in that currency, as needed. The existing item has new base price records:

Unit Price UoM Currency Code
1,020.11 EA EUR
1,000.00 EA USD
1,563.00 EA CAD
642.26 EA GBP

After the system generates the new price record for 1,020.11 EUR, the program does not generate another price record for the item unless the expiration date of the existing price record is greater than or equal to the date that is entered in the processing option.

14.5.1.2 Data Selection for Generate Base Price/Currency Program

Typically, companies generate new base prices for all customers within a specific branch/plant. If the company has multiple branch/plants with different currencies, you can run the Generate Base Price/Currency program multiple times. For base prices that do not have a branch/plant, specify blank for branch/plant in the data selection.

14.5.2 Setting Processing Options for the Base Price Generation by Currency Program (R410601)

Use these processing options to control the processing mode and specify the currency data when running this program.

14.5.2.1 Run Modes

These processing options specify whether to run the program in proof or final mode and determine the date to use when the system generates new price records.

Proof or Final Mode

Specify whether the system runs in proof or final mode. An audit report is generated in both modes. Final mode updates the file. Values are:

Blank: Proof mode.

1: Final mode.

Price Record Date

Enter the date that the system uses to determine which price records to generate. If the expiration date of a price is greater than or equal to the date that is entered, a new price record is generated. Leave this processing option blank to use the system date.

14.5.2.2 Currency

These processing options specify the currency codes, currency conversion rate, and conversion method.

Currency Code To

Enter the currency code to convert to.

Currency Code From

Enter the currency code to convert from.

Currency Conversion Rate

Enter a number that represents an exchange rate. A foreign currency amount is multiplied by the exchange rate to calculate a domestic currency amount. The number in this field can have a maximum of seven decimal positions. If more are entered, the system adjusts to the nearest seven decimal positions.

Conversion Method

Specify whether the system multiplies or divides the current price by the currency conversion rate. Values are:

Blank: The system divides the current price by the currency conversion rate.

1: The system multiplies the current price by the currency conversion rate.

14.5.3 Generating New Base Price or Currency

Select Price Management (G4222), Generate Base Price/Currency.