Dynamics GP

SmartList Favorite Doesn't Return Data

One of my associates, Karen Henkelman, and I found an interesting issue in the GP web client. We had a PowerGP Online Partner open a case complaining that a just created SmartList Favorite wouldn’t return data. We tested it on a Desktop client (PowerGP Online is SAAS, web client only GP solution) and it worked fine. The name contained an apostrophe; “Audit List JL’S”. We removed the apostrophe and problem solved.

By | 2018-07-18T11:23:44+00:00 February 14th, 2018|Dynamics GP|

Tracking 1099 information after the fact in Microsoft Dynamics GP

So it’s time to prepare 1099’s once again. This video will show you how to edit the 1099 information for a Vendor in Microsoft Dynamics GP, after the invoice has been posted. See how to handle the following common scenarios!It’s not uncommon to find out a vendor SHOULD HAVE BEEN setup as a 1099 after you posted the transaction.It’s not uncommon to find out an invoice for a 1099 SHOULD NOT be included in their 1099 amount.  >Reposted with permission by Belinda Allen - www.BelindaTheGPcsi.com

By | 2018-07-18T19:26:04+00:00 January 13th, 2017|Dynamics GP|

When should you upgrade your software?

When should you upgrade your software?            In today’s business environment, we are surrounded by software that seems to be constantly changing. As a professional software developer, I spend the majority of my time working on software that I hope people will use as soon as possible. When releasing a new version of a product, I believe that the newest version is the best version for a customer to use. While the most recent version of the software might be technically best, that does not mean that your business should upgrade to it immediately. I have also spent the last few decades of my career in leadership positions within the businesses I have worked for and I know from experience that upgrades should be planned for times when it is appropriate for your business. I believe that any software you use in your business should be on a supported version of the product by [...]

By | 2018-07-18T11:23:44+00:00 October 13th, 2016|Dynamics GP|

How to fix a transaction for a future date in Dynamics GP

