The following describes the process of updating amounts in reporting currency for historic transactions. When you start using the Reporting currency functionality all new transactions entered into the system will receive a value in reporting currency as well as transaction currency and system currency. You may then also want to be able to see values in reporting currency in the General Ledger for all historic transactions, i.e. transactions entered into the system before the Reporting currency routine was activated in the General Ledger.
For a company waiting to convert to the EUR, the system allows the EUR currency to be viewed as reporting currency before a system currency conversion, and the local currency as reporting currency after the actual conversion.
The following also describes how to attain reporting currency values for all historic transactions and balances. Note: Historic balances in reporting currency can only be created for accounting periods with transactions still residing in the system.
This routine calculates the reporting currency value for all transactions in the following two files:
- G/L transaction file (SROPST)
- G/L transaction log file (SROLOGGL)
- Rebuilds the balances from the transactions (ANOBAL)
Prerequisites
Before this routine is run the following must be completed:
- The Reporting currency application RCU must be activated and the reporting currency defined. See About working with reporting currency for further information on how to activate and start working with the Reporting currency functionality.
- A fixed exchange rate for the reporting currency must be entered in the Exchange rate table.
The amount in reporting currency is calculated from the amount in system currency by using the fixed exchange rate entered in the Exchange rate table (taking into consideration the value of Reversed rate defined in Work with companies).
Tip: This routine will re-calculate the reporting currency values for all transactions, i.e. not only transactions that are lacking information in these fields. This means that this routine can be used at any time when the reporting currency must be changed.
Enquiries and printouts
- G/L transaction enquiry – contains all the updated postings in the General Ledger. These amounts can be seen in system, reporting and transaction currency.
- G/L transaction details enquiry – contains detailed postings from the G/L transaction log file. These amounts can be seen in transaction, reporting and system currency.
- Balance enquiry – contains information on balances and budgets for accounts and summary identities, according to any of the user defined levels on which they are stored in the system. These amounts can also be seen in reporting amount.
- A/P transactions and balances – contains details and settlement information for all A/P transactions that have been entered. The remaining amounts can be seen in transaction, primary, system and reporting currency.
- A/R transactions and balances – contains details and settlement information for all A/R transactions that have been entered. The remaining amounts can be seen in transaction, primary, system and reporting currency.
- A/R portfolio accounting enquiry – contains details of the remaining amount as a transaction amount, system amount and reporting amount. This enquiry can be reached through the A/R portfolio enquiry.
- G/L list – displays all transactions in the General Ledger. The list can be printed in either transaction, system or reporting amount.
- G/L transaction list – displays details for the updated postings in the G/L.
- G/L transaction log file printout – displays G/L transactions on a detailed level. The printout will list amounts in reporting, system and transaction amount.
- A/P transaction list – displays details for all A/P transactions that have been entered. A number of sequence and selection parameters are available, to give you the list that is relevant for your needs. The remaining amounts can be seen in transaction, primary, system and reporting currency.
- A/R transaction list – displays details for all A/R transactions that have been entered. A number of sequence and selection parameters are available, to give you the list that is relevant for your needs. The remaining amounts can be seen in transaction, primary, system and reporting currency.