25
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.
Thanks
Greg
Janelle
This is great and it validates the view_Current_Receivables_Aging_Detail from Victoria I'm using.
Thank you
Hi Greg,
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.
Janelle
Dynamics GP
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
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
