Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Great Plains Duplicate...

Great Plains Duplicate Payments Audit - Historical Review for Potential Duplicate Payments

(0) Share

Report

Posted on by Community Member Microsoft Employee

Does anyone have any experience performing a duplicate payments audit in Great Plains? Essentially, I want to look back over the past year and see to what extent we may have issued duplicate payments. Keep in mind that I am NOT a GP expert by any means (I am actually work in the finance department, but was asked to review our historical payments for duplicate payments as an unbiased third party). If anyone has any suggestions about which tables to use and the best way to get the audit or review for duplicate payments done, it would be greatly appreciated!

Thanks.

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

26P2ER 1,773 on at

Like (0)

Report

RE: Great Plains Duplicate Payments Audit - Historical Review for Potential Duplicate Payments

Hello Chris-Finance

I would run a query similar to the below and work my way down with the vendor invoice number length in the de-dupe criteria.

select count(1),SUBSTRING(DOCNUMBR,1,20),VENDORID,DOCAMNT
FROM PM30200 WITH (NOLOCK)
WHERE VOIDED =0 AND DOCTYPE =1 AND
YEAR(DOCDATE) = 2016
GROUP BY SUBSTRING(DOCNUMBR,1,20),VENDORID,DOCAMNT
HAVING COUNT(1) > 1

This query is for the year 2016.
This assumes do not allow duplicate vendor invoice flag is checked under the payables setup window.

Hope this helps