Microsoft Dynamics GP (Archived)

AR Historical Aged Trial Balance - in SSRS

(0) Share

Report

Posted on by Alaa Ramadan

4,130

Hi friends,

Has anyone ever used the AR Historical Aged Trial Balance in SSRS

Is not it suppose to return the same result as the one in GP - report writer

For some reason I does not return all customers, I had a hard time trying to figure out this

Here is a specific example in Fabrikam: the customer WORLDENT0001 show in GP- RM Historical Aged trial balance but not showing in the same Historical Aged Trial Balance in SSRS

any help truly appreciated

Alaa

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Alaa,

Did you ever get this resolved?

Elsa

Was this reply helpful? Yes No
Suggested answer

Richard Whaley 25,195 on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately, many of the SSRS canned reports do not currently return the same totals as the GP reports. You have to edit the SSRS report itself to make sure it works as expected.

Was this reply helpful? Yes No
Vijayakumar Kenchug... 1,077 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Rich,

How to edit SSRS reports to tally to GP report writer report?

Thanks

Vijay

Was this reply helpful? Yes No
Suggested answer

Redbeard 12,931 on at

Like
a
(0)

Report
Copy link

Link copied!

Vijay,

Here is a good place to Start. Victoria Yudin has a number of vetted queries, which you can use to sort through the issues you're having.

victoriayudin.com/gp-reports

Was this reply helpful? Yes No
Vijayakumar Kenchug... 1,077 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

The sql queries are only for current aging balances. I need aging for historical dates. I would like to know whether Microsoft has resolved this difference in balances between SSRS and GP report.

Thanks

Vijay

Was this reply helpful? Yes No
Dean Marty Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Regarding the original posting - Testing WORLDENT0001 on a GP2013 build matches RW and SSRS reports.

There have been a few Quality Reports written over the years regarding some SSRS reports not matching the Report Writer versions. If you are seeing differences, you may wish to open a Support Incident for further investigation.

Thanks!

----------------------

Dean

Partner Online Technical Community

-----------------------------------------------------------------------------------------

We hope you get value from our new forums platform!

Tell us what you think:

social.microsoft.com/.../threads

------------------------------------------------------------------------------------------

This posting is provided "AS IS" with no warranties,

and confers no rights.

-----------------------

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

Were you able to resolve this issue? I am current experiencing the same problem.

Thank you!

Sam

Was this reply helpful? Yes No