Currency conversion in Data Action generating new records

[amritagoswami]

Hi All,

I am working on a SAC Planning Model- New Model with multiple KFs. Currency conversion is enabled and exchange rate is maintained in the table.

Planner will enter the data in Local Currency, then a Data Action will be executed to convert the data to Group Currency.

I find that on executing the Data Action new records get created having the Amount in Group Currency populated, while the original record with Local currency remains unchanged and shows NULL in the column for Group Currency KF. Is there any way to ensure that the existing record is modified and no new record is created?

Thanks,

Amrita

[vivek_murthy]

Hi, did you find the solution to this problem, We are facing the same issue.

[sgodfree]

Amirta,

If you have some screenshots that would be great, but failing that I'd suggest you create a ticket with support.

Thanks,

Scott

[sgodfree]

Hi Amrita,

This generally should not happen unless you are prefacing this conversion with another operation. Do you have a report that hows this, or how do you know a second record is being created?

Thanks,

Scott

[amritagoswami]

This conversion is running in a standalone Data Action. I have checked the data in the model, where, after running the Conversion, new records get created with only the Group Currency KF populated. This will lead to a lot of data being generated, which will slow things down over time.