We are trying to close our books for Y/E with our external auditors and experiencing issues with FX revaluation.
When running the Revaluation process in NS OneWorld Release 2017.2 we are experiencing accounts with multiple currencies not re-valuating.
In running the process, we have the "Match Source Classification" box un-checked to pick up everything. Under this process we have some accounts picking up C/D/L and others that do not.
We tried running a second time with the "Match Source Classification" box checked with similar results.
Our requirements for the source transaction do not require C/D/L in any account that is re-valued.
Another question, does the Chart of Accounts (COA) play a role in this other than checking the re-valuation box? Do we have to specify Base Currency for the account to revalue? If the account in questions defaults to USD (default company base currency) and the account has USD, AUD, CAD for example will the revalue occur? Our results are varying. Even with the accounts where we have a Base Currency identified.
Curiosity has the best of us now as to why the process picks up some and not others? Is it something with our data or with NetSuite? Are we the only one's experiencing this are there other companies in the same situation?