Reporting with Currency Precision
Most PeopleSoft SQR reports display the currency-controlled amounts to the number of decimals that are defined by the associated currency. For example, a Japanese yen amount appears on a report as 123 and a U.S. dollar amount appears as 123.23.
For reporting with BI Publisher and PS/nVision (Excel), the amount appears as a 2-decimal number. You have to modify the reports if you want to show 3 decimals on these reports.
Our third-party reporting tools don't fully support numeric fields that are greater than 15 digits. PS/nVision (Excel) uses an 8-byte float for numeric fields. This causes truncation after the fifteenth digit. BI Publisher displays up to 16 digits correctly; for numbers that are greater than 16, BI Publisher starts to insert nonsensical numbers into the decimal positions; however, this is a problem only with very large numbers. For any of these reporting tools, you should have accurate results up to the following amounts:
-
Hundreds of trillions of yen (or lira): Precision = 0
-
Trillions of dollars: Precision = 2
-
Hundreds of billions of dinar: Precision = 3
For example, if you enter 2s into a 15.3 numeric database amount field, the following third-party reporting tools will display the value as:
| Number of Digits | Reports | PS/nVision (Excel) | SQR |
|---|---|---|---|
|
16 |
2,222,222,222,222.222 |
2,222,222,222,222.220 |
2,222,222,222,222.222 |
|
17 |
22,222,222,222,222.219 |
22,222,222,222,222.200 |
22,222,222,222,222.220 |
|
18 |
222,222,222,222,222.188 |
222,222,222,222,222.000 |
222,222,222,222,222.200 |