Rounding and data display

  • If you create a new journal, amounts display on the grid exactly as specified (not rounded). The specified amount is rounded according to the application's rounding rules when the data is submitted to the database.
  • If you select an existing journal, the grid displays the rounded amounts that are stored in the database.
  • (Acquisition Journals Only) Translated currency amounts saved to the database are rounded according to the decimal setting of each currency. If there is no currency decimal setting, data is not rounded.
  • Local currency amounts saved to the database are rounded according to the first applicable decimal setting below:
    • Account decimal setting.
    • If none, then the local currency setting for the selected unit.
    • If none, then the SystemDecimalPrecision setting defined in the Sys_Params table.
    • If none, then two decimal precisions.
  • Only 15 digits total can be specified, including digits before and after the decimal place. If less than 15 digits display before the decimal but more than 15 digits are specified in total (before and after the decimal), the number is rounded such that the total number of digits does not exceed 15 digits.
  • The Audit reports include options to round the already rounded values that are stored in the database. For example, if you specify 100.9435 and submit the journal (using a decimal precision of 2), the number is stored as 100.94 in the database. If you select 0 as the precision for the Audit report, the number displays as 101. If you select 1, the number displays as 100.9. If you select 3, the number displays as 100.940.
  • Journal Entry and reports respect number formats specified in the workstation's regional settings when displaying data on the journal grid and in the reports.