Best way to this calculation
Hi - I know the below code is not a good practice but is there is an alternative way to set the data =0 because I want to clear all Origin Base member and UD2 base. Any help would be appreciated ?
...
Forum Discussion
Hi Henning - Thanks and Here you go.
A - Normal Account
B - USD Override Account
The above 2 accounts come through the file
1. When Account B has data then Copy the Data from B to A USD and A Local should not be cleared.
2. If the B has no data, then A should translate naturally.
Hi Kris, so you are attempting a standard translation override. Typically one uses the flow dimension for this, but I assume using an account to hold the override data is the result of the design session. There are - as always - several ways to go about it. Here is a simple example:
If (Not api.Entity.HasChildren() And api.Cons.IsForeignCurrencyForEntity) Then 'Execute on local entity and C#Ttranslated
If not api.Data.GetDataCell("A#B").CellStatus.IsNoData Then 'If B has data, clear A on Translated and copy from B
api.Data.ClearCalculatedData(False, True, False, "A#A") 'Set only Clear Translated Data to TRUE
api.Data.Calculate("A#A = A#B") 'Copy translation overrides from B to A
api.Data.Calculate("A#A = A#B") 'Copy translation overrides from B to A
End if
End if