Dynamics Community Forum Thread Details

How to link checks to related credit memos and invoices that have been cleared by those credit memos

We are using beginning to use Docuware for our payables invoice and check paperless storage. We are using the Check Number to link invoices and their respective checks; however, this does not work for credit memos and invoices that were paid by credit memos.

Ultimately, I would like to be able to link a check with all its associated items, including credit memos and any invoices that have been cleared by those credit memos. How can I do this?

Thanks for any help you can offer.

Rachel,

The problem you will run into is that GP (at least in the versions through GP 2010) does not associate credit memos with checks. Credit memos are only associated with invoices in your example. Even though the credit memos may have been applied at the same time as the checks were created and even though the credit memos may have printed on the check stub, there is no permanent link between the credit memos and checks that you can use.

It if is enough to associate the credit memos with the invoices, then you can do that by using the apply information stored in GP. What do you need to help you with this? The tables? Something else? I have a SQL view posted on my blog that will give you a list of all credit memos, payment and returns applied to invoices: victoriayudin.com/.../sql-view-ap-apply-in-gp.

Quick Links