Business News
Syndicate
Home arrow Sun Documentation arrow General Ledger arrow Multi Currency Setup
Multi Currency Setup PDF Print E-mail
User Rating: / 0
PoorBest 
Sun Documentation - General Ledger
Article Index
Multi Currency Setup
Page 2
Page 3
Page 4
Page 5
Page 6
Page 7
Page 8
Page 9
Page 10
Page 11
Page 12
Page 13
Page 14
Page 15
Page 16
Page 17
Triangulation Model
  • From the Navigation pane, select General Ledger Entries
  • From the Forms pane, select Ledger Entry – Dual Base, Creditor/Debtor + Assets 
Click here to see the screenshot
The Triangulation Model Business Unit Setup was defined with Value 1 as GBP, Value 2 Transaction currency (in the above example we have used USD) and Value 3 as Second Base currency.  Value 3 Second Base has been defined as the pivot currency.
As Value’s 1 and 3 are fixed single-code values (i.e. they are defined within the Business Unit Setup form) the Currency Code fields are displayed greyed out here to prevent operators entering a different currency code.  Also as Value 3 is Second Base and pivot, both Base and Second Base rate fields are greyed out.
The posting rule defined for Value 3 Second Base currency is 4-Always Calculated.  As you can see from the Journal line above, the Second Base currency EUR has the amount field greyed out to prevent entry of a value.
Ledger Entry has performed the calculations as follows, converting the Transaction currency USD to the pivot currency EUR, then to the Base currency GBP.
200,000 USD converted to EUR via the EUR to USD rate –
            200,000 / 1.144      =  174,824.17
 This intermediate, or pivot, value has been converted to GBP via the EUR to GBP rate –
            174,824.17 / 1.44237704 = 121,206.29.


New Forum Topics
Latest Articles
 
 
Popular Articles
Poll
Apart from Sun do you use other Infor products?
Yes, we use these Infor products:
Place your ads here: