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.
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 more
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 more
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, 2017read more
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 more
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 more
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 more
We promise we don't send spam