Integrating FRx With Analytical Accounting


Last few days, I been working with my colleague Ms. Samia  on integrating the the Analytical Accounting Dimensions with FRx Reports, actually it was not an easy task as expected but the results was Great 🙂

Basically as a start we followed the documents and worked on the steps below:

1. On FRx CD, we have installed the AddIn located under “Analytical Accounting Add-in\FRx 6.7 Add-In for Microsoft Dynamics GP Analytical Accounti.msi”.

2. We went to the following path “C:\Program Files\FRx Software\FRx 6.7\Analytical Accounting\Scripts\SQL Server” and found 2 scripts:

CreateTablesAA.sql and CreateProcsFunctionsAA.sql

First run CreateTablesAA against you Dynamics Database, which will generate another script to run on your companies’ databases, copy this script and run it on a new query window to update your database.

Then run CreateProcsFunctionsAA and perform the same steps you performed on the other script.

3. Go to the following path (or where you installed the FRx) “C:\Program Files\FRx Software\FRx 6.7\Analytical Accounting\” and run “AAWizard.exe”, which will in return will load your Analytical Accounting dimensions and codes into FRx databases. –You might face some errors in this stage, contact me if you face any error and I will help!-

4. Now we are ready to start, open FRx Report Designer the go to Company >> Information, create new company and Select “Analytical Accounting” for the accounting system –if you couldn’t select the Analytical Accounting then you will need to register some DLLs, search the knowledgebase for such article-:


5. Now the fun will begin!! Create New Row, and open the GL accounts lookup and make sure you selected “Full” in the account segment:


The first segment represents the GL account number, while the other segments are the dimensions added to the Dimension Structure you created in the wizard.

6. Add a new column and add Description and GL columns as needed:


7. Add new Report Catalog and link your row and column:


8. Print your report and enjoy having your dimensions and codes in the statement:



Mohammad R. Daoud – CTO
+962 – 79 – 999 65 85


About Mohammad R. Daoud
Mohammad R. Daoud has been working as a Microsoft Dynamics GP consultant since 2004. His career path started with version 7.5; he studied every single tip of the application technicalities and did allot of successful implementations that includes functional consultations, analysis, and custom development projects. He holds a graduate degree in Computer Science and currently he is pursuing MBA degree in Accounting. In January 2007 he was nominated to the Microsoft Most Valuable Professional (MVP) certificate and was certified in April 2008 due to his online contributions in the Dynamics Community (Dynamics GP Newsgroups, Forums, User Groups and his blog: Worth to mention that he was also listed as one of the Microsoft Dynamics Top 100 Most Influential People in 2009 by DynamicsWorld. And more... • Demonstrated Passion for MS Products through participating in beta testing for some product versions, an effective member of Microsoft Connect. • Talented in securing strong high quality relationships with premier customers, partners and sales teams passionately and profitably. • Dedicated to meeting the expectations and requirements of internal and/or external customers • Problem Solver – Uses systematic approach to uncover true problem(s) and practical solution and can marshal resources to solve problem! • Proven record of effective account management, including Account Planning, Opportunity Management, and Business Management Excellence and working as part of a larger virtual team • Successful in delivering high quality technical engagements in the enterprise Dynamics GP implementations area according to customer requirements. • Dedicated, Committed, Self Motivated, Creative and highly focused with excellent communication, Negotiation, presentation, Active Listening and Objection Handling skills. • Experienced in Profitable researches and studies including white papers and technical presentations.

14 Responses to Integrating FRx With Analytical Accounting

  1. Doug Pitcher says:

    Good step by step. There isn’t much out there about how to do this.

    Also note if you make any changes to dimensions in GP you will have to use the Refresh COA button in the dimension wizard so the new dimensions will show up on your FRx reports.

  2. Thanks for the tip Doug 🙂

  3. Katie says:

    In the AA Dimension Wizard Step 1, I am receiving the common error: “An internal program error has occurred. This program is shutting down.” I have followed MBS instructions to apply SP9, SP10, and SP11, and I am still getting these errors. What solution did you find?

  4. This error accords only if you didn’t run the scripts as needed (Step 2), you need to run a script against your Dynamics database that will in return generate another script to be run on your companies.

  5. Katie says:

    I applied SP9 and SP11, and then I ran the two scripts located inside the SP11 download folder. I am still receiving the message. I am on FRx version 6.7.11027. Please help.

  6. Anonymous says:

    Thanks Mr Daoud
    But when i tried to run the AA wizard this error is appears
    ” an error occurred while attempting to access the database .
    for more information , view the application event log.
    please help

  7. Katie says:

    Hello All –

    I have found that these errors occur when you are atttempting to run the wizard on a 64-bit machine. FRx is still not 64-bit compatible. I was able to install FRx (with AA) and even build non-AA reports, however, when I got to the AA wizard, that is when I started receiving the errors.

    One work-around I have found is to run the wizard on a 32-bit machine, then map the 64-bit machine to the shared FRxRpts.f32 file. This solution is not supported by MBS, however, it was a successful work-around for me.


  8. Anonymous says:

    Thanks Kaite for your replay but my machine is 32-bit so. what can i do???

  9. Anonymous says:

    Hi all,

    I have a weird issue I followed the steps correctly but in the link to GL account lookup it’s empty.(if I switch to types I can see them even the acct segments are correct)
    I did try it on fabrikam it’s working fine.
    any ideas?

    thank you

  10. Anonymous says:

    it’s good to see this information in your post, i was looking the same but there was not any proper resource, thanx now i have the link which i was looking for my research.

    Accounting Dissertation Proposal

  11. Davis Paul says:

    Hi Mohammad. Help me please.After step 3 this error is appears: "The data source that you are connecting to was found to have compliance issues that will not allow it to be configured. See the error list below".This generating a archive .csv with more of 600 registers with name Dimention with character invalide.What do i do?Thanks…Poless

  12. Dear Daoud, I am in AA Wizard Step 1 of 5. I got "an error occured while attempting to access the database". Previously 4 company's successfully create the dimension. I check here and there but still same errors came. I am stuck now. Please help.

  13. Mona says:

    very informative post, but have problem ,when i choose from drop down list Analytical account it disappear and didn't make any change ,you mention that i can run dll's please support me with more detailsthx

  14. To resolve this problem, follow these steps: 1. In the Microsoft FRx folder, double-click the FRxReg.exe file to register all the .dll files in the Microsoft FRx folder.2. Check the Microsoft FRx program folder, and then verify that the Fsaa80.dll file exists. After you find this file, register the file. To do this, follow these steps: a. Right-click the Fsaa80.dll file, and then click Open With.b. Locate the Windows\System32 folder on the local drive. c. In this folder, click the Regsvr32.exe file, and then click Open. You should receive a message that the file registered successfully.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: