Reporting With Currency Precision

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:

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