Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

How can i exclude zero balances from detailed trial balances for payables and receivables in gp

Posted on by Microsoft Employee

Hi everyone, 

I'm starting to use more ready made reports in GP and I'm trying to exclude zero balances from multiple reports.

Every time i run a ready-made detailed trial balance for a/p or receivables, the area to exclude zero balances is grayed out. I know i must be doing something small wrong...

Come someone help me get around this? 

Thanks!

Screenshot-_2800_394_2900_.png

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How can i exclude zero balances from detailed trial balances for payables and receivables in gp

    *event meant

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How can i exclude zero balances from detailed trial balances for payables and receivables in gp

    Wow Richard, we never it checked the drop down. Whoops!

    Thanks so much - Kim

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: How can i exclude zero balances from detailed trial balances for payables and receivables in gp

    I would never use Aged Trial Balance Report as it list every customer and vendor whether they have a balance or not. Use the Aged Trial Balance with Options Report instead.

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