Notifications
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 611 Most Valuable Professional
André Arnaud de Cal... 529 Super User 2025 Season 2
Sohaib Cheema 285 User Group Leader
