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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Run Separate Reports f...
Microsoft Dynamics GP (Archived)

Run Separate Reports for Different AR accounts?

(0) ShareShare
ReportReport
Posted on by Nikkie 110

We have a situation that involves using a few 'sets' of AR accounts (for example, Trade-AR and Other-AR) for invoicing purposes. When I run the AR Aged Historical Trial Balance report in the Sales module, GP automatically includes all AR accounts. Is there any way to restrict which group of AR accounts I want to print on a particular report, at any given time? Either Trade-AR or Other-AR?    

*This post is locked for comments

I have the same question (0)
  • Susan Pollard Profile Picture
    Susan Pollard 645 on at
    Re: Run Separate Reports for Different AR accounts?

    I'll be very interested to read about it if anyone has a different answer, but we had the same problem.  The only way we were able to have an aging with trade AR only was to have a custom report built.  If you do not need those "other AR" accounts aged and can keep up with the balances some other way you could set the 'category" to other current assets.     

  • Susan Pollard Profile Picture
    Susan Pollard 645 on at
    Re: Re: Run Separate Reports for Different AR accounts?

    In our case we had customers with balances in 2-3 different AR accounts, so I don't think that would work for us.

  • Nikkie Profile Picture
    Nikkie 110 on at
    Re: Re: Re: Re: Run Separate Reports for Different AR accounts?

    We have the same problem, Susan. Mariano can you assign one customer to multiple classes? How does that work?

  • Susan Pollard Profile Picture
    Susan Pollard 645 on at
    Re: Re: Re: Re: Run Separate Reports for Different AR accounts?

    I understand what you are saying about selecting customer class or user defined as a criteria when running the aged trial balance, but I'm only seeing an option for one customer class per customer. 

  • Nikkie Profile Picture
    Nikkie 110 on at
    Re: Re: Re: Re: Re: Re: Run Separate Reports for Different AR accounts?

    Ok. I didn't think so, just wanted to make sure I didn't miss something. That's the conclusion we came up with here in the office as well. I appreciate all the advice. Thanks!

  • Ray Nist Profile Picture
    Ray Nist on at
    Re: Re: Re: Re: Re: Re: Re: Run Separate Reports for Different AR accounts?

    How are you going to create this custom report?  I am running into the same issue with a customer as well.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans