Cannot Post Entries into ERP because of Rounding Issues - Support Advisory
Issue
Penny Rounding adjusting entries are being generated for the LT/ST Reclass entries. This is caused by an interaction between FX calculations and penny rounding because the reclassification and reversals occur in different fiscal periods. This is particularly an issue with evergreen deals since with no balance in the obligation, LT/ST Reclass entries are unnecessary.
Recommended Solution
Rounding issues are apparently being triggered by more than one underlying cause. Currently, the workaround is to review the rejected entries in Excel and manually correct the rounding errors, before reposting.
The following steps can be used to identify and appropriately handle the affected adjusting entries:
Run the Ledger Export report from the Integration tile.
When running the report, select None from the Include Adjusting Entries drop-down.
All other selections can be the same as usually selected.
Generate the Adjusting Entries Analysis Report for the same period as the Ledger Export.
Download our Adjusting Entries Analysis Report (AEAR) Pivot Template.
Use the macro in the AEAR pivot template to summarize the data and identify material adjusting entries that you wish to post, ignoring the status.
Exclude loose change/penny rounding and wash entries from the adjustments that need to be posted.
Determine a materiality level for your organization.
Using the Net (USD) column, determine which adjustments are material.
Manually transfer or post the material adjusting entries to your ERP.
Note: Suppression of Penny Rounding entries is targeted for 23R1.