web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Financial Statements in GP 2010

(0) ShareShare
ReportReport
Posted on by 495

Hello,

When creating our financial statements, I export the trial balance and build the financials entirely in excel. I am unfamiliar with GP's capabilities in terms of creating financials within the system. Can you share your knowledge/recommendations? Thank you.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    William W. - Professional Advantage Profile Picture
    on at

    Hello,

    I recommend you copy over the financial statements available from the sample company TWO. Microsoft has an automated solution available to copy the reports from the sample company TWO (Balance Sheet, Profit and Loss, etc.) to another company. You can also use it between your own companies.

    GP 10:

    mbs.microsoft.com/.../automatedsolutionsR10.htm

    Alternatively you can DTS from the sample company to your production company. The tables required are listed in the following article:

    KB 866341            How to troubleshoot the reports in Advanced Financial Analysis in Microsoft Dynamics GP

    support.microsoft.com/.../866341

    Good luck!

    William

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,625 Super User 2025 Season 2 on at

    You need to install and use Management Reporter.  It is part of your GP 2010 licensing and is the defacto tool for creating and distributing financial statements in GP.

  • Suggested answer
    L Vail Profile Picture
    65,271 on at

    Howdy,

    I have yet another suggestion. The reports are ugly, but they're easy, and you don't need to install any additional software. If you have selected the appropriate Account Category on the Account Maintenance window, the accounts will at least show up in the proper financial statement category.

    Follow this navigation to create the financials:

    Financials | Reports | Quick Financials

    This will open the Quick Financial Setup window.

    Name your report (anything you like) and then using the drop-down menu next to Type, select the kind of report you want to create. Your choices are: Profit and Loss, Balance Sheet, Statement of Cash Flows and Statement of Retained Earnings.

    You need to create the Profit and Loss statement first.

    Select any of the Optional Columns you want for your report and choose an open year. You will need to also select a History year if you choose any of the Optional Columns displaying History.

    Save the report ID and close the window.

    To print the report, go to Financials | Reports | Financial Statements

    Select the report ID you just created and print the report just like you would any other report.

    This report is being rendered by the original financial statement module called 'Advanced Financial Analysis' or AFA, which is really not advanced at all, but that's its name. To open AFA and modify the report, go to Financials | Reports | Advanced Financials

    At this point you need to open the manual. Look in your Documentation folder for the document named: 'AdvancedFinancialAnalysis.pdf'

    If nothing else, it will convince you to use either FRx (it still works with GP 2010), or Management Reporter. Unbelievably, I still have clients using AFA, I guess it keeps my AFA skills sharp. Not sure how much that is worth, but hey, somebody needs to do it :)

    Kind regards,

    Leslie

     

     

    To open the

  • Community Member Profile Picture
    on at

    Hi Leslie,

    I have a client attempting to use the standard financial reports in GP 2013 (AFA) fort he first time. However, not all her accounts show up on the report, even though her account categories are setup correctly. Since you have so much experience with this tool (and I don't) I thought I'd ask you how to troubleshoot. Any advice you can provide would be greatly appreciated.

    BTW: I've suggested that they install Management Reporter as that is what all of my other clients use & that's where I am comfortable. Thanks.

  • Suggested answer
    L Vail Profile Picture
    65,271 on at

    Hi,

    The first thing I would do is create a brand new Quick Financial (you have to do the P&L first) and check it. Often, my clients have deleted something on their report and that will identify it in a hurry. Are the accounts 'missing' from the P&L or BS? Do they have any accounts hiding in the 'Non-Financial Accounts' category? Also, copy their report and open the copied report in AFA to troubleshoot. Once you open it in AFA, you can't edit it using Quick Financials.

    Shout back at me and we'll get this mystery solved! I'm determined when it comes to this old stuff - lol.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    on at

    Hi. I am working with a company that is using GP 2013. I used your "quick and dirty" method of reporting. However, they have 17 separate store locations, and this caused quite some confusion when reporting out as it wanted to list them all out separately without naming the locations. The company wants them all lumped together for a much, much smaller report. Do you happen to have any suggestions, pretty please? Thanks in advance! Angie

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans