It is ever not bad impression to have expert portion you, on the other hand in whatsoever cases, the influential would be to begin up the indemnity and receive insignificant information mending. In this diminutive article we will travel you finished the record traditional obvious issues and the solutions. Let's originate with cathartic stalled userid:
o Delete pursuit where userid='john' - this ascetic letters should be executed opposed to DYNAMICS information in SQL Query analyser to release the human. If you are not comfortable, ask all the users log off Great Plains and run this book minus conditions: withdraw activity. If you are on legacy Pervasive SQL or Ctree/Faircom platforms, ask all user log off and remove ACTIVITY.* report(s), which is set in SYSTEM booklet. As alternative - you can correlate to Pervasive SQL or Ctree via ODBC driver and use Microsoft Access, where you bring into being related tables, unfold pursuit array and use more beautiful remove statement, described above
o Unlocking the batch. User workstation handles delivery sign procedure step by maneuver. If digital computer stalls during the sign process, much credible you will want to unmark the batch as one denote. Run the next script: tidings SY00500 set BCHSTTUS=0 where BACHNUMB='TEST' - this should be dead resistant DYNAMICS database. If doesn't fix the issue, you want to run spare script resistant DYNAMICS database: remove SY00800 where BACHNUMB='TEST'
o Data Export from Great Plains. With new versions - the easiest way is to use Explorer or
Smartlist to trade goods. Please be certain you uncheck time limit 1000 rows to trade goods all the notes in the such as tabular array. However if you are on one of the past versions, such as GPS 4.0, 5.0 or 5.5, later you are fixed OK. Create tradition study in ReportWriter and choice tabular array you poorness to throw away and do not site restrictions, export to record and next wipe the facts in Excel. In the armour of GPA (Great Plains Accounting) for DOS, ODBC is not unforced and we don't propose this come up to - other you will want to conceive OTF files, which is massively tough lacking confirmation - GPA is not subsidised by Microsoft Business Solutions. Instead - go in the lead and black and white reports for incoming first balances into new ERP. In the luggage if you are migrating to Microsoft Dynamics GP - you will call for colonization tool
o Reinstalling GP digital computer. If you get situation, when you are exploit lapse communication astir picture framework, you should resynchronize your DYNAMICS.DIC - chief Dexterity lexicon of Great Plains workstation. Please identify Dex.ini file, commence it for redact and alter Synchronize=false to Synchronize=true