Skip to main content
June 9, 2025
Solved

Copy Prior Year Retained Earnings

  • June 9, 2025
  • 1 reply
  • 0 views

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?

It does not seem that our implementation partner set this up for us... therefore this account currently is just being imported from our ERPs at the start of the year. This is an issue for our few entities with foreign currency, as the balance continues to translate at the current month closing rate, which we do not want. 

Appreciate any insight! :-)

Best answer by BenEppel

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

1 reply

June 9, 2025

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.

BWHITAKERAuthor
June 9, 2025

Would you be willing to share your member formula?

BenEppelAnswer
June 9, 2025

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