Sometimes when testing a new GP system, you need to assign items to vendors, and want to avoid having to do so on an individual basis. This script allows you to do just that. Add all items to all vend...
Sometimes batch totals are incorrect and batch headers can go missing. This script will create a stored procedure (Prospr_Reconcile_SOP_Batches) that will reconcile all batch totals, optionally delete...
There are times when, during posting, a batch gets stuck. This usually happens if there is a power fluctuation or an intermittent loss of network connectivity. The script checks the company databases ...
We’ve all been there! We meant to store the system password in a secure place just in case we forgot it, but that didn’t happen. And now we are locked out of all of the Dynamics GP system menus. What ...
If you have multiple companies and need to run a script against all of them, you would usually have to repeat the script execution for every company. However, with this command you can simply paste th...
Again, some spring cleaning tips. This script has 2 select statements that will show you historical sales documents where the customer no longer exists. The two delete statements will allow you to rem...
Are you fed up of always being asked how to print posting documents in Dynamics GP? This script will allow you to set one method for all reports. As is, it sets all reports t print to screen but you c...
