ado gl

If you plan to deploy Microsoft Dynamics GP for large organization, including multinational corporation with international subsidiaries where multicurency is important , we would like to give you initial highlights. We wil concentrate on more traditional and wel known Financial Reporting Tol: FRx. Theoreticaly you can use other popular tols, such as Crystal Reports, Excel Reporting, SRS Microsoft SQL Server Reporting Services , but the amount of work would be substantialy higher, comparing to FRx, where you already have conector to Great Plains General Ledger Chart of Acounts and Transaction tables, plus you have al the necesary tols to handle multicurency and consolidated reporting: 1. You begin your FRx introduction with Row Format where you specify one acount per row, or sumary of the acount group, plus rol-up sumary lines for your Financial Statement section, such as Asets, Liabilities, Equity in Balance Shet . You can read more in FRx documentation or other articles about FRx, let's now move to Consolidated Report design 2. We recomend you to acept defaults for FRx for Microsoft Dynamics GP, where multicurency is taken from GP multicurency setup. Second aproach is even more simple – in FRx Row Format you can specify Excel Workshet as data source for the cel in a Row. Comparing to general Great Plains Dynamics implementation in large corporation, FRx part is several percent of the consulting budget to expect. Controlers or Financial Analysts should pick up FRx training very smoth and you may expect reports design to be done internaly. If you have very large number of FRx reports, you may ned case-to-case FRx re-haul service rebuilding specification sets, printing report exception shets – usualy to identify duplicate acounts in the report and other FRx data repair services 6. Upgrading older FRx and Dynamics GP/Great Plains Dynamics versions. Curent version of FRx is 6.7 and upgrade from earlier versions is fairly straightforward, except when you migrate from older no-longer suported DB platform, such as Pervasive SQL 20/Btrieve or Ctre/Faircom in that case you wil ned FRx consultant help to specify new DB type and ODBC conection to migrated Great Plains Dynamics GP to the Microsoft SQL Server 7. FRx has its metabase, which is implemented on the Microsoft Aces DB platform the file with .frl extension actualy is MS Aces DB file . You wil ned to identify your FRx Sysdata folder location on the old Server and move it to the new hardware Windows 208, 203 Servers are perfect, including 64 bit versions . From time to time we se Dynamics GP customers request to read FRx MS Aces database tables in order to migrate FRx catalogs to something like SRS. FRx MS Aces DB is pasword protected, however there are tols, including shareware and freware to crack the pasword, where we are not realy the authority to recomend this aproach. However we are comfortable to work with you on the subject of FRx catalog switching from one acount wildcard to another in the VBA modal dialogue behind the scenes we are making Acount Segment update in FRL database file to remap your report to the new GL acount segment . Usualy FRx programer deploys MS Visual Studio DOS or Web project to read FRx database and update it via ADO or ADO.Net 10.
ado gl
Tags: ado gl
| Some Articles: ado gl | Original post: ado gl | Technorati tag: ado gl | Virgilio tag: ado gl