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.

GP 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 more

Error 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 more

Lock 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 more

What 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 more

We promise we don't send spam