Setting Up Currency Amount Fields When Developing Applications

To set up currency amount fields:

1. Access Application Designer.

2. Ensure that the record definition has an appropriate currency control field.

   The currency control field must be in the same record as the currency display field and hold a valid Currency Code value. This means that it must be a character (Char) field with a length of 3, formatted in uppercase (Upper). You can use an existing field or define a new field. The field does not need to be named CURRENCY_CD. It can have any valid PeopleSoft field name. However if the record has only one amount field, you should use the CURRENCY_CD field name for consistency with other PeopleSoft applications.

   An example of a record with two currency-controlled amount fields is the currency exchange (CURRENCY_EXCHNG) record. The two amount fields on this record are from amount (FROM_AMT) and converted amount (CONVERTED_AMT). Each has a currency control field of from currency (FROM_CUR) and to currency (TO_CUR), respectively.

3. Ensure that the edit properties of the currency control field are set up correctly.

4. Set the currency control field property of the currency amount record field.

   You must associate the field containing the amount with the currency control field.

   Open the Record Field Properties dialog box for the currency amount field by right-clicking the record field in the record definition and selecting Record Field Properties.

   In the Currency Control Field drop-down list box, select the appropriate currency control field for the currency amount field.

5. Click OK to accept the property settings.

6. Save the record definition.