Question Status

Suggested Answer
D. Reiter asked a question on 23 May 2013 1:47 PM

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.

Reply
Suggested Answer
William Weightman responded on 23 May 2013 1:58 PM

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

Regards,
William Weightman

Professional Advantage
Web: www.profad.com
Visit our blog for more tips and tricks:
Reply
Suggested Answer
Frank Hamelly responded on 23 May 2013 7:32 PM

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.

** Please, if this answers your question, mark it as 'Answered' so others experiencing the same will know it resolved your issue. **

Frank E. Hamelly, MCP-GP, MCP-AX, MCITP, MCT, MVP

http://gp2themax.blogspot.com/

Reply
Suggested Answer
Leslie Vail responded on 23 May 2013 8:11 PM

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

Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITS
ASCI, Inc.    *    PO Box 600965   *   Dallas, TX 75360    *   972-814-8550   *   leslievail@earthlink.net

Reply
Suggested Answer
William Weightman responded on 23 May 2013 1:58 PM

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

Regards,
William Weightman

Professional Advantage
Web: www.profad.com
Visit our blog for more tips and tricks:
Reply
Suggested Answer
Frank Hamelly responded on 23 May 2013 7:32 PM

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.

** Please, if this answers your question, mark it as 'Answered' so others experiencing the same will know it resolved your issue. **

Frank E. Hamelly, MCP-GP, MCP-AX, MCITP, MCT, MVP

http://gp2themax.blogspot.com/

Reply
Suggested Answer
Leslie Vail responded on 23 May 2013 8:11 PM

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

Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITS
ASCI, Inc.    *    PO Box 600965   *   Dallas, TX 75360    *   972-814-8550   *   leslievail@earthlink.net

Reply