Announcements
No record found.
I'm trying to get a list of invoices that don't have a payment linked or associated to them.
I found a view from Victoria Yudin that creates a list of payments to an invoice.
victoriayudin.com/.../
Thanks
Greg
Hi Greg,
Dynamics GP does not have any special lists or scripts which pulls just a list of invoices that don't have just payments linked. Are you looking for invoices that just don't have payments applied or are you looking for invoices that does not have anything applied?
What you could look to do is pull data from the RM20101 where the document type is a 1 (Invoice) and compare the values in the original transaction amount (ORTRXAMT) to the current transaction amount (CURTRXAM) fields. If these are the same value, that would mean that nothing has been applied to the invoice. If they are different, then this invoice has some type of apply (credit, return, payment, writeoff, etc).
I will leave this forum open to the community in case someone has already created something that pulls the same information you are looking for and would like to share.
I hope this information helps.
Janelle
Dynamics GP Support
After I responded, I realized I forgot to include that the same information from the RM20101 table can also be found in the RM Unapplied Document report if you restrict it to just Sales/Invoices.
I hope this additional information helps.
Dynamics GP
This is great and it validates the view_Current_Receivables_Aging_Detail from Victoria I'm using.
Thank you
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 590 Super User 2026 Season 1
Giorgio Bonacorsi 349
Diego Mancassola 263
