Free SQL Scripts For Dynamics GP
Download these SQL Scripts for Dynamics GP. Direct from the masters of the GP community.
Features & Benefits
Tap into the knowledge of the community
You can download the most useful SQL scripts from the Dynamics GP community
Become your own support hero
No need to wait around for support calls to be resolved. Take matters into your own hands and proactively solve support queries.
The Best Dynamics GP SQL Scripts For You
We have scoured the web, gathered scripts from our partners and the GP Community to bring you some of the most useful SQL scripts for Dynamics GP.
(Credit to Mahmoud Alsaadi, David Musgrave and Mark Polino for the scripts)
Company Scripts
Send all posting docs to screen
Give all SQL objects DYNGRP access
Purchasing Scripts
Find payables transactions missing apply
Find duplicate payables transactions
Find POP purchase order duplicates
Find POP receipt duplicates
Financial Scripts
Find duplicate GL transactions
Inventory Scripts
Assign all items to all currencies
Duplicate a price level
Find duplicate inventory transactions
Mass assign all items to vendors
Sales Scripts
Auto age receivables
Clean your sales data
Find invoice duplicates
Find receivables duplicates
Find SOP duplicates
Reconcile SOP batches
Sales document housekeeping routines
System Scripts
Copy shortcuts between users
Release stuck batches without logging users out
Reset your system password
Run a script against all GP companies
What Our Customers Say About Us
Sihua Prior
PACE Gallery
Prospr were both very responsive and responsible. I am very pleased with the zero-stress experience with them. Thank you, Prospr!
Des Rogers
Eurofins
Prospr were very helpful and quickly helped me to setup SEPA payments for our companies in the UK. They dealt with my queries efficiently and were a pleasure to work with.
Want To Get In Touch?
We're happy to help. So if you have any queries feel free to drop us a line.