It is easy to make a mistake when entering the date on a transaction.  If you don’t catch it the transaction will not post and will be stuck in batch recovery. Open the Fiscal period for the year that is on the transaction. (Administration>>Setup>>Company>>Fiscal Periods. Recover the batch and post the transaction. Once it has posted you can either void the transaction or enter a credit memo.  If you issue a credit memo just be sure the date is the same as the original transaction date. Close the Fiscal period.Re-enter the transaction with the correct date.If you are familiar with SQL once you have opened the Fiscal period you can also:Create a credit memo for the same amount as the invoice, with the same accounts, so that the GL will be offset. Set the posting date to the same posting date as the invoiceApply the credit memo to the invoice.  This will offset the original [...]

By | 2018-07-18T19:23:40+00:00 May 31st, 2016|Dynamics GP|

After GP Company database restore: The selected company is not configured as a company of the current Microsoft Dynamics GP syst

After restoring a GP Company Database from another SQL server you may get the following error when trying to log into the restored company: "The selected company is not configured as a company of the current Microsoft Dynamics GP system database. You must resolve the database configuration to log in to the company" The following SQL scripts may resolve the issue. select CompanyDbId = c.CMPANYID ,DynamicsDbId = d.CMPANYID ,DynamicsDbName = d.INTERID ,DynamicsCompanyName = d.CMPNYNAM from sy00100 c left join dynamics..sy01500 d on d.interid = db_name() --update SY00100 set CMPANYID = (select CMPANYID from DYNAMICS..sy01500 where INTERID = db_name())

By | 2018-07-18T11:23:45+00:00 July 16th, 2015|Dynamics GP|

HTML code displayed on the bottom of a navigation list pane instead of returning actual results. GP 2013 and GP 2015.

This has been an issue that Njevity has been struggling with on new GP 2013 and GP 2015 installs. The confusing part has been that it will occasionally go away. With a lot of help from Daryl Anderson at Microsoft we finally found a work around. First of all, the issue goes away as soon as an application is installed that drops a DLL file in the AddIn folder of the GP program files. For cases where there are no DLL files in the AddIns folder simply copy the Microsoft.Dynamics.GP.BusinessIntelligence.Homepage.dll file from the root of the GP installation (example: c:Program Files (x86)Microsoft DynamicsGP2013) to the AddIns sub-folder.

By | 2018-07-18T11:23:45+00:00 May 22nd, 2015|Dynamics GP|

Give users access to SSRS Report Builder

To create role assignments that grant access to Report Builder Start Report Manager. Click Site Settings. Click Security. If a role assignment already exists for the user or group for which you want to configure Report Builder access, click Edit. Otherwise, click New Role Assignment. In Group or user, enter a Windows domain user or group account in this format: . If you are using forms authentication or custom security, specify the user or group account in the format that is correct for your deployment. Select System User, and then click OK. Click Home. Click the Properties tab. Click the Security tab. If a role assignment already exists for the user or group for which you want to configure Report Builder access, click Edit. Otherwise, click New Role Assignment. In Group or user, enter a Windows domain user or group account in this format: . If you are using forms [...]

By | 2018-07-18T11:23:45+00:00 May 20th, 2015|Dynamics GP|

Dynamics GP Excel Drillback. A connection Microsoft Dynamics GP could not be established. Be sure you are logged on to the appr

According to the following link : http://support.microsoft.com/en-us/kb/2966672 If you're moving your Microsoft Dynamics GP databases and you use the drilldown functionality in the SQL Server Reporting Services or Excel integrated reports, you need to follow the steps below in order to update your server links so the drilldowns will continue to work after the server move: 1. Ensure that everyone has logged out of Microsoft Dynamics GP and close all instances of SQL Server Management Studio. 2. On a machine where Dynamics GP is installed click on Start, then point to All Programs. Then click to expand Microsoft Dynamics, then GP and click on Database Maintenance. 3. When the utility opens select or enter the SQL Server instance name where the Dynamics GP databases are stored. If you are logged in as a domain account with rights to this SQL Server instance you can select the Windows Trusted Authentication method. [...]

By | 2018-07-18T11:23:45+00:00 April 6th, 2015|Dynamics GP|

GP 2013 and 2015 GP Web Services "Exception message: The security object does not exist"

After moving the GPWEBSECURITY database for GP Web Services and running a repair we received the following error opening the Security Console:"Exception message: The security object does not exist. Missing Key: 25cc1a21-2cc4-4b13-a1c8-eea186fb688a"Turns out we ran the wrong repair.  DO NOT run the repair from the GP Web Services Configuration Console.  Instead, launch the GP Setup.exe from the GP installation media.  This will detect the existing install and give you the option to repair.I used information from the following link and updated it for the new web services that does not run in IIS:https://support.microsoft.com/en-us/kb/943949To determine the scopes in the ADAM database, use the Authorization Manager (Azman.msc) Microsoft Management Console (MMC) snap-in to browse the database. To do this, follow these steps:Click Start, click Run, type azman.msc, and then click OK.On the Action menu, click Open Authorization Store.Click Active Directory.In Windows Explorer, open the following folder:C:Program FilesMicrosoft DynamicsGPWebServicesWebServicesUse Notepad to open the [...]

By | 2018-07-18T11:23:45+00:00 March 24th, 2015|Dynamics GP|

SSRS Report Builder "Application cannot be started, contact application vendor."

When trying to launch Report Builder you receive the error "Application cannot be started, contact application vendor." I did two things that seemed to of helpled. 1. Open SSMS and connect Server type "Reporting Services", Server name. Right Click the Server Name in Object Explorer and pick Properties. Under Advanced setting in the Reports section set the ReportBuilderLaunchURL to https://serverurl/ReportServer/Report/BuilderReportBuilder_3_0_0_0.appli.... 2. Create a Web.config file in the C:Program FilesMicrosoft SQL ServerMSRS11.instancenameReporting ServicesReportServerReportBuilder folder containing the following <?xml version="1.0" encoding="utf-8"?> <configuration> <compilation tempDirectory="C:Program FilesMicrosoft SQL ServerMSRS11.instancenameReporting ServicesRSTempFiles"/> </system.web> </configuration>

By | 2018-07-18T11:23:45+00:00 January 27th, 2015|Dynamics GP|