 |
Further
Reading ...
|
|
Emerging Printer Interfaces
There are some new and exciting technologies for printers that we will all be enjoying in the very near future. Actually the technology is available right now but many people do not understand it or know how to use it. The technology that I will...
ASP, CGI And PHP Scripts And Record-Locking: What Every Webmaster Needs To Know
Many of us install server-side (ASP, CGI or PHP) scripts on our web sites, and many of this scripts store data on the server. However, poorly designed scripts can experience performance problems and sometimes even data corruption on busy (and not so...
Unique gift ideas for the Holiday Season! Go Digital!
Instead of scouring the mall for gifts this holiday season why not consider using your cherished photos to create a unique personalized gift for family and friends?
There are so many ways now, made easy with online sites and programs, to create...
The Top 3 Photo Editing Software
More often than not, Adobe Photoshop CS comes in one’s mind when photo-editing software is mentioned. Next to that are Adobe Photoshop and Adobe Illustrator CS. Adobe Photoshop is an effective and useful program that is used by many, to mark a...
|
|
|
FRx - Microsoft Great Plains Reporting: design, upgrade and migration– overview for consultant
|
 |
Written By:
Andrew Karasev
|
|
|
|
Microsoft Business Solutions Great Plains is main ERP application targeted to US mid-size businesses market. Microsoft Great Plains is now moved to Microsoft SQL Server and so exposed to standard Reporting tools, such as Crystal Reports based on internal Crystal links or SQL Server view and stored procedure. Also Great Plains, built on legacy Great Plains Dexterity technology has ReportWriter – which is good, when you are modifying Sales or Purchasing Invoice form. When we are dealing with Financial Reporting – traditional and very powerful tool is FRx. FRx connects to General Ledger and there you can apply account mask to summarize financial data at your will, create reporting tree, or combine Great Plains and Excel data on the same report.
We usually do not see problems in FRx report design, however consultants are reporting multiple issues with FRx upgrade or remapping FRx when you migrate Great Plains from legacy platform (Pervasive SQL or Ctree) to MS SQL Server. Let us give you typical troubleshooting steps:
- SYSDATA. FRx stores its report in one directory, named SYSDATA, so when you move FRx or upgrade it – you upgrade files in this directory. Be sure that FRx points to the proper SYSDATA directory.
- Directories Structure problem. When you move FRx to different server or change directories structure on your workstation, typical issue is hardcoded report output path mismatch. You can see it if you look at report output destination tab. The hint – FRx stores output directory in SYSDATA on the server, so if your workstations are not structure-unified – you may have this issue.
- Service Pack fixes. FRx is known to be unstable in CD version and you typically apply latest service pack from Microsoft Business Solutions partner source (or Customer Source - continued below ...
|
|
|
continued ...
if you support your Great Plains internally)
Back Arrow problem. This is very typical and funny issue. When you install FRx – you should never hit Back button. If you do – FRx installation will be corrupted. Just for you to know. This was FRx 6.0 very-very known issue
Corrupt Catalogue. Well – this may happen with every application. FRx is not an exception. If you have strange error message – you may try export and reimport. The same is applicable to Great Plains ReportWriter
Drilldown Viewer problem. This happens when you are upgrading. You should check that you are selecting XML Drilldown Viewer – this is newest version. Old report tries to keep old Drilldown Viewer and you get error message when launching it.
You can have such a nice tools as Explorer to imitate Sales or Financial reporting for you and then dump it to Excel with the click of the button as good alternative to FRx, but we would recommend you to stick to FRx for regular financial reporting – this is the tool of the choice for controller.
You can always have us help you, give us a call: 1-630-961-5918 or 1-866-528-0577, help@albaspectrum.com
About The Author
Andrew Karasev is consultant and CTO in Alba Spectrum Technologies ( http://www.albaspectrum.com ) – Microsoft Business Solutions partner, serving clients in Illinois, California, New York, Florida, Georgia, Arizona, Colorado, Texas, Minnesota, Virginia, Washington, UK, Canada, Australia. He is Microsoft Great Plains certified master, Great Plains Dexterity, Microsoft CRM SDK C#.Net, Crystal Repots developer. You can reach Andrew: akarasev@albaspectrum.com.
|
|
|
|
 |
|
|
| _Additional Resources ... |
|
Squeezed Broadband?
If you could receive a penny for every website on the net that promises to speed up your Internet Service, you would be rich. You will find a massive amount of software programs that promise to speed up your connection for free! Beware of...
Make Online Auctions a Home Business
This article may be reproduced in any ezine or website provided the resource box at the end is included. Tips to Avoid Online Auction Fraud While most buyers and sellers on internet auction sites are honest, there is always the threat of...
Your Website Visitors - Will They Stay?
I'm sure you've all heard the saying 'Build it and they will come'. Although that may have been true a few years ago, now we must work, and work hard, to get visitors to our websites.
You can't always control who visits, however, you can...
|
|
|
|
|
|
|
|
|
|
