Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Report Writing issue, ...
Microsoft Dynamics GP (Archived)

Report Writing issue, layout of income statement report

(0) ShareShare
ReportReport
Posted on by MATT G NATIONWIDE 1,270

I have experience with report writing but this is my first attempt at managing the report layout in Dynamics GP13 (as I'm in the middle of an upgrade). I created financial statements using the Quick Financials setup feature and then filled in the criteria within Financial Statements.  When I run my income statement I notice the rows have 'mixed' balance sheet and income statement accounts and rollups. Is this normal?  Or do I have another step by specing the layout within "Advanced Financial'?

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: Report Writing issue, layout of income statement report

    Just tossing my two cents in here, AFA has been with GP since version 1. Given it limitations, FRx was adapted to used with GP as well as dozens of other programs. It became the de facto standard. Now along comes Management Reporter(MR) which is just FRx with a SQL back-end. Less than 1% of our clients use AFA. It would be in your best interest to begin looking into MR 2012 or something like BI 360 which is an Excel based on. Either of these will allow you to create consolidated reports which can include budgets in a way that AFA just can not. AFA should not be behaving the way you are describing. However, without being able to see the layouts I would only be guessing what the true problem is.

  • Suggested answer
    Redbeard Profile Picture
    Redbeard 12,931 on at
    RE: Report Writing issue, layout of income statement report

    Matt,

    Mahmoud's suggestion above should not be taken lightly.   The Management Reporter product, which is licensed to Dynamics GP customers is the most broadly used tool for Financial Statement Preparation with the exception of FRx - the tool it was intended to replace.   I would strongly recommend taking the opportunity provided by this upgrade process and the problems you have encountered to transition to this tool.

    There are many more resources available to support the deployment of Management Reporter than you will likely find for AFA.

  • MATT G NATIONWIDE Profile Picture
    MATT G NATIONWIDE 1,270 on at
    RE: Report Writing issue, layout of income statement report

    My question hasn't been answered.  Leslie I provided you the details via your email so you could help me troubleshoot my issues in GP.  I also sent you a private message on the topic.

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Report Writing issue, layout of income statement report

    Matt,

    If I'm understanding correctly, the original Account Categories are still the original names. Also the account categories are assigned to accounts that make sense. You don't have any balance sheet accounts misclassified as income statement accounts.

    I could probably be better help if I could see the AFA Layout of the report in question, as well as a screenshot of the report options window form where you print the report. You can send the screenshots to my email address leslievail@earthlink.net.  My spam blocker will send you a message with instructions on how to get unblocked. It's easy, you just click a hyperlink and it sends me a message.

    AFA is normally very well behaved. I don't think they've made any changes to it since the added the accelerator

    Kind regards,

    Leslie

  • MATT G NATIONWIDE Profile Picture
    MATT G NATIONWIDE 1,270 on at
    RE: Report Writing issue, layout of income statement report

    Leslie,

    Thank you for responding to my post! I agree! I was expecting the layout of the Income Statement to match that of account categories as defined within GP.  The short answer is we have not used the canned chart of accounts and categories.  In fact we have used a customized set of accounts which have been grouped according to the look and feel of our income statement.  This being said, the income statement report has only defined income statement accounts, yet the layout of the report has mixed many balance sheet accounts.  Odd!  I double checked the groupings within the account definition and they appear to be grouped/classified appropriately.  Any help would be appreciated!

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Report Writing issue, layout of income statement report

    Hi Matt,

    This is not normal. AFA uses the Account Category numbers to determine where to place the accounts (unless overridden). Have the Categories been used according to their original definitions?  I would look at the AFA layout and see how it has been entered. I've worked with AFA a lot and am happy to assist you if I can.

    Kind regards,

    Leslie

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Report Writing issue, layout of income statement report

    Apart from your inquiry, why don't you invest in Management Reporter for your financial reporting ? It just can not be compared to the advanced financial which has become; for me at least, old fashioned.

    Management Reported is an Excel-based reporting tool which is quite easy and flexible to handle and customize, add logos, change layout and much more, which can all be done in a blink of an eye.

    Your feedback is highly appreciated, 

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans