web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

No Duplicate AP Document Number, under any vendor or company

(0) ShareShare
ReportReport
Posted on by

Hi all

I have a fun request from the treasurer at my company.  She wants to make sure that no invoices are entered in twice by accident in AP.  We all know there's an option that exists for that already.  But she's worried about a vendor sending the invoice twice, perhaps with one of the invoices entered in through a different GP company (database), or perhaps even to a Vendor ID that sounds an awful lot like another one.  For example ABC Towing (ABC001) versus ABC Towing Services (ABC002).

I've fiddled with a few ideas, but haven't made much headway.  Has anyone else had a request like this, and if so, how did you tackle it??

Thanks!

*This post is locked for comments

I have the same question (0)
  • Tim Wappat Profile Picture
    5,713 on at

    Two ways jump to mind,

    1. Get a customisation implemented as an add-in for GP that checks on submission of that field that it is not a duplicate in your other companies, I doubt this would be very expensive.

    2. Use reporting to retrospectively monitor for duplicates. A scheduled report ran each day could check the previous day's transactions through a SQL query looking for duplicates, they could then be retrospectively dealt with, or run the report before you do payment runs if you run daily payment runs. 

    Tim

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans