Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

MR Previous Year Ending Balance for just 1 row

(0) ShareShare
ReportReport
Posted on by 277

Does anyone know how to pull the previous year ending balance for just 1 row in MR? This is for a direct cash flow statement. It is a revenue account so the BB is zero. 

Thanks!

Categories:
  • Suggested answer
    RJarrell Profile Picture
    RJarrell 277 on at
    RE: MR Previous Year Ending Balance for just 1 row

    Yep, I was reading the report wrong so it turns out I don't need the previous years balance. I had been looking at this report for far too long.

    That being said, there is a way to pull previous year amounts into a row.

    You need to add a column for the previous year and set it to NP. You can then create a row that pulls through the amount. So something like the example below.

    Then you can use a calculated field  to pull the amount from the hidden column into the active column.

    Column Example:

    B                        C

    YTD -1              YTD

    NP

    Example:

    Line 500 - NP -  Set to account 70-6000

    Line 550 - CAL - C=B.500

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans