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

Notifications

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans