Configuring Currency Precision for Currency Conversion

According to the ISO standard, currency precision can range from zero decimals to three decimals. For example, USD amounts have two digits to the right of the decimal, and JPY have none. To support this dynamic currency precision, the system delivers all of its currency-sensitive amount fields with a standard length of 23.3, or 23 digits to the left of the decimal and three digits to the right. A control currency on the same record exists to control the display and processing of such amount fields.

PeopleSoft applications round all currency-sensitive amount fields to the currency precision of the controlled currency during all online or background processes. For example, in a database that contains amount fields with a length of 23.3, JPY are rounded to 123.000 and USD are rounded to 123.230. The system does not place a nonzero after the decimal for a JPY amount or after the second digit to the right of the decimal for a USD amount.

Although amount fields are stored in the database with decimal placeholders, the system displays amount fields with the precision that is appropriate for the currency. For example, it displays JPY as 123 and USD as 123.23. When you enter an amount, you cannot enter more than the defined precision. If you attempt to do so, the system treats the entry as an online error.

PeopleCode programs and background processes round all currency-sensitive amount fields to the currency precision of the controlled currency.

PeopleSoft-delivered ETL jobs move currency precision data from your source transaction system to EPM target warehouse tables. You need only use the currency precision PIA pages to redefine or modify your existing currency precision data.

Currency precision is a PeopleSoft PeopleTools option. When it is selected using the PeopleTools Options page, all features of currency precision are activated. When the option is deselected, all amount fields behave as if no controlled currency exists. The system displays amount fields as defined in the PeopleSoft Application Designer and rounds them to the number of decimals defined in the Application Designer.

Use the Currency Code page to access the currency code table, in which you define the decimal position by currency. The values in this table are effective dated. The software is shipped with the currency code table in compliance with ISO standards for decimal positions. You can increase the number of decimals to a maximum of three.

Most PeopleSoft SQR reports display currency-controlled amounts with the number of decimal places that are defined by the associated currency. For example, a JPY amount appears as 123 on a report, and a United USD amount appears as 123.23.

Amounts on PS/nVision (Microsoft Excel) reports appear as two-decimal-place numbers. If you want to show three decimal places on these reports, you must configure the reports to do so.

Third-party reporting tools used by PeopleSoft do not fully support numeric fields greater than 15 digits. Microsoft Excel uses an eight-byte float for numeric fields, which causes values to be truncated after the fifteenth digit.

For any of these reporting tools, the accuracy of the results is:

• Hundreds of trillions of yen (precision = 0).

• Trillions of dollars (precision = 2).

• Hundreds of billions of dinar (precision = 3).

For example, if you populate a 23.3 numeric database amount field with the number 2, the following table illustrates the number that is displayed in each type of report.