Exchange Rate Based On Document Date for LIV Invoices

For LIV Invoices posted using MIRO transaction the exchange rate defaults based on the posting date, As there is no provision to change the translation date on the MIRO screen, it cannot be substituted with document date.


In order to post all invoices based on exchange rate at the document date instead of the exchange rate at the invoice date, the BADI FI_TRANS_DATE_DERIVE needs to be implemented according to the SAP Note #574583


Detailed steps to implement this BADI are :

1. Go to transaction SE18, enter implementation name as "FI_TRANS_DATE_DERIVE"  and click "Display"
2. Click Menu option, "Implementation" > "Create"
3. Enter an implementation name, for example "Z_BADI_FI_TRANS_DATE_DERIVE"
4. Add country codes where document date is required as translation date in "Attributes" tab
5. Go to "Interface" tab
6. Double click on "DERIVE_WWERT"
7. Activate the code
8. Go back to the previous screen and activate the implementation

The SAP note#574583 shows relevance only upto ECC 6.0, but it can be implemented with ECC 6.04 also. 

Information:Foreign Currency Valuation with Multiple Ledgers

Information: Foreign Currency Valuation with Multiple Ledger

The new Foreign currency valuation program. FAGL_FC_VALUATION uses the ledger group assigned to the valuation area to determine the ledger(s) from which balance is to be read for valuation. If the ledger group assigned to the valuation area contains only a single ledger, this ledger is used for the selection of the balances. If more than one ledger is contained in the ledger group assigned to the valuation area, each ledger is valuated individually

However, The postings for the valuation of balances are made using the ledger group that has the same name as the ledger being valuated. For example, if ledger group Z1 is assigned to the valuation area, which contains ledgers 0L and ledger L1, the balances of ledger 0L are valuated and the valuation program makes the postings using ledger group 0L and balances of ledger L1 are also valuated and the program makes postings with ledger group L1

In the above scenario, if ledger group L1 contain ledgers L1 and Z1, foreign currency valuation postings would be made to both the ledgers L1 and Z1 based on the balances in ledger L1

More details availble in the following SAP Note
983847 - Foreign Currency Valuation: Balances in NEW G/L

Information: Impact of GL master indicator "only balance in local currency" on Foreign Currency Valuation

Only Balance in Local Currency

Setting this indicator in GL master account affects the way account balances are stored in GL summary/totals tables. If this indicator is set, the GL balances are updated only in local currency to the GL totals tables. It does not affect the way data is stored in line items table BSEG or open & cleared items tables BSIS and BSAS respectively.

Impact on Foreign Currency Valuation
Foreign Currency valuation of GL accounts where the indicator "only balance in local crcy" is set is affected in the following manner depending upon the type of account

- Open Item managed accounts
If the account for which only balance in local currency is set, is an open item managed account, i.e: the indicator "Open Item Management" is also set in the GL account master. The foreign currency revaluation program would read the account details from tables BSEG and BSIS and hence the indicator "only balances in local crcy" has no impact on foreign currency valuation.

- Non Open-Item managed accounts (including accounts with line item display without open item management)
If the account for which only balance in local currency is set, is a non-open item managed account, i.e: the indicator "Open Item Management" is also not set in the GL account master. The foreign currency revaluation program would read the account details from GL summary tables FAGLFLEXT and hence no foreign currency valuation is possible on such accounts as balances in the GL totals tables are maintained only in local currencies for such GL accounts.

The above concept also applies to GL accounts which are line item manages but not open-item managed. i.e: the indicator "Line Item Display" is set but the indicator "Open Item Management" is not set.