| Purpose |
| Questions and Answers |
| Question 1: Can I enter manual journal entries in the Consolidation Ledger Type (AC)? |
| Question 2: How can I calculate Retained Earnings for the Consolidation Ledger Type (AC)? |
| Question 3: Why is R11414A report ending with PDFDocGen_Save error message in jde.log? |
| Question 4: Why is the translation adjustment account not absorbing the exchange rate differences which is causing the AC ledger to be out of balance? |
| Question 5: Is there any difference between the Translation Adjustment Account setup in header versus detail while setting up Computations (P1114)? |
| Question 6: Why R11414A clears the amounts for all future periods when run for a particular period? |
| Question 7: Post upgrade, Balance Restatement (R11414A) is producing a larger number of pages for a particular company. What could have changed? |
| Question 8: Why doesn't the beginning balance (APYC) of AC ledger gets updated for balance sheet accounts when running Balance Restatement R11414A for the First time and in YTD mode? |
| Question 9: Why is the Beg Balance/ PYE Forward (F0902 APYC) for AC ledger record for current fiscal year not populated, when run by a specific period? |
| Question 12: What triggers an asterisk to be shown in between the TO Current Period Balance and the Cur fields on the R11414A PDF? |
This document contains answers to some frequently asked questions on the Balance Restatement Method (R11414A).
Answer 1: Although the Compute Restated Balances program automatically creates Account Balance (F0902) entries for the consolidation ledger type (AC), you can manually enter journal entries as adjustments to the Account Ledger (F0911) table for ledger type AC on the Journal Entry form (P0911). For example:
Ensure the following, if you manually enter a journal entry for ledger type AC:
When you run the Compute Restated Balances program (R11414A), you can use the Check for Adjustments processing option under the Adjustment tab to specify whether you want the program to check for adjustments in the F0911 table. If you do not enter manual journal entries in the AC ledger or you choose to bypass them, you can save valuable processing time by setting this processing option accordingly.
You can rerun the Compute Restated Balances program for a period without losing the journal entries already entered for the AC ledger.
Answer 2: As part of year-end processing, you must calculate retained earnings for the consolidation ledger (AC), which is used for balance restatement.You should follow certain steps to ensure that the AC ledger is in balance and that the calculated amount for retained earnings is correct. During the currency restatement process, it is necessary to calculate retained earnings at a historical rate. By using the following method, the retained earnings for the restated ledger will always have a hybrid historical rate created by the Annual Close Program (R098201) instead of a manual calculation when it calculates retained earnings for the AC ledger.
The method is outlined as follows:
Answer 3:This error message can occur if the resulting pdf output file of a report reaches the size of 2GB. This is a limitation of Adobe Acrobat Reader, and there is nothing that can be done on the EnterpriseOne side to change this. To counter this, consider the following options:
For more information on this error message, refer to Document 640674.1 Receiving Error "UBE0000084 Error Function PDFDOCGEN_SAVE" When Running Report.
Answer 4: Using Account Ledger Inquiry application (P09200), verify that the user has not posted transactions against the Translation Adjustment Account. Just like the retained earnings account, the adjustment account should have a Posting Edit Code of 'M' and never have transactions posted directly to the account. The Adjustment account only receives balances in the AC ledger when R11414A restatement is run.
If transactions are posted to the adjustment account, it is common to see a situation where the first fiscal year will balance. However, after running the annual close for the AC ledger, advancing to the next fiscal year and restating new amounts, you will see that the adjustment account is not plugging for the exchange rate differences correctly, causing the AC ledger to be out of balance.
Answer 5: The Translation Adjustment Account setup in Revised Computations (P1114) works differently depending on whether it is entered into the header portion of the screen versus the detail.
In P1114 application, you can setup Translation Adjustment Accounts in both header and detail. Depending on the type of translation adjustment, you enter an account on the Revise Company Currency Conversions form (P1114) as follows:
| Translation Adjustment Header Account | Translation Adjustment Detail Account |
|---|---|
| The header account is used to create translation gain and loss amounts due to different rate types, for example, for average and month-end rate types. | The detail accounts are used to create translation gain and loss amounts due to a change in the exchange rate within a period. |
| The system creates a balancing entry in Account Balance (F0902) table, which is necessary because of different rate types. | This entry is used only for analysis and is not a balancing entry. |
| The system totals debits and credits, then updates this account with the difference. The amount for the balancing entry is a plug to force the restated consolidated ledger to balance. A single balancing entry is made for the entire computation. |
The system calculates this amount for each range of accounts that are assigned computation method 1 (cumulative balance). The system does not allow a translation adjustment account for computation method 0. For computation method 1, the translations gains and losses are calculated according to this formula: Translation adjustment amount = (prior period balance × prior period end rate) − (prior period balance × current period end rate) + (current period posting × current month average rate) − (current period posting × current month end rate) |
| Translation adjustment calculations that are used to create balancing entries are allowed only on balance sheet accounts. | It can be setup as any of the accounts in chart of accounts. |
For more information on Translation Adjustment Accounts setup and consideration, refer to Overview of Computations Balance Setup.
Answer 6: Balance Restatement (R11414A) report is designed to restate balances for the chosen period and clear all period amounts after the chosen one. For example, when running R11414A for period 10, it will reset amount balances to zero for period 11 (GBAN11) and period 12 (GBAN12) in Account Balances (F0902) table. Please refer to the Logic for Restatement section under the Program Functionality heading in Overview of Balance Restatement Method for more details.
Answer 7: You may like to check if there are any changes on how manufacturing and distribution transactions with subledgers are being processed. The change will create balances with detail subledgering. The increase of records in the F0902 will affect the amounts of records to be restated and the number of pages in the R11414A PDF will increase as well.
Answer 8: Please make sure currency restatement rate P1113 is setup for the last period of prior fiscal year. For example, you are running R11414A in FY 2014, you need to setup an exchange rate for Dec 2013 in order for system to compute the APYC balance for AC ledger.
Answer 9: When running restatement by period for a fiscal year over accounts that were not restated in prior fiscal years. The F0902 AC ledger record created for current fiscal year has a Beg Balance/ PYE Forward (F0902 APYC) of blank. But the report shows the "To" AC ledger Current Period Balance that includes a value that which is restatement of AA Beg Balance/ PYE Forward (F0902 APYC). The report makes it look like the F0902 APYC AC ledger is populated but it is not.
To resolve, run the R11414A restatement in YTD mode and when there is no existing AC ledger record for the fiscal year. Then the F0902 APYC of the AC ledger will be populated from the AA ledger.
Note: The periods in the AC record will be populated if there is a rate change and it will restate up to the current period setup for the company in P0010.
The Final Disposition in Bug 13924104 explains the process suggested by development:
The calculation done in YTD mode is the proper calculation for this process. As there is no AC ledger available to get the beginning balance, the YTD mode will calculate it based upon the AA ledger so that it is available for the period 1 calculation. The YTD mode will also ensure that the APYC value is updated properly in the newly created AC ledger record.
1. The MTD mode should only be used when a proper AC ledger record exists.
2. The standard process would be:
Since the restatement hasn't been run from the beginning for this company there will be an out of balance for the AC initially. This could be resolved by:
This is a business decision for not restating all years.
Answer 10: As the R11414A was run over the same AA ledger amount but with different exchange rates for the two months, the overall balance for the void will not be zero in the restatement ledger. The residual balance can be corrected with a journal entry directly to the restatement ledger if business needs require this.
Answer 11: Check the F0901 and F0902 table for Account ID (AID) congruity. If there are account balance records in the F0902 table where, for example, the AID value is 12345678 and the Business Unit (MCO) value is 1000, if the corresponding AID value 12345678 record in the chart of accounts F0901 table has a different MCO value than 1000, the R11414A process will write the restated AC ledger records using the information from the F0901 record. The result would be that some records could be written to accounts with business unit values that are not tied to the company in question. Normally this outcome could not possibly occur as any records in the F0902 table should have the same account ID, business unit, object, and subsidiary values as the corresponding F0901 records, so if it does occur, investigate whether erroneous changes to the values in the F0901 and/or F0902 records have been made.
Answer 12: This is triggered if there has been entries made directly to the associated account in the TO ledger. For example, if a journal entry was made to an account in the AC ledger then an asterisk would be shown if the R11414A is being run with the AC ledger as the TO ledger.