Understanding Price Adjustments in a Different Currency

You can create new price adjustments in a different currency for multiple records simultaneously by running the Advanced Price and Adjustment program (R407201). This program generates new price adjustments with or without an actual amount based on existing records.

The Advanced Price and Adjustment program is especially useful if you must create multiple price adjustment records in a different currency. For example, you might use this program if you are about to conduct business with a customer that uses a currency in which you do not have price adjustment records. To create a price adjustment for an individual record, simply update the existing record on the Advanced Price Adjustment Details Revisions form; you do not have to run this program.

The Advanced Price and Adjustment program:

  • Creates new price adjustment records one currency at a time to avoid confusion about which currency the new records are based on.

  • Creates only one new price adjustment record for each unit of measure; it does not create one price record for each currency.

    For example, the program generates new price adjustment records in the Japanese yen (JPY) based on existing prices in the Canadian dollar (CAD). If an existing record has a price adjustment in JPY, the program does not generate another record in JPY because both records would have the same key. The exception to this rule is when currency codes associated with a record have different effective through dates. Depending on the dates, the program might create multiple new price adjustment record.

  • Sequences the new price adjustment records alphabetically along with the existing records.