Share
ReportDear Community,
I am facing Runtime error after upgrading to GP2016 R2 during SOP invoice printing can anyone help me to resolve this error:
Thanks
Categories:
You’re offline. This is a read only version of the page.
385
Dear Community,
I am facing Runtime error after upgrading to GP2016 R2 during SOP invoice printing can anyone help me to resolve this error:
Thanks
and there was much rejoicing!!! I knew that had to be something unique about this report in this company.
You have a custom connection string in your VBA code for this report. Grant the proper rights to user 'rpt' and this report will work in your GC company. See what rights this user has in other companies and compare.
Public Function ConnectionString() As ADODB.Connection
If Connection Is Nothing Then
Set Connection = New ADODB.Connection
End If
With Connection
.Provider = "SQLOLEDB"
.Properties("Data Source").Value = "ERPSERVER\SQL2014"
.Properties("Initial Catalog").Value = UserInfoGet.IntercompanyID
.Properties("User ID").Value = "rpt"
.Properties("Password").Value = "Wel$$$"
.Open
End With
Set ConnectionString = Connection
End Function
I have the file and will take a look at it.
I do not see the email. You can attach the package file to the email.
I am officially out of ideas on this one. Hopefully someone from Microsoft can chime in here. If logging in as 'sa' gives the same results then it is not a security issue. You can run this report on all other companies with no issues so there is nothing wrong with the report. Using the primary version of the reports works. It is only when you make modifications. What modifications are you making? Can you attach a package file of your SOP Blank Invoice form?
#1
André Arnaud de Cal...
291,735
Super User 2024 Season 2
#2
Martin Dráb
230,466
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
