Some flows do not convert currency

[Former Member]

Experts,

I have encountered an issue where some of the flows will convert currency and others will not.  I have attached an example below ( the dimensions are in red font):

Any insight and/or guidance  is greatly appreciated.  I have reviewed the Flow dimension and I do not see a property that would exclude some flows while including others.  This is also true for other FLOWS like: F00 (opening).

Regards,

Greg

[Former Member]

Akos,

it is a ytd model.  Ok. I will make sure there are values.  Trying to capture difference between AVG and End for CTA purposes (IFRS Model). I will try change to see if it makes an impact.

Greg

[akos_beres]

Greg,

Sounds good, I was suggesting to change the type to test the calc and you can change it back. It also looks like the CTA balances are posting to the F80 flow based on the business rule. The rule there takes the difference between the closing and average rate.

Akos

[Former Member]

Akos,

Thank you for your quick response.

I have attached the following:

1. screenshot of the currency rule
2. screenshot of my Flow dimension  in 2 parts
3. screenshot of one of the properties for one the accounts in above example

Screenshot for1:

Screenshots for 2:

Screenshot for 3:

Thank you,

Greg

[akos_beres]

Greg,

Is your model YTD or periodic ... I assume YTD. Is your FX logic completes successfully without warnings?

Based on the screen shots, the FX logic applies a different condition to amounts with flow F15 (AVG) and F99 (END). F99 uses and end rate and F15 uses an average rate, Do you know if the average rate loaded is an average YTD rate or is a monthly average rate. If the later the periodic box should be checked in the business rule. Also make sure that there are rates and transaction for all of the subsequent month's.

One thing you can try is to test the logic by replacing AVG with END for the S_CONV_AVG rule in FX business rule. See if the logic converts the values or not. If the values are converted, the issue is with the prior balances because missing rates would result in an error.

Hope this helps,

Akos

[akos_beres]

Greg,

please check your FX business rules and see if there is a anything listed in the Source and Destination flow properties, as well as check if the force closing box is checked in the business rules. Alternatively you can just paste a scrennshot of the FX business rule and I can explain what's happening there.

Akos

[Former Member]

Akos,

I placed the requested information on the post.  Thanks for your help

Regards,

Greg

Akos,

Thanks for the quick response.  I am enclosing the item you requested as well as additional information that may prove useful.

1. Screenshot of the currency rule:

2.  Screenshot of my flow dimension in 2 parts:

Part 1:

Part 2:

Part 3:

Message was edited by: Greg Lakin

[former_member225135]

Hi Greg,

Just a guess, can you try removing the FLOW TYPE from "F_15" and re-run the currency conversion.

Regards,

Rahul