Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

AP Reports Needed

(0) ShareShare
ReportReport
Posted on by 30

Is there a quick and easy way to pull a report in GP Smartlists for all invoices that were outstanding as of 12/31/13 that were paid in 2014? Having trouble with what columns i am needing in a report.

*This post is locked for comments

  • Verified answer
    L Vail Profile Picture
    65,271 on at
    RE: AP Reports Needed

    Hi Kimz,

    A very simple SmartList would look for invoices dated before 01/01/2014 that had a date paid off in 2014.

    If it was paid off in 2014, then it was outstanding on 12/31/2013.

    You would need to use the Payables Transactions object. Is this what you were looking for?

    Kind regards,

    Leslie

    I created a blog post regarding all of the date fields in some of the A/P tables that might interest you:

    dynamicsconfessions.blogspot.com/.../whats-in-date-pm-transactions.html

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans