Question Status

Suggested Answer
mjackson asked a question on 7 Apr 2011 11:04 AM

There is a report in AR -> Reports -> External -> Customer Account Statement

When I run this report as an Admin, for a specific customer, I get a report generated as expected.  When I run it as one of our AR Manager users (who have been given Full Control over the entire AR security tree), I get "Report is empty".

Obviously, some kind of security access is missing for these users, but I have not been able to figure out what it is after searching for hours.  Given that the report prompt actually displays, I know it isn't a security setting for the report itself, but must somehow be related to data which that report is trying to access.  Setting Full Control and Cascade on the Account Statement security key does nothing to help.

Can anyone give me any pointers?  How do I figure out where this security is breaking down?

Thanks!

- Matt

Reply
Suggested Answer
Kent Carstens responded on 7 Apr 2011 11:31 AM

Hi Jackson,

In the user group permissions form, under:  (Viewing: Security) AR > reports > Customer account statement (report) & Customer account statement (tmp table)

Can you confirm that the report has view access and the tmp table has full control access?

Reply
mjackson responded on 8 Apr 2011 5:01 AM

Yes, the group has both of those access settings.  Still getting the "Report is Empty" message for those users, but not for Admins.

In further testing, I have gotten the report to work for a test user by giving them Full Control over BOTH AR and GL.  When I take GL away, it stops working.  So it would seem that some part of the data for the report needs to come from that area, but I have had no luck in figuring out what that may be.  Giving full control over GL to the AR users is not an option.

Reply
Suggested Answer
Kent Carstens responded on 8 Apr 2011 1:28 PM

Hi Jackson,

It seems weird that you are not getting a "Not enough access..." error when you run the report and are instead getting report is empty.

This sounds silly but please make sure that the user tests in the same company you are testing in.

Also, take away all GL permissions except for table permissions.  You should have those two keys open that i mentioned above.  If it works with those two keys and GL permissions at least you have it narrowed down to a table problem.

I took just a few minutes to look at the class that drives this report and it uses a bunch of different tables but tables used in a class ignore permissions all together.

Reply
Andrew W Ford responded on 8 Apr 2011 4:04 PM

There are probably some General Ledger and Bank tables invoked in this report.  Adding read access to all the tables under GL, Bank and A/R may resolve your issues.  If they persist, try Basic/Tables and Admin/Tables.

Reply
Sudhesh responded on 27 Sep 2012 1:43 AM

I am also facing the same issue! I have tried all the suggested steps but still no go.Now the only step left is to give full access Customer account statement (tmp table) but not able to find this table.

Need help!

Reply
Chris Gray responded on 23 Jan 2013 1:29 PM

Did you ever resolve this? Having the exact same issue. Very frustrating!

Reply
Kyle S LeBarre responded on 24 Jan 2013 7:51 AM

I'd recommend running the report under admin while doing a sql trace. Figure out the tables you need access to, and then make sure that those groups have access to those tables.

There's also the AX2009 security profiler which sounds like it does this work for you, but I haven't tried it out yet.

blogs.msdn.com/.../ax-2009-securityprofiler-tool.aspx

Reply
Chris Gray responded on 24 Jan 2013 12:23 PM

The security profiler is hit and miss really. I do have it installed, but it isn't giving me any additional info on this report.

I will give a sql trace a try. Thanks for the suggestion.

Reply
Paul Picard responded on 28 Feb 2013 7:06 AM

I just ran into the same problem.  For me I needed to grant View access to:  GL->Miscellaneous->Transaction reversal on the "User group permissions" form

Reply
Suggested Answer
Kent Carstens responded on 7 Apr 2011 11:31 AM

Hi Jackson,

In the user group permissions form, under:  (Viewing: Security) AR > reports > Customer account statement (report) & Customer account statement (tmp table)

Can you confirm that the report has view access and the tmp table has full control access?

Reply
Suggested Answer
Kent Carstens responded on 8 Apr 2011 1:28 PM

Hi Jackson,

It seems weird that you are not getting a "Not enough access..." error when you run the report and are instead getting report is empty.

This sounds silly but please make sure that the user tests in the same company you are testing in.

Also, take away all GL permissions except for table permissions.  You should have those two keys open that i mentioned above.  If it works with those two keys and GL permissions at least you have it narrowed down to a table problem.

I took just a few minutes to look at the class that drives this report and it uses a bunch of different tables but tables used in a class ignore permissions all together.

Reply