SQL log files fill hard drive: how to fix. Dynamics GP Support

If you have a SQL server with a full hard drive there’s a pretty good chance that the drive was filled with SQL log files (.ldf files). You have to backup the Transaction logs before you can shrink the log file; the problem is that from SQL Management Studio you can typically only backup to … Read more

Dynamics GP upgrade fails – SQL server was renamed

If the computer holding your Dynamics GP SQL databases is renamed, this can lead to a number of problems including failed Dynamics GP upgrades. Internally, SQL server still thinks it’s name is ‘old-server-name’ instead of it’s new name of ‘new-server-name’ – this causes the upgrade to fail. Whenever a virtual SQL server is created from … Read more

Clear Recurring Batch Amounts in Dynamics GP

You can now clear the distribution amounts for all transactions on recurring batches after you post a batch. You can navigate through the distribution lines and enter new amounts for each period. Open the General Ledger Batches window (Financial>>Transactions>>Batches) Check the box next to Clear Recurring Amounts Select Save to save the change If you … Read more