New Company on MDGP V.10 - PSTL Error

(0) Share

Report

Posted on by Shaghig Adanalian

I created a new company on Microsoft Dynamics GP V.10. The database name is "GSYS". When trying to modify the customers’ accounts on the company that I created using the Professional Tools, I got the following error: "Unhandled script exception: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'GSYS.dbo.smCustomerChanger1'. EXCEPTION_CLASS_SCRIPT_MISSING SCRIPT_CMD_CALLSERVER". Please advise noting that the Professional Tools is working fine on another company previously created on the same location..Thank you in advance..

*This post is locked for comments

All responses (2)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

Re: New Company on MDGP V.10 - PSTL Error

This looks like a SQL Stored Procedure, which is supposed to be there on GSYS, is not there yet. You may probably have to create this procedure. If you are not into SQL, I would suggest to get some help from a GP Technical Consultant.

The solution is simple: The stored procedure *smCustomerChanger1* must be scripted from any of the existing companies and then create that in the new company, i.e. GSYS. I believe, it would solve the above error, but may throw some other error of same kind.

I assume, the SQL objects for Professional Tools were not properly got created on GSYS company.
sandipdjadhav 18,267 on at

Like (0)

Report

Re: New Company on MDGP V.10 - PSTL Error

FYI. May be helpful!!!

www.cetix.de/.../Thread5986-Professional_Tools_-_Customer_Modifier_Error.aspx

Thanks

Sandip