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.