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.