Dynamics GP

Njevity Recognized in Bob Scott’s Insights Top 100 VARs List in 2018

Njevity, Inc. is proud to announce that it’s been recognized by Bob Scott’s Insights in the Top 100 VARS list for 2018. The Colorado based VAR is solely focused on providing exceptional business application experiences for Dynamics GP.  One of the biggest reasons for Njevity’s success is their commitment to enhancing the user experience.  Njevity was also an early adopter of providing Dynamics GP through Cloud to Customers in 2011.  They expanded their Cloud business and started selling their Dynamics GP Cloud solutions through Partner in 2013.  Today, Njevity has nearly 3,000 users who connect to Dynamics GP every day in their secure cloud environments that were built and optimized solely for an exceptional Dynamics GP experience. With Njevity’s launch of PowerGP Online, Dynamics GP reinvented for the Cloud, Njevity further made a commitment to the future and success of customers using Dynamics GP in 2016.  With bundled in third [...]

By | 2018-09-05T21:35:31+00:00 September 5th, 2018|Dynamics GP, Njevity|

Remove Customer Experience Improvement Program Reminders from Microsoft Dynamics GP

Ever stopped long enough to look into how to Remove Customer Experience Improvement Program Reminders from Microsoft Dynamics GP?  Although they can be annoying, sometimes it's more trouble than it's worth to research how to remove them.  We will make it easy so you can stay focused on your work and get rid of these pesky interruptions. To stop those reminders, open the Microsoft Dynamics GP drop down menu in the toolbar at the top of the main GP window and click Reminders.   In the Reminders window, double-click on one of the Customer Experience Program tasks in the list.     In the Task window, click on the Name link at the bottom left of the window.     In the Customer Experience Improvement Program window, select the option that says "I don't want to join the program at this time", and click OK.     Click Save on [...]

By | 2018-08-23T05:04:28+00:00 August 23rd, 2018|Dynamics GP, Support|

Is it time to breakup with QuickBooks?

QuickBooks works well for really small businesses and startups because it gives you control over your cash.  It provides the basics, but eventually as a business grows or becomes more mature the basics aren’t enough.  Follow our simple 'list of don'ts' to know when you need to breakup with Quickbooks. Top Signs it's time to breakup with Quickbooks: Double Data Entry: As your business slowly began to grow, so did all the applications that you had to manage, and chances are they didn’t work well together. It’s very common to not think very far into the future and to focus on just solving the immediate problems at hand. Now, you are stuck entering data into multiple systems and it’s challenging your people. Trying to Configure QuickBooks to do things it wasn’t designed to do. There is an entire network of consultants whose sole job is to make workarounds to hack [...]

By | 2018-08-03T20:05:07+00:00 August 3rd, 2018|Dynamics GP, Njevity|

Payables Check Batch Posting Error: Invalid Column Name ‘TEN99FATCAFILEREQ’

After upgrading from GP 2013(R2) to GP 2018, the first check batch our customer tried to post failed and wend to Batch Recovery.  The error detail in the More Info section was:   A get/change operation on table 'pm1099PeriodDtl' failed accessing SQL data. Invalid column name 'TEN99FATCAFILEREQ'.   Problem:  The TEN99FATCAFILEREQ column was a new column in the PM00204 table as of GP 2015, but the upgrade did not update the table correctly.   Solution: 1.       Create a staging table in SQL that matches the PM00204 table, and copy all data from the PM00204 table to it. 2.       In GP, go to Microsoft Dynamics GP >> Maintenance >> SQL.     3.       In the dropdowns at the top, select the Database and Product: Microsoft Dynamics GP 4.       Select Purchasing 1099 Period Detail in the list pane. 5.       Check the boxes for Drop Table, Create Table, Drop Auto Procedure, and Create [...]

By | 2018-07-02T20:15:28+00:00 July 2nd, 2018|Support|

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|