This topic provides an overview of currency precisionand discusses how to:
Activate currency precision.
Maintain currency precision bycurrency.
Report with currency precision.
Understanding Currency Precision
According to the ISO standard, currency precisioncan range from zero decimals to three decimals. For example, USD amountshave two digits to the right of the decimal, and JPY have none. Tosupport this dynamic currency precision, the system delivers all ofits 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 displayand processing of such amount fields.
PeopleSoft applications round all currency-sensitiveamount fields to the currency precision of the controlled currencyduring all online or background processes. For example, in a databasethat contains amount fields with a length of 23.3, JPY are roundedto 123.000 and USD are rounded to 123.230. The system does not placea nonzero after the decimal for a JPY amount or after the second digitto the right of the decimal for a USD amount.
Although amount fields are stored in the databasewith decimal placeholders, the system displays amount fields withthe precision that is appropriate for the currency. For example, itdisplays JPY as 123 and USD as 123.23. When you enter an amount, youcannot enter more than the defined precision. If you attempt to doso, the system treats the entry as an online error.
PeopleCode programs and background processes roundall currency-sensitive amount fields to the currency precision ofthe controlled currency.
PeopleSoft-delivered ETL jobs move currency precisiondata from your source transaction system to EPM target warehouse tables.You need only use the currency precision PIA pages to redefine ormodify your existing currency precision data.
Related Links
Configuring Currency Precision for Currency Conversion
Activating Currency Precision
Currency precision is a PeopleSoft PeopleTools option.When it is selected using the PeopleTools Options page, all featuresof currency precision are activated. When the option is deselected,all amount fields behave as if no controlled currency exists. Thesystem displays amount fields as defined in the PeopleSoft ApplicationDesigner and rounds them to the number of decimals defined in theApplication Designer.
Note: If you deselect the multicurrency check box, thesystem only supports the default amount field size of 15.3—it doesnot support the larger amount field size of 23.3. After you deselectthis check box, selecting it again does not automatically round existingtransaction amounts.
Maintaining Currency Precision by Currency
Use the Currency Code page to access the currencycode table, in which you define the decimal position by currency.The values in this table are effective dated. The software is shippedwith the currency code table in compliance with ISO standards fordecimal positions. You can increase the number of decimals to a maximumof three.
Warning! Do not decreasethe number of decimals after transactions are entered in that currency;the system does not properly round the previously rounded amount fieldswith the new precision.
Related Links
Currency Code Page
Reporting with Currency Precision
Most PeopleSoft SQR reports display currency-controlledamounts with the number of decimal places that are defined by theassociated currency. For example, a JPY amount appears as 123 on areport, and a United USD amount appears as 123.23.
Amounts on PS/nVision (Microsoft Excel) reportsappear as two-decimal-place numbers. If you want to show three decimalplaces on these reports, you must configure the reports to do so.
Third-party reporting tools used by PeopleSoft donot fully support numeric fields greater than 15 digits. MicrosoftExcel uses an eight-byte float for numeric fields, which causes valuesto be truncated after the fifteenth digit.
For any of these reporting tools, the accuracy ofthe 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 databaseamount field with the number 2, the following table illustrates the number that is displayed ineach type of report.
Number of Digits | Excel | SQR |
---|---|---|
16 | 2,222,222,222,222.220 | 2,222,222,222,222.222 |
17 | 22,222,222,222,222.200 | 22,222,222,222,222.220 |
18 | 222,222,222,222,222.000 | 222,222,222,222,222.200 |