Understanding the Generation of Supplier Prices in an Alternate Currency
You can create new supplier prices in a different currency for multiple records at one time by running the Supplier/Catalog Purchase Price Generation by Currency program (R4106101). This program generates new prices based on existing records.
The Supplier/Catalog Purchase Price Generation by Currency program is especially useful if you need to create multiple supplier price records in a different currency. For example, you might use this program if the company is about to conduct business with a supplier that uses a currency in which you do not have supplier price records. If you need to create a new price for an individual record, simply update the existing record on the Supplier Catalog Revisions form; you do not have to run the Supplier/Catalog Purchase Price Generation by Currency program.
When you run the Supplier/Catalog Purchase Price Generation by Currency program, you control the currency and exchange rate in which to create new supplier prices by specifying this information in the processing options:
Date as of when you want to create records.
If the expiration date of a price is greater than or equal to this date, a new supplier price is created.
Currency of the existing records.
This is the original currency code that you want to base the new records on.
Currency in which you want to create new records.
Exchange rate to use to calculate the amount.
Method (divide or multiply) to use for the exchange rate calculation.
The Supplier/Catalog Purchase Price Generation by Currency program copies the original supplier price, calculates a new price, and creates a price record with the new currency amount. Specifically, the program:
Creates new prices one currency at a time to avoid confusion about which currency new records are based on.
Creates only one new supplier price record for each unit of measure. It does not create one price record for each currency.
For example, assume that the program generates new supplier prices in the Japanese yen (JPY) based on existing prices in the Canadian dollar. A record for a certain unit of measure already has a supplier price in JPY. The program does not generate another supplier price in JPY because both records for that unit of measure would have the same key. The exception to this rule is when currency codes that are associated with a supplier, item, or branch/plant have different effective through dates. Depending on the dates, the program might create more than one new price.
Run the Supplier/Catalog Purchase Price Generation by Currency program first in proof mode, and then in final mode as follows:
Proof.
Review the audit report to ensure that the records generated by the program 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 created in proof mode, run the program in final mode. Review the new supplier price records on the audit report. If you review a new record on the Supplier Catalog Revisions form, notice that the new record is sequenced alphabetically along with the existing records on the form and that amounts are rounded according to the decimal places that are set up in the data dictionary.
If necessary, adjust the new price manually on the Supplier Catalog Revisions form. For example, if the program creates a new price for 50,000 JPY as 675.1155 CAD, you might adjust the new amount to 675 CAD.