Conversion and Reconciliation of Transaction Figures 
Use
Customer, vendor, and G/L account transaction figures are converted using general report programs.
Converting Transaction Figures
Update Currency
Make a note of the update currency of the G/L account (PSWSL) and the update amount (PSWBT) since this currency is used as a key in table GLT0. If the G/L account in question is managed as Balances in local currency only in the G/L account master record, the system converts the update currency Amounts are not changed for accounts managed in other ways.
Overflow During Conversion
If the quantity of data saved is too large, the fields in a data record can "overflow". If the system finds that this is the case during changeover, it includes the corresponding record in the log, and does not convert any of the fields in the data record.
To check the changeover process, you can compare the balance lists of the G/L accounts prior to and following changeover.
Reconciling Documents with Transaction Figures
Transaction Figures of Closed Fiscal Years
The system converts transaction figures in closed fiscal years, but does not reconcile them. Following changeover, documents and transaction figures for old fiscal years no longer need to agree.
Transaction Figures for the Current Fiscal Year
The system regenerates transaction figures for the current fiscal year (customer, vendor, and G/L accounts) from the figures in the converted documents, and posts differences arising. Reconciliation program RFEWA009 enters these differences in the corresponding documents in table RFDT and report program RFEWA010 reads this table and corrects these differences by making an additional entry in tables LFC1, LFC3, KNC1, KNC3, and GLT0.
Reconciling Open Items and Transaction Figures
The system reconciles open items with transaction figures as follows:
Reconciling Accounts Managed on an Open Item Basis with the Corresponding Ledger
For accounts managed on an open item basis, local currency changeover can lead to the total of all open items belonging to the old fiscal year differing from the balance carried forward amount for the current fiscal year. The account balance in the current fiscal year would then not agree with the total of the line items in this account.

Fiscal Year |
Debit (DEM) |
Credit (DEM) |
Debit (EUR) |
Credit (EUR) | |
2000 |
100 |
200 |
54.64 |
109.29 | |
2000 |
100 |
54.64 |
|||
Trans.figures (2000) |
200 |
200 |
109.29 |
109.29 | |
Open Items Total |
200 |
200 |
109.28 |
109.29 |
Report RFEWUC0F determines differences between the total of open items and the balance carried forward and adds them to the balance carried forward for this account. It carries out this adjustment for customer and vendor accounts, and for G/L accounts managed on an open item basis.
Reconciling Subledger Accounts with the General Ledger
For G/L reconciliation accounts, you manage the open items in the appropriate subledger (in the same way as for carry forward balances for accounts managed on an open item basis). The total of the line items in the subledger for the old fiscal year must agree with the balance carried forward of the reconciliation account in the current fiscal year. The system adds any difference amounts to the balance carried forward of the reconciliation account.
Report RFEWUC0O adjusts the balances carried forward on the basis of the subledger items.
Open Items Managed in Two Accounts
These accounts are processed during clearing transaction processing when reconciling the general ledger. The GR/IR clearing account is an example of such an account. For further information, refer to the documentation on the changeover procedure in Materials Management (MM).
Reconciling the Opening Balance Sheet
The system reconciles the opening balance as follows:
To ensure accurate G/L account transaction figures, all G/L account totals must balance out to zero, since if this is not the case the system cannot generate a correct balance sheet. Program RFEWA014 enters the adjustments to a G/L account in the balance carried forward field. This G/L account must be defined in Customizing and be created in the company codes potentially affected. (see also the IMG activity Preparation in Financial Accounting).
Once the transaction figures have been regenerated and the carry forward balances adjusted by means of the open items, these balances are then balanced out to zero by report RFEWA014. In so doing, this report treats the transaction figures as one large document.