09-15-2023
09:11 AM
- last edited on
09-16-2023
06:45 AM
by
JackLacava
I have created new expense account and i want the existing expense account historical data to be moved to new account. do we have any DM job for this.
Solved! Go to Solution.
09-15-2023 09:58 AM
Maybe take an alternative approach to this... rename the existing expense account to the name of the new account. Then, if you still need the existing (old) account with no data, recreate it. Note: this would require you to delete the newly created account before you rename the existing.
09-15-2023 09:58 AM
Maybe take an alternative approach to this... rename the existing expense account to the name of the new account. Then, if you still need the existing (old) account with no data, recreate it. Note: this would require you to delete the newly created account before you rename the existing.
09-16-2023 10:46 AM
This will fix the current problem, however still i am curious to know how we can copy by accounts.
09-16-2023 02:52 PM
A simple Custom Calculate rule. The OneStream Finance Rules and Calculations Handbook has a lot of examples.
09-26-2023 09:01 AM
just create a custom calc for this. and don't forget set the parametere for isdurablecalculated data to true
09-18-2023 04:38 AM
Best to use api.data.calculate()
09-18-2023 06:22 PM
api.data.calculate("A#Account2 = A#Account1")
The left side of the calculation is the destination and the right side of the formula is the source. The examples in the book show you can calculate something like A#Sales = A#Price * A#Volume