FRx for Characteristics GP Troubleshooting and Interesting Rare Technical Assistance Cases

We are aiming to report actually unidentified concerns with all the variations of Great Plains consisting of Characteristics, Great Plains Accounting for DOS, eEnterprise and as it presently understood Microsoft Characteristics GP. This is among the magical mistakes and it is not actually explained in Partner or Consumer Source on the Microsoft Organisation Solutions assistance website. The mistake message states 'A void character was discovered in text material'. Microsoft recommends check business setup table if it has more than one record, check financial durations. These suggestions didn't do the task. And in this little publication we want to show you the repair that we developed through a number of models:

1. Open FRx report and in information area modification from Financial and Deals to Financial just. In this case FRx does not take a look at table GL20000(published GL entries for the open year) and GL30000(historic years deals) and it is just taking a look at GL regular monthly or financial duration summaries tables. If now report works and opens drill down audience attempt the technique to make it possible for back monetary and deals and alter targeted date one month into history. If report provides you results then we understand the concern and it remains in corrupt GL20000table. Follow the suggestion in the next paragraph

2. In SQL Management Studio open brand-new question and attempt the following declaration: Select * from GL20000where choose * from GL20000where TRXDATE>>= '09/08/2011'( make certain to use your judgement about present date as we are composing this paper in September of 2011) At this moment attempt to be client and examine all these rows to spot if any column (most likely text ones or consisting of ID) have humanly unreadable characters. If you discover the ones do information fix on SQL Update declaration level

3. Exactly what was not working as repairing option? We attempted upkeep check relate to mix to GL fix up in Energies (to reconstruct GL account summary tables) in addition to restoring FRx Indexes declare the business. We likewise searched for global characters in GL20000table as this held true of international business however we found out that it was default SQL setup with Latin1_General_CI_AS_KS_WS collation without making it possible for something like Chinese, Japanese or Korean hieroglyphs or Russian Cyrillic alphabet

4. Great Plains variations possibly exposed to this mistake message. With some research study and FRx source code our company believe that these are all the variations consisting of 2010, 10.0, 9.0, 8.0, 7.5, 7.0, 6.0, 5.5, 5.0 and 4.0. Please note that FRx is not readily available for Great Plains Accounting for DOS, Windows and Mac 9.5, 9.2 and earlier popular in the late years of XX century

5. The future of FRx Financial Reporting Extender. Historically it was gotten by Great Plains Software application however just partly and later on one with the acquisition of GPS by Microsoft and forming Microsoft Organisation Solutions FRx Software application remained in unpredictable circumstance. FRx in its innovation architecture staked on MS Gain access to based meta base and it is not technically certified to brand-new Microsoft geek such as.Net. Around the years 2009/2010MBS presented Microsoft Management Press reporter with the idea to be extremely near to FRx however more open up to present Microsoft.Net innovations

Back to Top