SQL Scripts for Microsoft Dynamics GP: Set Vendor On Hold When Created

Kudos to Ian Grieve for his post with a SQL script to set vendors on hold when created in GP. This is a great way to ensure that any tax-related info is collected prior to releasing payment to a vendor. Once payment is made, all leverage is lost.

Limiting who can release the hold along with GP’s Vendor Approval workflow can be important tools to minimize the risk of vendor fraud.