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
Run GRANT.SQL against your company database using SSMS. You will find this in C:\Microsoft Dynamics\GP 2016\SQL\Utils
Richard,
I run the GRANT.SQL but still facing same issue during print the report. And other companies are printing fine same report.
You ran the script against the 'GC' database? If you log into GC as 'sa' does the report print?
I run the script against "GCTEST" database and I log into as "sa" but still on same error.
And report is not printing on both Database "GC" and "GCTEST".
Look in the GC and GCTEST databases and see if the SOP10105 table exists in those databases. Since GP database names are limited to 5 characters is the correct name GCTST?
Yes SOP10105 exist in both databases and correct name is GCTES.
Can anyone print invoices in this database? What happens if you log into SSMS and issue this query:
SELECT * FROM SOP10105 in either company
Is DYNSA the owner of these databases? Trying running this
GRANT SELECT,UPDATE,INSERT,DELETE on SOP10105 to DYNGRP does this complete successfully? Can you print invoices now?
NO one can print the invoice in this DB. and when I run SELECT * FROM SOP10105 in company I can see data in table and DYNSA is the owner of databases. And when I run the GRANT SELECT,UPDATE,INSERT,DELETE on SOP10105 to DYNGRP then I am able to print the report on only server but at client site still same error occur.
Richard, I thing there is problem with SOP format because when I select default report from alternative modified report it is printing fine but when I select modified SOP invoice it is getting error. Now its getting same error on server.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 1,922
André Arnaud de Cal... 835 Super User 2025 Season 2
