ERP
Fully integrated cloud based and on premise business solultions to meet your company needs. ERP is the connected Enterprise. We provide the sales, consulting, and support for a wide variety of ERP solutions.
SQL Script to add users to GP SQL databases
/*This script will set access to SQL databases where each GP user has accesswithin the User Access window inside GP.You can run this after setting up a test company, or any time you get the error:The user could not be added to one or more databases.*/declare...
read moreGP Modify Transaction Date – AP
GL batch posting date is correct. Transaction date is incorrect. In the PM20000 open table affected fields are DOCDATE, DUEDATE, Tax_Date. Example SQL query to update DOCDATE. Make sure to backup your company database. update PM20000 set DOCDATE = '4/12/2017' where...
read moreUser id already logged in to GP and can’t delete their own session
User can't delete their own session and delete activity where userid = 'xxx' does not work. May be accompanied by the stored procedure on smcleanupfilesbeforelogin returned the following result: DBMS:0 Microsoft Dynamics GP 20505. Have everyone exist GP. Treat...
read moreMS Dynamics GP 2015, 2016, 2018 requirements
GP 2015 - Windows OS 2008 R2 or 2012, MS SQL 2012 or 2014 GP 2016 - Windows OS 2008 R2 or 2012 or 2016, MS SQL 2012, 2014, 2016 GP 2018 - Windows OS 2012, 2012 R2, or 2016, MS SQL 2014, 2016, 2017
read moreError 207 when upgrading company
Sometimes you get the strangest table errors when upgrading GP. If the upgrade in utilities stops and you see error 207 try the following. In SQL Studio run against the Dynamics system database. select * FROM DU00030 where errornum = '207' Clear status 70 for the...
read moreLock on company when running utilities
After loading a service pack or new version you may see a lock on a company file in utilities. In SQL Management Studio on Dynamics database run the query select * from duCLK Look for the company number in question and delete duCLK. Start utilities again. To get the...
read moreWhat is ERP?
ERP is an acronym for Enterprise Resource Planning, but even its full name doesn't shed much light on what ERP is or what it does. For that, you need to take a step back and think about all of the various processes that are essential to running a business, including...
read moreWe promise we don't send spam