Tag: great plains

Steps to disable third-party products or temporarily disable additional products in Dynamics GP

| 06/10/2012 | 0 Comments

In the last couple of weeks I have seen a couple of GP consultants / advanced users try and disable products the long way, manually editing the dynamics.set file – Steps to disable third-party products or temporarily disable additional products in the Dynamics.set file in Microsoft Dynamics GP Although this works – there is a much easy way to do this! Use the Dictionary control window in Support debugging tool. I personally think, it takes letter time to install Support debugging tool, then to do this manually – plus you don’t have to worry about making mistakes.

Continue Reading

Canadian Payroll Midyear Tax Update has released.

| 06/05/2012 | 0 Comments

The Canadian Payroll 2012 Midyear tax update has released for Microsoft Dynamics GP 10 and 2010. The changes in this update include Ontario and Nova Scotia

Continue Reading

Dynamics GP SOP line items with serial numbers and comments

| 06/04/2012 | 0 Comments

Based on some reader requests, this new view is a combination of  my  All SOP Line Items view  and the recently posted script showing how to get a concatenated list of serial numbers in SQL .

Continue Reading

Table Links in Extender

| 05/31/2012 | 0 Comments

There are many times we see that a user removes a record from Microsoft Dynamics GP, but the Extender data is left in the database.  If a new record is creating that happens to have the same Key on it, the data then links to that new record.  Using the Table Links, it is possible to have the Extender data removed when the Microsoft Dynamics GP data it is linked to is removed as well. Linking an Extender Window to a table ensures that the Extender Window’s data is deleted when the corresponding Microsoft Dynamics GP table record is removed.   A window can be linked to more than one table. When linked to more than one table, the Extender Window data will only be deleted when there is not a corresponding record in any of the linked tables.

Continue Reading

SafePay Transactions Upload window does not populate in Microsoft Dynamics GP

| 05/29/2012 | 0 Comments

SafePay allows the customer to generate a list of checks and voids (from Payables Management and Payroll) that they can upload to the bank.  When a check is presented to the bank to be cashed, the bank will compare the amount and information on the check to the uploaded SafePay file, as a security and fraud prevention measure. In Microsoft Dynamics GP, the user can generate the upload file to send to the bank, if they have purchased SafePay.  However, we have received several support incidents where the SafePay Transactions Upload window is blank and does not populate in Microsoft Dynamics GP.  If it’s the user’s first time using SafePay, we often find they are not registered for the Bank Reconciliation module.   However, if the user has been using SafePay for some time, we usually find that the check has already been uploaded and it will not upload again. The check can only be uploaded once to the bank.

Continue Reading

Error Exporting to Excel from Business Portal 5.1 for Microsoft Dynamics GP 2010 in Internet Explorer 9

| 05/24/2012 | 0 Comments

If you’re using Business Portal 5.1 for Microsoft Dynamics GP 2010 along with Internet Explorer 9 and attempt to export the results of a query to Excel you may have received the following “Results not copied to Excel” error:   This generally happens when the result set you are exporting is large (~1000 records or greater).

Continue Reading

Concatenating strings in SQL Server

| 05/21/2012 | 0 Comments

This SQL Server tip comes from the April 2012 edition of the GP Reports Viewer newsletter. A request that we have seen many times when creating SOP invoices for Dynamics GP is to concatenate serial numbers.  So if there is an item with serial numbers, instead of showing a list with one serial number per line under the item, which would look a little unwieldy with long list of serial numbers: we want to show all the serial numbers on one line, separated by a comma.

Continue Reading