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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / I would like to locate...
Microsoft Dynamics GP (Archived)

I would like to locate a voided items report, that allows me to select all voided items, including, invoices, payments received and check paid out....If this does not exist...I would like to know the tables which can be used to create this........Thanks

(0) ShareShare
ReportReport
Posted on by Winston Whyte 400

I have not been able to locate a report that details all voided items in GP, including invoices voided , payments received voided, checks  paid out voided. If this report does not already exist, I would like to know what tables I would need to create it.

 

Thanks...

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Mike Smith Profile Picture
    Mike Smith 6,840 on at

    Winston,

    You could easily use SmartList for this as the transaction tables have a Void Status field in them that could be used as a filter on these.

    Otherwise, you could access all of the transaction level tables for this.  You can access all this information from Microsoft Dynamics GP > Tools > Resource Descriptions > Tables.  

    If SmartLists will not work, respond back and I can assist with tables.

  • Verified answer
    Victoria Yudin Profile Picture
    Victoria Yudin 22,769 on at

    Winston,

    Mike is right, you should be able to do this with SmartList.  If you prefer to do it in SQL because you want more filters or additional logic, you could start with this view, which will give you all posted receivables transactions in GP: victoriayudin.com/.../sql-view-with-all-posted-receivables-transactions

  • Winston Whyte Profile Picture
    Winston Whyte 400 on at

    No, the smarlist will not work...We would like to create a report that is able to show all the voided items on one report.

    Thanks

  • Verified answer
    Mike Smith Profile Picture
    Mike Smith 6,840 on at

    Here's the tables you're looking for, this will have your transaction level information as well as void status:

    RM20101 --OPEN RECEIVABLES/AR

    RM30101 --HX RECEIVABLES/AR

    PM20000 --OPEN PAYABLES/AP

    PM30200 --HX PAYABLES/AP

  • Suggested answer
    Winston Whyte Profile Picture
    Winston Whyte 400 on at

    Thanks.. I will use these table to create the report. Really appreciate it...

  • Suggested answer
    Winston Whyte Profile Picture
    Winston Whyte 400 on at

    Thanks this answered my question perfectly.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans