DynamicAccounting.netYou, Me, and Dynamics GP

2023-10-06 · 2023

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

Payables & ReceivablesDevelopment & IntegrationSQL & Data

Archived post from 2023. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.

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.

Original article: https://www.azurecurve.co.uk/2023/10/sql-scripts-for-microsoft-dynamics-gp-set-vendor-on-hold-when-created/