Microsoft Dynamics GP (Archived)

I need some help running the following reports in GP

(0) Share

Report

Posted on by Mian Sufian

I need some help running the following reports in GP:

1. Income Statement as of 12/31/2012 for the 12 month

2. Balance Sheet as of 12/31/2012

3. Cumulative General Ledger for 2012

4. Trial Balance as of 12/31/2011 (Summary-Totals only)

5. Trial Balance as of 12./31/2012 (Summary- Totals only)

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

L Vail 65,271 on at

Like (0)

Report

Hi Mian,

These seem like standard out-of-the-box reports. What kind of help do you need?

Kind regards,

Leslie

Was this reply helpful? Yes No
Mian Sufian on at

Like (0)

Report

Thanks Lisa. Actually I want to print out these reports in hard form. I am new in Dynamics GP. I have found the option to print the trial balance.

Here are the 3 reports, I want it be printed on hard form and I want help from where I can print these reports.

1. Income Statement as of 12/31/2012 for the 12 month

2. Balance Sheet as of 12/31/2012

3. Cumulative General Ledger for 2012

Was this reply helpful? Yes No
Imad Kassoumah 3,235 on at

Like (0)

Report

Hi,

It's better to work either with Frx or Dynamics Management Reporter. Both software are more flexible. Management Reporter is now the standard for Dynamics GP.

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (0)

Report
Hi Mian,

The first two reports are normally printed from a Financial Reporter such as FRx or Management Reporter. Depending on the version you have, one of those report writers came with the software. There is, however, a rather archaic financial reporter within Dynamics GP. It's called Advanced Financial Analysis, AFA for short. In the early years of Dynamics, this was the only tool available (that, and Crystal Reports). OK, enough with the history lesson.

To come up with some quick and dirty - and NOT pretty - financial statements, try the following:

FOR AN INCOME STATEMENT

Navigate to: Financials | Reports | Quick Financials

Select the kind of report, but do Profit and Loss first.

Choose which columns you want to print and indicate an open year.

Save the report.

FOR A BALANCE SHEET

Navigate to: Financials | Reports | Financials | Quick Financials

This time, select Balance Sheet as the report type. Identify the Profit and Loss Statement you just created as the Net Income/Loss Source

Choose which columns you want to print and indicate an open year.

Save the report.

THE NEXT STEP IS TO CREATE REPORT OPTIONS

Navigate to: Financials | Reports | Financials | Financial Statements

Select the Modify button to open the Financial Statement Reports Options window.

Make whatever selections are desirable and then save the report option

Do the same thing for your Balance Sheet report.

PRINTING THE FINANCIAL STATEMENTS

You print these financial statements much like you do any other report. Select the option you want to print and his the print button.

But Waite! In order to get AFA to choose the correct date, you need to change the user date to the date you want on the report. For instance, if you want the Balance Sheet to be as of 12/31/12, you need to change the User Date to 12/31/13

Create report options for this report like you did for the balance sheet and print.

The AFA reports depend on the account category assigned to each account in the Account Maintenance window. The system doesn’t care what the account is. If you have included the Retained Earnings account in the cash category, it’s going to print as the first asset on the balance sheet.

I do not know what you mean when you say you want to print a “Cumulative General Ledger for 2012”. Have you looked at the Detailed or Summary Trial Balance report? Can you describe what the report should look like?

Kind regards,

Leslie

Was this reply helpful? Yes No
Mian Sufian on at

Like (0)

Report

Hi Leslie

Thanks, it’s really a very much useful information for me I really appreciate your quick response and the way you have been helping me. Actually I have few more questions

In above exhibit I have copied the existing balance sheet report and rename it with Balance Sheet 2012. But now my question is this how I can select the correct values for the year 2012? What will be the correct option that suits my scenario, like I need balance sheet as of 12-31-2012. I need help om both C2 and C3 columns values.

Thanks

Mian Sufian

Was this reply helpful? Yes No
Mian Sufian on at

Like (0)

Report

Hi Leslie

Thanks, it’s really a very much useful information for me I really appreciate your quick response and the way you have been helping me. Actually I have few more questions

In above exhibit I have copied the existing balance sheet report and rename it with Balance Sheet 2012. But now my question is this how I can select the correct values for the year 2012? What will be the correct option that suits my scenario, like I need balance sheet as of 12-31-2012. I need help om both C2 and C3 columns values.

Thanks

Mian Sufian

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Hi Mian,

I'm using a tablet tonight and cannot see the pictures. I'll be at a bigger monitor tomorrow and will take a look at your question.

Kind regards,

Leslie

Was this reply helpful? Yes No