• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Duplicate invoices

We are on E1 9.0, tools 8.89.42


Our AP dept is asking what standard JDE functionality is available to check for duplicate payments/vouchers. The only thing like that I am aware of is the AP constant that you can set to not allow duplicate vendor payments. That prevents you from entering a voucher where that vendor and invoice number combination already has been entered. There is a suspected duplicate payment report, but that only looks for the same thing, more than one voucher/payment that has the same vendor and invoice number.

What our AP dept is asking about is much more broad. Things like, for a vendor that typically gets paid once per year, they would want to know if a vendor had a second payment within a year, or if a vendor normally gets paid once a month, if they got a second payment within a particular month. Or anothe scenario such as a duplciate payment, where the invoice number is the same, but the vendor is different. Really, any kind of scenario that might indicate there was a duplicate payment of some kind.

Would appreciate any feedback on existing JDE functionality that would address something like this.