cancel
Showing results for 
Search instead for 
Did you mean: 

Currency conversion Opening balance to be last month closing balance

bhagyesh_ravange
Active Participant
0 Kudos

Hi Expert,

I have requirement wherein currency translation for Equity and Investment Accounts periodic balance is required at average rate and Opening balance at prior month closing balance.

Regards

Bhagyesh Ravange

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member186338
Active Contributor
0 Kudos

In general for some set of accounts you can refine specific RATETYPE

For this specific RATETYPE you can define currency conversion rule.

In the rule you can define different conversion for each FLOW member.

You can have special rate for previous month in the rate model.

0 Kudos

Hi Bhagyesh,

Tag the Equity/Investment accounts with a Rate Type (new - to avoid confusion) or use a rate type that doesn't interfere with other Rate type requirements

If you run Carry forward rules to pull your opening balance,

Your Opening balance is already a copy of your closing balance of the last period of the FY. In the currency translation rule of the rate type defined for this accounts, define Opening flow with formula as "AS_IS", which will not translate your opening balance.

For the Incoming/Outgoing Units flow, define formula as "AVG" - Average

Hope this will help you to configure/solve your requirement. If you find it still not clear with the objective, comment with the detailed explanation based on periods (more detailed example)

Regards,

Harsha

bhagyesh_ravange
Active Participant
0 Kudos

Hi Harsha,

In the above Rollforward case currency translation will happen every month and opening balance will be prior month closing balance and not he prior period last month... so I guess AS_IS wont work.

Regards

Bhagyesh Ravange

bhagyesh_ravange
Active Participant
0 Kudos

Hi Vadim

2016.12 - 50

2017.01 - 51

2017.02 - 52

former_member186338
Active Contributor
0 Kudos

Not clear - try to provide some sample!