Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) How to link checks to ...

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

(0) Share

Report

Posted on by Community Member

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.

*This post is locked for comments

All responses (1)

Answers (0)

Victoria Yudin 22,768 on at

Like (0)

Report

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

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.