Invoice Payment Link

(0) Share

Report

Posted on by LightingSupply

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

Categories:

Microsoft Dynamics GP

All responses (3)

Answers (1)

LightingSupply 25 on at

Like (0)

Report

RE: Invoice Payment Link

Janelle

This is great and it validates the view_Current_Receivables_Aging_Detail from Victoria I'm using.

victoriayudin.com/.../

Thank you
Verified answer

JanelleM on at

Like (0)

Report

RE: Invoice Payment Link

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
Suggested answer

JanelleM on at

Like (0)

Report

RE: Invoice Payment Link

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