Free Articles, Free Web Content, Reprint Articles
Saturday, February 16, 2019
 
Free Articles, Free Web Content, Reprint ArticlesRegisterAll CategoriesTop AuthorsSubmit Article (Article Submission)ContactSubscribe Free Articles, Free Web Content, Reprint Articles
 

Great Plains Consultant Newsflash: FRx move to new Server

If your current Dynamics GP Great Plains server got to be replaced with new hardware, you should follow procedures to move Dynamics GP databases as well as FRx reporting system files.  

Being working for major Great Plains Dynamics GP VAR in US, we realized that our large customers are following this simple technique: place new server with newer Operating System (such as Windows 2003 instead of old Windows 2000), install SQL Server 2000 or 2005, move Great Plains DYNAMICS and all companies databases, move user logins, password and security access (you can also find these SQL scripts at Microsoft Dynamics Customer Source). Then shut down the old Dynamics GP Server, rename new server to its old server original name, and off you go!  Well, this is about Dynamics GP Great Plains.  FRx Financial reporting is more sensitive to UNC Path, Shared Folders and mapped drives.  If you ran into these issues, this small publication is dedicated to you:

 

1.       FRx Sysdata concept.  Please login FRx reports designer, under Admin->Organization->SYSDATA – you should see where your current FRx metabase is located.  Please, know that FRx is compatible with multiple ERP platforms: Great Plains, Axapta, Navision, Solomon and these are the reasons to lean on file location.  Sysdata folder has FRx metabase and if you change settings for your companies: Company->Information: Specification Set, Import and Export Path, Rates Database Path (in case if you deploy multicurrency in GP and FRx) – all the users will be updated

 

2.       FRx System Specific Information.  Here you have ODBC DSN, usually FRx deploys the same DSN as Dynamics GP Great Plains Workstation.  For Each company please specify system database: DYNAMICS and company database

 

3.       Admin View OFSI Settings.  In our practice, OFSI tables were source of the problems with earlier FRx versions: 6.5 and down,  These were the days in late 1990th where you would have to create OFSI tables manually in SQL Query Analyzer

 

4.       G32 files error messages.  The concept behind is pretty simple – FRx rebuilds GL indexes on logon.  If you are getting error message, that you can not login FRX due to G32 file is locked, please open your sysdata directory, rename all G32 extension files and come back to FRx – this should fix the problem

 

5.       If you are at the point where you are considering to give up on FRx issuesFree Reprint Articles, we understand and respect your position – consider to give us a call

 

Source: Free Articles from ArticlesFactory.com

ABOUT THE AUTHOR


Andrew Karasev, Alba Spectrum LLC.  http://www.albaspectrum.com  help@albaspectrum.com  1-866-528-0577. Web portal: http://www.pegasplanet.com   We are Microsoft Dynamics GP technology partner, ERP and software integrator, who serves you USA, Canada, Mexico and Latin America nationwide.  Local service is available in Chicago, San Diego, Los Angeles, Houston.  We have customer in the following business metros: Phoenix, New York, Boston, Milwaukee, Buffalo, Rhino, San Jose, Miami, Atlanta, Minneapolis, San Francisco, Detroit, Montreal, Las Vegas, Oceania, Colombia, Caribbean, Poland, UK, New Zealand, Australia



Health
Business
Finance
Travel
Technology
Home Repair
Computers
Marketing
Autos
Family
Entertainment
Law
Education
Communication
Other
Sports
ECommerce
Home Business
Self Help
Internet
Partners


Page loaded in 0.115 seconds