Forum Discussion

OlaWidera's avatar
OlaWidera
New Contributor II
2 days ago

account is not translating

Good afternoon,

I need help with translating a balance account. We set it up to calculate job to date and load its local currency value, then I wanted to translate it using a job to date rate (also setup as the balance account).

The formula attached to the account is for every foreign base entity executes this:

api.Data.Calculate("A#JTD_COST:V#YTD:F#EndBalLoad:U8#None:C#USD = RemoveZeros(A#JTD_COST:V#YTD:F#EndBalLoad:U8#None:C#Local * A#JTD_FX_RATE:V#YTD:F#EndBalLoad:U8#None:C#Local)",,,,,"U1#Active.base")

 

The problem is that when I set the original account with  Formula Pass then I get an error during the consolidation suggesting the invalid destination data unit in script. When I don't attach any Formula Pass then nothing happens at all. 

Any suggestions what I miss or how else  balance accounts can be translated?

Thank you,

Ola 

 

 

Admin
Finance

1 Reply

  • JackLacava's avatar
    JackLacava
    Icon for OneStream Employee rankOneStream Employee
    2 days ago

    If you don't assign a Formula Pass, the formula is never executed. So you will have to set a Pass and then try to fix the error (look at the message details for clues? Or report them here...).