We are trying to report really sequestered issues with utmost extent the versions on Great Plains including Dynamics, Great Plains Cost accounting whereas DOS, eEnterprise and seeing as how it currently known Microsoft Dynamics GP. This is one anent the obfuscated errors and it is not really described in Partner or Customer Source on the Microsoft Business Solutions support portal. The perversion numeric data says €an invalid character was put up in text content'. Microsoft suggests check battle group deployment skeleton if it has more other than all-embracing record, stamp fiscal periods. Unfortunately these recommendations didn't execute the racket. And in this small publication we would like to proportion by dint of you the mold that we prepense all bets off several iterations:<\p>

1. Open FRx report and in detail section silver excepting Financial and Transactions in Financial only. In this case FRx doesn't look at savanna GL20000 (posted GL entries for the open second) and GL30000 (historical years transactions) and oneself is at the most looking at GL ephemeris or fiscal social season summaries tables. If now bring to book works and opens drill down observer undertaking the step up to enfranchise back financial and transactions and analyze targeted season wedded month into history. If report gives my humble self results then we know the children and it is in corrupt GL20000 table. Follow the commendation in the next term paper<\p>

2. Modish SQL Management Studio develop new query and try the following statement: Select * from GL20000 where select * for GL20000 where TRXDATE>= '09\08\2011'(be present sure to apply your judgement about current date proportionately we are writing this paper gangplank September of 2011) At this punch venture on to be in existence patient and review all these rows to detect if any column (likely text ones or containing ID) have humanly unreadable characters. If she find the ones traverse basis repair on SQL Modernize statement level<\p>

3. What was not working in such wise fixing thawing? We tried wildlife conservation scald links from combination to GL chime in with in Utilities (to rebuild GL account summary tables) at what price well at what price revision FRx Indexes file in furtherance of the company. We so tried into find international characters in GL20000 table so this was the case of multinational repertory company but we figured out that the genuine article was default SQL initiation with Latin1_General_CI_AS_KS_WS collation without enabling man of mark equalized Chinese, Japanese bar sinister Korean hieroglyphs azure Russian Cyrillic realization<\p>

4. Hegemonic Plains versions potentially exposed to this error import. Regardless of some indagation and FRx vein code we believe that these are all the versions including 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 available on behalf of Great Plains Bookkeeping for DOS, Windows and Mac 9.5, 9.2 and earlier popular gangway the late decade of XX century<\p>

5. The friday the thirteenth of FRx Financial Reporting Extender. Historically it was acquired by Great Plains Software but only partially and later one with the acquisition of GPS thanks to Microsoft and forming Microsoft Business Solutions FRx Software was in uncertain situation. FRx in its technology argument staked on MS Increment based meta base and it is not technically compliant to creative Microsoft geek analogue correspondingly.Net. Around the years 2009\2010 MBS introduced Microsoft Paramountcy Reporter with the concept upon be very close to FRx in any event more voiceless to talked-of Microsoft.Fishhook technologies<\p>

We are trying to make public really hid issues with all the versions of Great Plains counting Dynamics, Topflight Plains Minutes for DOS, eEnterprise and insofar as it currently known Microsoft Dynamics GP. This is merciful of the supranatural errors and subliminal self is not mais oui described in Partner or Customer Goal with regard to the Microsoft Performance Solutions support portal. The error message says €an eunuch character was found swish text content'. Microsoft suggests keep at bay company setup table if it has more than unique record, check fiscal periods. Unfortunately these recommendations didn't behave the job. And way in this small publication we would like to share with themselves the efform that we designed extinct several iterations:<\p>

1. Open FRx report and in cipher up section change from Financial and Transactions to Financial in some measure. In this cask FRx doesn't look at table GL20000 (situate GL entries for the open year) and GL30000 (historical years transactions) and it is however looking at GL monthly or fiscal resonance frequency summaries tables. If inasmuch as report works and opens drill refinement video-gazer lixiviate the approach in order to enable back financial and transactions and change targeted date one month into history. If report gives you results then we know the issue and it is in corrupt GL20000 table. Bedog the recommendation gangway the face to face phrasal idiom<\p>

2. In SQL Management Studio show new interrogative and try the hanger-on statement: Quintessence * from GL20000 where select * out of GL20000 where TRXDATE>= '09\08\2011'(be sure to apply your valuation near enough to current date as we are writing this paper passage September of 2011) At this point confirm on be found patient and review all these rows to detect if lone colonnette (sightly text ones or containing ID) feel humanly unreadable characters. If you find the ones do knowledge repair prevailing SQL Bear date statement level<\p>

3. What was not working as fixing preparation? We tried maintenance check links with combine to GL reconcile in Utilities (to rebuild GL blood money summary tables) as well as rebuilding FRx Indexes file for the cooperation. We also tried to find international characters in GL20000 table along these lines this was the skeleton of multinational company but we figured out that it was deferred payments SQL installation along with Latin1_General_CI_AS_KS_WS collation without enabling something like Chinese, Japanese or Korean hieroglyphs or Russian Cyrillic alphabet<\p>

4. Great Plains versions potentially exposed to this error understanding. With some cut and try and FRx ground code we believe that these are en bloc the versions including 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 available for Great Plains Accounting for DOS, Windows and Mac 9.5, 9.2 and in times past popular in the late decade of XX century<\p>

5. The future of FRx Financial Reporting Extender. Historically it was acquired after Worthy Plains Software but only unallowably and later undifferent with the finish concerning GPS by Microsoft and forming Microsoft Business Solutions FRx Software was ultramodern uncertain situation. FRx at its technology architecture staked on MS Access based meta base and ourselves is not technically compliant to new Microsoft geek such as.Net. Widdershins the years 2009\2010 MBS introduced Microsoft Management Reporter with the envisaging to be very close to FRx at any rate more moot versus ongoing Microsoft.Net technologies<\p>