Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Cash Balances

Posted on by Microsoft Employee

Good Afternoon,

Does anyone know whether the Cash Balance on the Management Reporter Balance sheet should show the "net change" in cash or whether it should show the actual cash balance.

Thank you

Betsy Cade Pape

*This post is locked for comments

  • MattPaulen Profile Picture
    MattPaulen 6,910 on at
    RE: Cash Balances

    How the balances are displayed should be controlled in the Column Layout.  When you have your report definition open, you can see the different building blocks listed for the report (row, column, and possibly tree).  If you click the icon next to the column, this will open up the column.  It's the Period Covered option for the the particular column that controls what balance is brought in.  You should see Periodic or YTD (there's others as well but not used near as much).

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cash Balances

    Matt

    Thank you.

    Our Management Reporter was set up for us.  I'm wondering if I can change it so the month I'm reviewing shows the actual balance.

    The first month of our fiscal year was August, and the Year to Date Balance is different than the August Balance. In the first month of the year, it would make sense to have it show the same balance as year to date.

    Thanks

  • Suggested answer
    MattPaulen Profile Picture
    MattPaulen 6,910 on at
    RE: Cash Balances

    From my experience the majority of balance sheets that I've seen are YTD balances.  I'm not sure if there is really a right or a wrong, it depends on what you want to see.  But if you are showing the cash the one way, then the rest of the report should be the same that way the report will balance.

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

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans