|
|
Business planning and Consolidation performs various business features including audit, business technique flows, finance statements and reporting, and work status.
Various built in functions are provided to carry out these functions.
Currency conversion is needed if your monetary figures are present in more than one currency to your application set. If app set contains monetary figures in single currency, if so you don’t want a rate application, currency time dimensions, etc.
If maximum of your information is entered in a single currency and you have only few figures in other currency, this will be handled by developing replica individuals in entity dimension. In this case, you may replica few entities present in foreign operations to split local currency from translated amounts.
Example − the us company generally deals inside the US but additionally has few subsidiaries functioning in different countries like Canada and Mexico.
There need to be rate application where you save the alternate rates. You must have an account size, which includes RATETYPE. Then Entity size should include a property currency. FXTRANS logic must be available and DEFAULT logic have to include a name to FXTRANS logic. Entity dimension should include the property TRANSALATE_TO.
There need to be rate application wherein you save the alternate rates. application must include a currency kind dimension. There need to be assets REPORTING for the currency dimension. Entity dimension need to consist of the assets currency. Account size have to consist of assets RATETYPE. FXTRANS logic should be to be had. DEFAULT logic need to include a name to FXTRANS logic.
All valid rate types corresponds to an account of rate application and belongs to organization FX rate. If there may be any account which isn't part of this organization, it will be increased by means of a issue 1. you can also outline a unique case NOTRANS, which results in an account being ignored during the translation.
Cross-rate translation consists of multiplying the amount in local currency through ratio between the rate of destination currency and the rate of source currency. the use of this, utility can use best one table of rates for translating any supply currency to destination currency.
You can also define the following default translations the use of business rules −
To perform currency conversion and intercompany eliminations, you want a dimension type - Intercompany size (I). To execute intercompany removal, an utility need to have the following −
Dimension |
Property |
Length |
Content |
Account |
ELIMACC |
20 |
Valid account |
Entity |
ELIM |
1 char |
It contains ‘Y’ or blank |
Intercompany |
Entity |
20 |
Entity Id w.r.t Intercompany member |
Currency |
Reporting |
1 |
‘Y’ or blank |
Default elimination logic performs the following functions −
|
|
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.