Forum Discussion

BWHITAKER's avatar
BWHITAKER
New Contributor III
10 months ago
Solved

Copy Prior Year Retained Earnings

Anyone willing to share the process by which you copy prior year accumulated retained earnings to the current year? Is this just handled via data management steps, or do you need a business rule? I...
Consolidation
  • BenEppel's avatar
    BenEppel
    10 months ago

    api.data.calculate("A#PYRE:F#EndBal_Input = A#[accumulated retained earnings]:T#PovPriorYearM12:F#EndBal_Input")

chul's avatar
chul
Icon for OneStream Employee rankOneStream Employee
10 months ago

This is a standard member formula on your PYRE account. You'll mark it to use your application currency overrides to ensure that the translation uses the amount set on the override rather than translating per the rest of the balance sheet.

BWHITAKER's avatar
BWHITAKER
New Contributor III
10 months ago

Would you be willing to share your member formula?

  • BenEppel's avatar
    BenEppel
    Contributor
    10 months ago

    api.data.calculate("A#PYRE:F#EndBal_Input = A#[accumulated retained earnings]:T#PovPriorYearM12:F#EndBal_Input")

    • BWHITAKER's avatar
      BWHITAKER
      New Contributor III
      10 months ago

      Thank you for sharing this! Do you have a member formula then for [accumulated retained earnings] --- or how is this value derived?

      • BenEppel's avatar
        BenEppel
        Contributor
        10 months ago

        That represents a parent account, so the sum of CY and PY Retained Earnings. The formulas need to take into account if retained earnings data is being loaded from the ERP