Configuring Currency Precision

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 Japanese yen (JPY) have none. To support this dynamic currency precision, PeopleSoft software delivers all 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. There is a control currency on the same record 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 round 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.

Currency precision is a PeopleTools option. When it is selected using the PeopleTools Options page, all the 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 (Set Up Financials/Supply Chain, Common Definitions, Currency, Currency Code) to access the currency code table, where you define the decimal position by currency. The values on this table are effective dated. PeopleSoft software contains the currency code table in compliance with ISO standards for decimal positions. As your specific business requirements dictate, you can increase the number of decimals to a maximum of three.

Most PeopleSoft SQR reports display currency-controlled amounts to the number of decimals that are defined by the associated currency. For example, the amount 123.23 for a JPY amount displays as 123 on a report, and a USD amount displays as 123.23.

Reporting with BI Publisher and PS/nVision (Microsoft Excel), the amount displays as a two-decimal number. If you want to show three decimals on these reports, you must configure the reports to do so.

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

For any of these reporting tools, you should have accurate results up to:

• 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: