Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Analytical Accounting ...
Microsoft Dynamics GP (Archived)

Analytical Accounting Reports SSRS

(0) ShareShare
ReportReport
Posted on by K Day 7,365

I am about to dig into the AA tables and start creating some reports in SSRS and was wondering if someone had some tricks or views that they used.  I am only vaguely familiar with the table structures at this point but am sure that I will know them very well by the end of this exercise.  I am looking at some of the GP views that already exist and I haven't found one that really suits my needs yet.  We use AA in the most basic ways, no budget, no trees, just coding expenses, mostly from expense reports, against Projects (using the Percentage Allocations), types (Airfare, Taxi, Subway), country, employee name, etc...

Also, has anyone ever had any luck with the FRx Analytical Accounting add-on?  I have messed around bt never really got it to work.  I suppose if it is intuitive and someone tells me that they have success running AA reports in FRx, I might explore that a little more.

Thanks,

Kevin

*This post is locked for comments

  • Sunbeam De Jesus Profile Picture
    Sunbeam De Jesus 3,930 on at
    Re: Re: Re: Re: Re: Analytical Accounting Reports SSRS

    no worries.

    pls note you must be on the latest FRx 6.7 SP10 to make it work properly. thanks too

     

     

  • K Day Profile Picture
    K Day 7,365 on at
    Re: Re: Re: Re: Analytical Accounting Reports SSRS

    Thanks Sunbeam, maybe I'll give the FRx add-in another try too.

  • Sunbeam De Jesus Profile Picture
    Sunbeam De Jesus 3,930 on at
    Re: Re: Re: Analytical Accounting Reports SSRS

    Hi Kevin,

    yes you can continue the path of using SSRS.

    in case you changed your mind. here the link for FRX with AA addin.

    https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYVLXUZLWUKKQPOVRVULOXPRTRMMOQOKXWKVSRRVQUPQZTULMQNPMKKWNWVPNKSTVRNXMWLSZZKSXZORXM

     and FAQ for this product

    https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYVLXUZLWUKKQPOVRVRWTYSPPSXNYOXYLZSXNZYMPUXXQKRUUTSSKOYKQWNTOWRQNNMPPRUQMUTXPSUNLQ

      

     

  • K Day Profile Picture
    K Day 7,365 on at
    Re: Re: Analytical Accounting Reports SSRS

    I'm pretty sure that it first finding the proper install package, then it was the install, and then it was not having any idea where to start with bringing in AA Dimensions.  So as you can see I had multiple problems.

    I also remember that you had to configure your AA setup a certain way or FRx wouldn't read the data properly; something about a maximum length of the dimension codes, or maybe it was no spaces in the names.  Anyway, I think I am still going to the SSRS route so I can learn the table structure.  After further inspection, it looks like the views that come with GP are not what I am looking for.  There are quite a few that are for the budgeting part of AA which we don't use.

    Kevin

  • Sunbeam De Jesus Profile Picture
    Sunbeam De Jesus 3,930 on at
    Re: Analytical Accounting Reports SSRS

    Hi,

    I have used Frx with AA before, may I know which part that didnt work for you? is it the installation? downloading of the installer? or the report itself?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans