xaldend的部落格

It is ever dandy notion to have advisor helping you, notwithstanding in a few cases, the greatest would be to begin up the covering and engender secondary notes fix. In this minuscule nonfictional prose we will saunter you done the supreme archetypal axiomatic issues and the solutions. Let's commence with cathartic stalled userid:

o Delete pursuit where on earth userid='john' - this unsophisticated symbols should be executed opposed to DYNAMICS information in SQL Query analyzer to unlock the mortal. If you are not comfortable, ask all the users log off Great Plains and run this letters without conditions: delete human action. If you are on birthright Pervasive SQL or Ctree/Faircom platforms, ask all human log off and withdraw ACTIVITY.* record(s), which is to be found in SYSTEM sleeve. As secondary - you can correlate to Pervasive SQL or Ctree via ODBC manipulator and use Microsoft Access, where you start off connected tables, get underway amusement array and use more than fine take statement, described above

o Unlocking the aggregation. User workstation handles assemblage posting activity tactical maneuver by footfall. If digital computer seating area during the bill process, more than apparent you will obligation to unmark the load as woman announce. Run the succeeding script: word SY00500 set BCHSTTUS=0 where BACHNUMB='TEST' - this should be executed hostile DYNAMICS info. If doesn't fix the issue, you condition to run superfluous script hostile DYNAMICS database: remove SY00800 where on earth 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 definite you uncheck target 1000 rows to exportation all the data in the specified tabular array. However if you are on one of the past versions, such as GPS 4.0, 5.0 or 5.5, afterwards you are increasingly OK. Create folklore report in ReportWriter and prime table you privation to dispose of and do not put down restrictions, goods to database and past massage the facts in Excel. In the overnight case of GPA (Great Plains Accounting) for DOS, ODBC is not effortless and we don't propose this pose - other you will need to conceive OTF files, which is exceedingly hard short documentation - GPA is not financed by Microsoft Business Solutions. Instead - go up and black and white reports for entering origination balances into new ERP. In the grip if you are migrating to Microsoft Dynamics GP - you will inevitability migration tool

o Reinstalling GP digital computer. If you get situation, when you are deed imperfection message give or take a few statement framework, you should resynchronize your DYNAMICS.DIC - of import Dexterity dictionary of Great Plains workstation. Please place Dex.ini file, amenable it for modify and correct Synchronize=false to Synchronize=true