Related topics
In this routine you can revalue G/L account balances in foreign currency at a given rate, and create G/L postings that reflect the revaluation. The revaluation concerns all balance accounts with Balance revaluation set to YES in the Account file, but is only relevant for the accounts that have currency balances in currencies that are different from the system currency. The system does not revalue A/R or A/P control account, since the Revalue A/R and A/P open items routine is used for that purpose.
You can also revalue consolidated values in this routine. All companies connected to the corporate company according to the company hierarchy table will be included. The new calculated values will be updated with the corporate company code as originating company code. To be able to report values separately per company before and after revaluation both an account part and an originating company code must be used in DC1 Report Writer and the Balance enquiry program in order to identify the originating company.
The automatic postings are created via the following pseudo accounts:
- A gain is posted via XRGxxxx.
- A loss is posted via XRLxxxx.
The user defined part of these pseudo accounts, xxxx, is based on the transaction currency code. If the specific accounts are not found, the defaults XRG and XRL are used. If these are not found, XERROR is used.
The contra entry of the gain/loss is the revaluation posting to the revalued account, which increases or decreases the system currency balance on the account.
If any exchange rates are in error, you will get an error report, and no update will be performed.
The selected accounts will be listed in transaction currency sequence and then in account combination sequence.
When the G/L postings are updated to the G/L, the following reports will be printed, under the following circumstances:
Selection
In the fields below, you make the selection for the balance revaluation.
- From account number
- Enter the “from” value in the range. If you leave a “from” field blank, the selection starts at the lowest value.
- To account number
- Enter the “to” value in the range. If you leave a “to” field blank, the selection ends at the highest value.
- Account number mask
- In each position of a field, you can enter a character which corresponds to the values you want to include in the selection. For example, 1____ in the main account part will include only those whose numbers start with a 1. You must complete the positions that are not used with underscore characters.
- Transaction currency
- Balance period
- The system will propose the actual period as balance period, which will also be the accounting period of the created G/L postings.
G/L balance account revaluation (FMR10102)
On this panel you specify which exchange rates to use for the revaluation, and whether to revalue gains and/or losses.
Specification
- Exchange rate period
- The default period code (the code for YEAR, MONTH, WEEK, or DAY) is retrieved from the G/L control file. The period value in the second field must be entered manually. For example, if you want the period to be April 2012, then enter the code for MONTH in the first field and 1204 in the second.
- Exchange rate level
- The default level code (the code for HIGH, MEDIUM OR LOW) is retrieved from the G/L control file.
- Revalue gains
- The default is YES, indicating that gains will be handled. However, it is optional, and you can set to NO if you do not want to include gains in the revaluation. If both Revalue gains and Revalue losses are NO, and there are exchange rates in error, then only an error report will be printed.
- Revalue losses
- The default is YES, indicating that losses will be handled. However, it is optional, and you can set to NO if you do not want to include losses in the revaluation. If both Revalue gains and Revalue losses are NO, and there are exchange rates in error, then only an error report will be printed.
- Simulation
- The default is YES, indicating that you do not want to run an update. Set to NO if you want an update instead.
You can run a simulation with printout of a control list to check the result of the selection and that all exchange rates exist. If you do not run a simulation, and if there are errors (missing exchange rates), the update will not be done. Instead, you will get an error list. If you want an update, there must be no missing exchange rates.
To make sure there are no missing exchange rates before you run a simulation or an update, set the Revalue gains and Revalue losses fields to NO. This way, you will only get an exchange rate error report.
- Elimination/Period
- The default is YES, indicating that an automatic elimination of the revaluation will be posted in the same journal. The default elimination period is the proposed balance period plus the number of relative elimination periods from the G/L control file.
If the balance period is a year-end period, outside the normal periods, as defined in the G/L control file, the elimination period proposed will be the same as would have been proposed for the last normal period. The elimination period must be the same as or later than the balance period. Also, it may be in another year, but this will create an additional journal, since journals may only hold transactions within one year.
- Voucher type
- You only have to enter a voucher type if Simulation is NO. The voucher type must be valid for the REVB routine. The voucher type controls the voucher numbering of the G/L postings created, and the voucher number series must exist for the year of the balance period and the year of the elimination period.