News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) run-time error 9; Subs...

Microsoft Dynamics GP (Archived)

run-time error 9; Subscript out of range

(0) Share

Report

Report

Posted on by Community Member

Hi, I am trying to generate a report in Report Launcher but keep getting these errors. If I login as a SA it works fine, but not as a user.

8900- FRX is unable to open a connection to GL database because the login or pwd is incorrect. Verify and try again.

91 - object variable or with block variable not set

3704 - operation is not allowed when the object is closed.

OR

Run - time error '9' - Subscript out of lunch

Brett Johnson access error

*This post is locked for comments

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

soma 24,410 on at

Like (0)

Report

RE: run-time error 9; Subscript out of range

Jake is correct. Have you checked the user permission in GP for all companies if the report contains tree? or check the user permission for appropriate company in GP?

Hope this helps!!!
Suggested answer

Community Member on at

Like (0)

Report

RE: run-time error 9; Subscript out of range

Hi,

Please find the below community forum link that may fix the above case

community.dynamics.com/.../165132.aspx
Community Member on at

Like (1)

Report

RE: run-time error 9; Subscript out of range

This issue occurs if the user does not have access to all companies in GP that are included with the FRx report. If the report is not using a tree, the user only needs access to the company selected in the catalog. If the report is using a tree, the user will need access to all of the companies in the tree.

Helpful resources

News and Announcements

Check out the New Agent Creator Community

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans