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.
Is your comment
ReplyDelete"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."
to be read as "Line Item Display" setting does not impact the above explanation?
Many thanks for your clarifiation
ACan you explain how to undo the check box "only balances in local currency" for Open item managed accounts? I understand that this check box has no bearing on fgn currency valuation for OI managed accounts as Every OI line item is revalued. If you want to undo the check box, I understand that balance needs to be zeroed out but do we need to Zero out by transaction currency? Incase we do clearing on group currency there is balance in txn currency for cleared items as well. How do we go about zeroing out the acocunt?
ReplyDeleteYou may identify the current balance in transaction currency and group currency, then post a manual document where you can enter both transaction currency and group currency values. Ignore the automatically determined exchange rate and change the group currency value manually.
ReplyDeleteHello,
ReplyDeleteI would like to know if there is any way to get the balance on foreign currency for postings made in past, when GL account had the "Only balances in local crcy" flagged. This is the situation:
1st- the GL account master data was with "Only balances in local crcy" flagged. Some postings were made in foreign currency and therefore those amounts do not appear in FS10N (because the BSEG-PSWSL) the local currency was stored, not the document currency.
2nd- in the GL account master data, the "Only balances in local crcy" is set to blanks. Is there any possibity then to see the old postings (on foreign currency) in FS10N? Is there any refreshing/updating program?
Any hint will be really appreciated.
Thank you very much.