Ansicht
Dokumentation
RFGBEW00 - Flexible Valuation of Foreign Curr.Bank Accts at the Key Date
BAL_S_LOG - Application Log: Log header data Fill RESBD Structure from EBP Component StructureThis documentation is copyright by SAP AG.
Description
The program carries out a rolling revaluation of the foreign currency balances of those bank accounts not managed on an open item basis at a given key date and then displays the gains and losses from exchange rate differences. Any adjustment postings that are necessary are created in a batch input session.
Note that you can also valuate these accounts via program RFSBEW00 ("Valuation of G/L accounts managed in foreign currency"); this program, however, does not post any exchange rate gains or losses.
The accounts must fulfil the following conditions:
- In the account master record, the currency key field must contain the key for a foreign currency.
- The account is not managed on an open item basis.
- The account is not a reconciliation account.
Rolling revaluation can result in the upward revaluation or devaluation of an account balance. In the case of a revaluation, the difference resulting from valuation is positive. The program carries out a debit posting to the valuated account and a credit posting to the account for gains from exchange rate differences. In the case of a devaluation, the difference determined from the valuation is negative. The program carries out a credit posting to the valuated account and a debit posting to the account for losses from exchange rate differences.
The gains and losses incurred in the valuation period are displayed and posted to the period in which they occurred. Gains are offset on the debit side of the balance sheet account against the account for gains from exchange rate differences. Losses in an expense account are offset against the balance sheet account.
For each valuation run you must specify which valuation method will be used to valuate the accounts. The valuation method determines, among other things, the valuation procedure to be used (lowest value principle or the posting of every difference).
The program selects all the items from the account and sorts them by posting date and entry date.
The items are further broken down into:
- Foreign currency items (these are revaluated)
- Gain postings already made
- Loss postings already made
- Other valuation postings
Such a breakdown is necessary because if the balances are revaluated for the same period, the system
must take into account the postings already made. The program indicates the postings it has carried out in the reference document number and distinguishes them using this feature.
The rolling acquisition rate is calculated for every item with a foreign currency amount and the gain or loss resulting from this is displayed.
The gain or loss for a month is reduced by the gain and loss of the month already posted and this difference is then posted.
The foreign currency balance is valuated on the key date and the difference compared with the local currency balance calculated is displayed.
Requirements
The required valuation method is defined. Check whether this prerequisite has been fulfilled.
The accounts for the posting of exchange rate differences from the valuation are stored in the system. Please check whether this requirement has been fulfilled.
Output
If the line items are printed, the origin of the gain and loss as well as the valuation difference can be traced.
The gain or loss posted is displayed per item and monthly totals are formed.
The gain and loss per month already posted is printed after the valuated items.
Following this, the residual items of the month are listed. In this way the monthly balance in local currency and in foreign currency is available at the end of the month.
The foreign currency balance, the exchange rate used, the local currency balance valuated and the valuation difference are displayed on the key date.
The valuation takes place per G/L account although for reconciliation the business area totals are displayed since the postings are carried out at business area level.
The gain and loss and the valuation difference which have arisen are displayed at the end of the line item list per account, business area and month. This result is used for creating the postings.
The postings carried out are put into a log.
Example
Action Floating Forgn Crcy Local Crcy Gain/
Exch.Rate Balance Balance Loss
Purchase EUR 100 for 70 USD 0.70 100 70
Sale of EUR 50 at rate 0.60 0.65 50 40 (loss) -5.00
Valuated at key date 0.60 50 30
The expense resulting from the valuation (USD 3) is displayed but not posted.
( 35 - 38 = -3 )
The realized loss (-5) is posted to the valuated account and changes its balance.
After you have run this program, program RFBBEW00 runs, which valuates and posts the differences.
The valuations and postings are carried out by program RFBBEW00.
Vendor Master (General Section) General Data in Customer Master
This documentation is copyright by SAP AG.
Length: 5637 Date: 20240601 Time: 053141 sap01-206 ( 89 ms )
