Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

MR Previous Year Ending Balance for just 1 row

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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,647 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans