Posted On: March 27, 2019

Collaborate 19 Sneak Preview: Balance Restatement vs Detailed Restatement in JD Edwards Multi-Currency Functionality

Part I of our “Collaborate 19 Sneak Preview” post on JD Edwards Multi-Currency functionality dealt with activating Multi-Currency in JD Edwards EnterpiseOne and setting up monetary account valuation.

Part II looks at that all important question of when to use Balance Restatement and when to use Detailed Restatement when deploying JD Edwards Multi-Currency Functionality.

When to Use Balance Restatement When Deploying JD Edwards Multi-Currency Functionality

Global companies that have international subsidiaries which must maintain their financial books in a local/statutory currency that differs from the parent company’s currency will need to revalue those local books into the parent company’s books.

JD Edwards Balance Restatement functionality can handle this task, but there are challenges that users must resolve to do so effectively.

First, companies can re-run balance restatements as many times as they need to, although it is important to remember that each time this happens, it overrides previous balances.

Companies that need to maintain an equity account or various equity accounts pegged to some historical value will need to do so at the corresponding historical exchange rate. Likewise, they will need to monitor results whenever they re-class the system to calculate Retained Earnings to the historical Retained Earnings account.

For example, if in 2017 a parent company with headquarters in the U.S. made a capital injection in a company located in Canada when the exchange rate was 1.2, they will have entered that historical rate in the Balance Restatement tables. If in 2019, a second capital injection is made and the exchange rate at that time is 1.3, then the company will need to calculate the weighted average exchange rate and update the Balance Restatement tables accordingly.

When to Use Detailed Restatement When Deploying JD Edwards Multi-Currency Functionality

JD Edwards Detailed Restatement functionality is useful to companies in various scenarios.

First, it is useful to companies that must maintain their financial books in multiple currencies at the transaction level.

Second, Detailed Restatement functionality is useful to companies that need to maintain their fixed assets purchased in a foreign currency at a historical value, without revaluing it to current values. Balance Restatement functionally only partially addresses this requirement, so Detailed Restatement presents a valuable alternative.

This is particularly useful for multinational companies with subsidiaries in a high-inflation country. Without detailed restatement, the value of the non-monetary accounts, e.g. fixed assets or inventory, will continue to deteriorate when converted to the consolidation currency. With Detailed Restatement, if an asset in purchased in USD (for example) in a high-inflation country, the value of the asset will remain stable in USD throughout the life of that asset.

Finally, Detailed Restatement is useful to companies that want to maintain their inventory in more than one currency, although it should be noted that the JD Edwards Advanced Stock Valuation module is also needed.

Users should keep in mind that JD Edwards Detailed Restatement functionality does not provide a feature to calculate unrealized gains or losses in the detailed currency restatement. Along those lines, realized FX Gain/Loss calculation is only available for Accounts Payable and Accounts Receivable transactions, not for other General Ledger entries.

Also, maintaining perpetual inventory in a restated currency will require advanced stock valuation.

Finally, keep in mind that the process for overriding the historical exchange rate in a journal entry is cumbersome and error-prone.

Take a Deep Dive on JD Edwards Multi-Currency Functionality

If you’re interested in taking a deep dive on JD Edwards Multi-Currency functionality and will be in San Antonio, Texas for Collaborate 19, then make plans to attend “Multi-Company and Multi-Currency. Opportunities and Challenges within JD Edwards” on Wednesday April 10th at 2:00 pm in GH 2ND FL Lonestar Salon E.

If you’re unable to attend the session, you can stop by booth #643 to meet with our experts in person. Or you can pre-schedule a one-on-one meeting here.

If you’ve found this page after Collaborate 19, feel free to call us at 1-877-968-2948 or fill out our Contact Us from and we’ll be happy to set up a one-on-one meeting.