Error Accessing SQL Data When Printing An Invoice

(0) Share

Report

Posted on by Jeff Garrison

2,485

Hello all -

I am still running GP 9 and when I do a Transaction Inquiry By Document Number and select the Document and click on the Document Number, it shows the items, Subtotal, Tax, etc. When I go to print it, it will come back with an error stating "Error Accessing SQL Data". I ran the Check Links and it still comes back with the same error.

I copied the Reports.dic from the old server, which is at the same SP.

Any ideas?

Thanks.

Jeff

*This post is locked for comments

All responses (2)

Answers (0)

Jeff Garrison 2,485 on at

Like (0)

Report

Re: Error Accessing SQL Data When Printing An Invoice

Not a modified report. I was getting the error logged in as 'sa'. Weird thing was, when I added Tax Detail Summary, it printed, which is not the way we had done it before.
Richard Wheeler 75,730 on at

Like (0)

Report

Re: Error Accessing SQL Data When Printing An Invoice

Step 1) Is this a modified report? If so, try reverting to non-modified version If error remains, try running the GRANT;SQL script. If error goes away, go into RW and delete this form and insert it right back in. Hopefully you know what the modifications(s) was and recreate modifications.

Step 2) Log in as 'sa' and see if you get the same error message. If you do not, it is a security issue and runnng GRANT.SQL will fix this. If error remains follow Step 1 to drop and re-insert the report back into RW.