Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Clearing Accounts not posting to balance sheet

Posted on by 30

We have a payroll clearing account set up that is not appearing on the management report balance sheet that we have created. Any ideas on how to get the account to show up?  The account is set up a balance sheet account, the account # is 999999-999-999.  Is the issue due to all balance sheet account being ******-000-000 and the clearing account having *-999-999 at the end?

*This post is locked for comments

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Clearing Accounts not posting to balance sheet

    Accounts are retrieved on the Management Reporter either based on the Account Category or the Account Segments. In both cases, you should select a range to filter by a specific set of accounts.

    In your case, if the range that you have configured doesn't state (0000 to 9999), this clearing account will not be retrieved. When it comes to such account, I usually add it manually by considering the account segments as shown below:

    • Segment One: From 99 To 99
    • Segment Two: From 999 To 999
    • Segment Three: From 99999 To 99999
    • Segment Four: From 99 To 99

    Another method to make sure that this account will be retrieved on the Management Reporter level is to setup this account under a specific Account Category and specify this category on your row definition

    Your feedback is highly appreciated,

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans