Skip to main content
M
Manjunathak
Newcomer
September 15, 2023
Solved

Data copy to new expense account

  • September 15, 2023
  • 3 replies
  • 0 views

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.

Best answer by aricgresko

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.

3 replies

aricgresko
aricgreskoAnswer
Veteran
September 15, 2023

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.

    M
    ManjunathakAuthor
    Newcomer
    September 16, 2023

    This will fix the current problem, however still i am curious to know how we can copy by accounts.

    J
    OneStream Employee
    JackLacavaOneStream Employee
    OneStream Employee
    September 16, 2023

    A simple Custom Calculate rule. The https://amzn.to/3EHSd3J has a lot of examples.

      K
      Kamila
      Contributor
      September 18, 2023

      Best to use api.data.calculate()

      M
      matt515
      Newcomer
      September 18, 2023

      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

      Terms & ConditionsAccessibility statement