01-27-2023 11:01 AM
This was posted originally in 2019 and added to Office Hours in 2021. Please See below for follow-up question:
Question: Is it possible to have a historical override for a single account, but for multiple currencies? If I have an equity account which I would like to have a USD override amount, a GBP override amount, etc. On the Override account settings, I can only choose 1 currency. How can I resolve this?
Answer
If base entity and foreign currency then
If currency is EUR, then = Override_EUR
If currency is GBP, then = Override_GBP, etc…
End If
**********************************************************
Follow-up question
What specific properties need to be on the Closing Balance / EndBalInput (whatever) member? Having a formula on that member indicates not needing the “Translate using Alternate Input Currency, Input Local” flow processing type. This makes sense.
Multiple currency overrides are not very prevalent (at least in the last 3-4 years so a little rusty). I worked with a partner to help them get theirs set up – they ultimately had to enable the Flow Processing Type on the EndBalInput member using an All_Overrides member plus the formula.
In a new separate instance, the exact same formula (with different members) is not working either with or without the Flow Processing Type. Thinking it might just be a property – thoughts?
01-27-2023 07:26 PM
Answer: Translate Using Alternate Input Currency, Input Local is not needed on Closing Balance / EndBalInput member.