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

- URL: https://dynamicaccounting.net/sql-scripts-for-microsoft-dynamics-gp-set-vendor-on-hold-when-created/
- Date: 2023-10-06
- Topics: Payables & Receivables, Development & Integration, SQL & Data
- Type: link to an external article
- Source: https://www.azurecurve.co.uk/2023/10/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 create](https://www.azurecurve.co.uk/2023/10/sql-scripts-for-microsoft-dynamics-gp-set-vendor-on-hold-when-created/)d 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.