web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Unit account balances ...
Microsoft Dynamics GP (Archived)

Unit account balances rolled over at y/e

(0) ShareShare
ReportReport
Posted on by Community Member

Our unit accounts were not checked to "Clear Balance During Year-end Close".  Is there a way that we can easily clear these balances after the fact?  We have over 2,000 Unit accounts so I was hoping someone had an easy way to accomplish this.  Also hoping there would be able to upload the change to mark all of these accounts so they don't roll over next year.  

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    MattPaulen Profile Picture
    MattPaulen 6,912 on at

    See the following kb article for how to do this:

    support.microsoft.com/.../857582

    If you want to update ALL your unit accounts to clear balances at YE close, you could run this:  UPDATE GL00100 SET Clear_Balance = 1 WHERE ACCTTYPE = 2

  • Community Member Profile Picture
    Community Member on at

    Thank you for the quick response.  I did find the above article, however we have already closed our y/e so the balances have already rolled forward.  I am trying to find a way to either roll back the beginning balances or zero them out at the beginning of the year.

  • Suggested answer
    MattPaulen Profile Picture
    MattPaulen 6,912 on at

    The article I linked is for when the balances have already rolled forwared.  It will clear out those beginning balances.  The first script is for clearing out any in Open years (which since you just closed yours, the beginning balances would be in 2016 and those are what need to be cleared out), the second is for if you want to clear out balances from historical years.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans