Great,Plains,Consultant,Newsfl computer Great Plains Consultant Newsflash: FRx move to new Server
Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc ----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a
Being working for major Great Plains Dynamics GP VAR in US,we realized that our large customers are following this simple technique: placenew server with newer Operating System (such as Windows 2003 instead of oldWindows 2000), install SQL Server 2000 or 2005, move Great Plains DYNAMICS andall companies databases, move user logins, password and security access (youcan also find these SQL scripts at Microsoft Dynamics Customer Source). Thenshut down the old Dynamics GP Server, rename new server to its old serveroriginal name, and off you go! Well,this is about Dynamics GP Great Plains. FRx Financial reporting is more sensitive to UNC Path, Shared Foldersand mapped drives. If you ran into theseissues, this small publication is dedicated to you: 1. FRxSysdata concept. Please login FRxreports designer, under Admin->Organization->SYSDATA you should seewhere your current FRx metabase is located. Please, know that FRx is compatible with multiple ERP platforms: GreatPlains, Axapta, Navision, Solomon and these are the reasons to lean on filelocation. Sysdata folder has FRxmetabase and if you change settings for your companies:Company->Information: Specification Set, Import and Export Path, Rates DatabasePath (in case if you deploy multicurrency in GP and FRx) all the users willbe updated 2. FRxSystem Specific Information. Here youhave ODBC DSN, usually FRx deploys the same DSN as Dynamics GP Great PlainsWorkstation. For Each company pleasespecify system database: DYNAMICS and company database 3. AdminView OFSI Settings. In our practice,OFSI tables were source of the problems with earlier FRx versions: 6.5 anddown, These were the days in late 1990thwhere you would have to create OFSI tables manually in SQL Query Analyzer 4. G32files error messages. The concept behindis pretty simple FRx rebuilds GL indexes on logon. If you are getting error message, that youcan not login FRX due to G32 file is locked, please open your sysdatadirectory, rename all G32 extension files and come back to FRx this shouldfix the problem 5. Ifyou are at the point where you are considering to give up on FRx issues, weunderstand and respect your position consider to give us a call
Great,Plains,Consultant,Newsfl