| If you are Dynamics GP Corporate ERP application in | | | | often considered as mysterious, but the explanation is |
| your organization, where Financial Reporting is built on | | | | quite simple. You typically have this error message in |
| FRx platform, we would like to share with you some | | | | the first week of January in New Year (or in the initial |
| technology notes about FRx. Current version of | | | | week of your fiscal year, if it is different from Calendar |
| Microsoft Dynamics GP is 10.0 (Dynamics GP 11.0 | | | | Year). You have to build fiscal periods (typically |
| should be released in first half of 2010) and current | | | | months) in each Dynamics GP companies (if they are |
| version of FRx Financial Reporting is 6.7 (Service Pack | | | | participating in consolidated FRx report), then you have |
| 10). FRx is covering multiple Accounting packages, | | | | to rebuild GL indexes in FRx itself for each company. |
| this is its strength and at the same time this fact | | | | GL Indexes rebuilding is FRx setting sensitive. In |
| exposes FRx to some additional overheads in | | | | some case you have to delete *.G32 files (specific GL |
| supporting and reports design and re-haul: | | | | indexes cashing file in FRx Sysdata directory). Often |
| 1. Modifying Dynamics GP Chart of Accounts and FRx | | | | you can do the same job by simply change Default |
| potential issues. This is normal to decide on Great | | | | Company in FRx one by one and watch how GL |
| Plains Chart of Accounts restructure, especially | | | | indexes are rebuilt in left bottom status bar line. The |
| considering the fact that GL accounts distribution | | | | way to setup automatic GL indexes rebuild is to go to |
| tables (GL20000, GL10000, GL10001, GL30000) are | | | | Admin -> System Preferences and check there GL |
| based on Account Index field (not physical accounts | | | | automatic index rebuild |
| segments). So, you can go ahead and change | | | | 3. Older versions of FRx and Microsoft Dynamics GP, |
| accounts segments, if you have clear one-to-one | | | | Great Plains Dynamics or eEnterprise: 10.0, 9.0, 8.0, 7.5, |
| picture (and designed SQL scripts accordingly). | | | | 7.0, 6.0, 5.5, 5.0, 4.0, 3.2. FRx Financial Reporting came |
| However the challenge for FRx might appear when | | | | all the way from earlier Great Plains Software |
| you change normal balance from Debit to Credit or | | | | Dynamics versions to the current version of Microsoft |
| vice versa. FRx for Dynamics GP looks at GL | | | | Dynamics GP 10.0. However FRx didn't change |
| Account Current Summary Master table (GL10110) in | | | | much in its functionality, and FRx report designer, who |
| order to expedite results, so if your GL10110 table has | | | | is familiar with FRx 6.7 for Dynamics GP 10.0 should be |
| old summaries - the only way to force your FRx | | | | able to modify or recover FRx report for earlier Great |
| Balance Sheet report to balance is to reconcile | | | | Plains versions (FRx 6.5 or earlier, including FRx for |
| accounts. Typical accounts and account groups for | | | | Dynamics GP on Pervasive SQL 2000 or Ctree) |
| changing its typical balance are in Assets: | | | | 4. If your FRx issue is not answered here in this article. |
| Accumulated Depreciation and Amortization, and in | | | | Well, if you have active support contract with |
| Equity: Dividends (C or S Corporation), Partner Draws | | | | Microsoft Business Solutions - then you should have |
| (LLC). Plus, if you have multiple companies in | | | | login info to MBS Customer Source (then take support |
| consolidated reporting, you may decide to review Due | | | | and search knowledge base, download current service |
| to and Due from sections (AP and AR) | | | | pack, etc. |
| 2. "Changed Default Base Period to C" - this issue is | | | | |