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) / Accounts Payable Unpai...
Microsoft Dynamics GP (Archived)

Accounts Payable Unpaid invoices

(0) ShareShare
ReportReport
Posted on by JoAnn Schwerthofer 1,652

I want to print a report that shows only the unpaid invoices for a vendor - with Inv date, invoice #, amount due, and due date.  The aged trial balance is giving too much information - I don't want to see detail for invoices that don't have any balance due.  How do I get a report like this?

*This post is locked for comments

I have the same question (0)
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,619 Super User 2025 Season 2 on at
    Re: Accounts Payable Unpaid invoices

    JoAnn,

    Run the Historical Aged Trial Balance and under Report Options, make sure you Exclude 'Fully Paid Documents' and 'Zero Balance'.  That should clean up your Aging for you.

  • JoAnn Schwerthofer Profile Picture
    JoAnn Schwerthofer 1,652 on at
    Re: Re: Accounts Payable Unpaid invoices

    That still shows me all kinds of detail that I don't want to see - it is still showing me the aging breakdown - they only want the Vendor name, invoice date, invoice number, amount due, and due date to be on the report

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,619 Super User 2025 Season 2 on at
    Re: Re: Re: Accounts Payable Unpaid invoices

    Then you'll have to modify the report JoAnn or create a SmartList.

  • K Day Profile Picture
    K Day 7,365 on at
    Re: Re: Re: Re: Accounts Payable Unpaid invoices

    Smartlist is a good tool for this and even better if you have smartlist builder.  Under Smartlist, you can pick "Payables Transactions" (you can start with the * one) and if you filter the column"Current Trx Amount" where it is greater than 0.00, this should give you the current payables due.

    Even more than that, if you had Smartlist builder, you could create a column with a calculated field called "Aging Bucket" based on the due date and then use Smartlist Export Solutions to create a pivot table by vendor using the "Aging Bucket" as Columns and get a summary A/P report by vendor showing the different aging buckets.  This is a little more advanced than what I have described but it is possible once you get some more familiarity with Smartlist.

  • Vahe Profile Picture
    Vahe 40 on at
    Re: Re: Re: Re: Accounts Payable Unpaid invoices

    Hi K Day, I tried this method that you suggest but the results of the Smartlist did not match with the AP aging report I generated.  It appears as though your method will show invoices that have already been paid.  

  • KevinD Profile Picture
    KevinD 215 on at
    Re: Re: Re: Re: Accounts Payable Unpaid invoices

    Your filters on the Smartlist should be Current Transaction Amount is Greater than 0 and you will need to filter out voided ones?  Voided equals no or Void Status or something like that.  Once an invoice is paid in full, the Current Transaction amount goes to 0.00.  This should not give you any paid transactions.

  • Vahe Profile Picture
    Vahe 40 on at
    Re: Re: Re: Re: Accounts Payable Unpaid invoices

    I just talked to our AP person, the payments were posted but not applied to specific invoices, thus the total open invoices was not matching the vendor current balance. That explains it! You were right, thank you for your help!

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