How to run Microsoft Dynamics GP

(0) Share

Report

Posted on by KimberlyBlanding

Hi all,

I'm new to using GP as a system and my auditors are asking for a report same as last year. The report title is A/R Ageing Summary and it is in excel. OneCognizant App

None of my staff know how the previous controller ran this report and I'm at a loss searching the internet; everything I run is unusable in excel and only available in PDF.

preview.redd.it/rmq36fz2pou71.png

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Community Member on at

Like (0)

Report
Copy link

Link copied!

Use the information in this chapter to log in to Dynamics GP for the first time and register Dynamics GP. You also may have to grant user access to alternate Dynamics GP windows and reports.

greatpeople

Was this reply helpful? Yes No
Richard Wheeler 75,852 Moderator on at

Like (0)

Report
Copy link

Link copied!

You are talking about Reports->Sales->Trial Balance->Aged Trial Balance with Options and click the summary box. You will also find this using SSRS which I would assume is on your server. That version will dump data directly to Excel. Ask your IT staff about running SSRS reports.

Was this reply helpful? Yes No
Joseph Markovich 4,007 on at

Like (0)

Report
Copy link

Link copied!

Hi Kimberly-

There is a way to export the Trial Balance reports to Excel, but it is CSV and it is awful. You have to go back and do a lot of formatting and deleting and moving around.

If you do have a SQL Server Reporting Services report server set up at your company, I can also give you a nicely formatted report that will export to Excel. Let me know and I can send it over to you!

You also could get this information in SmartList. Sales > Customers. Your aging period columns are available to select along with current balance. This can get exported to Excel too.

Thank you.

Joe

Was this reply helpful? Yes No