Prospr Logo

Free SQL Scripts For Dynamics GP

Download these SQL Scripts for Dynamics GP. Direct from the masters of the GP community.

You have successfully subscribed

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


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.