PSTL Account Modifier/Combiner

(0) Share

Report

Posted on by Community Member

Getting through all the account modifications ok, but account combiner converts NOTHING!! See many other people are frustrated with this "free" tool as well - should have stuck with Changer!

I get an error after it asks if you want to combine & I say yes:

Unhandled script exception:

[Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'xx.dbo.taGLModifyAccount'.

That SP is not out there anywhere and I don't know where to get it. Any help would be much appreciated!!

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (0)

Sort by

Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

taGLModifyAccount stored procedure is encrypted.

Do a clean install, you will be fine. account combined is fantastic!

Cheers!

Sanjay

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I just did the install yesterday??? Everything appears to run even with the unfound sp - the report SAYS it has combined all the accounts, yet when I pull up any of the old ones (which really shouldn't be there in the first place), it still has all the transactions in it and the new one has none of the ones from the "old" acct.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Sorry - I'm just frustrated from working on this all day... I tried to print the screen so you can see that my sp list goes from the taGetUPRNextPayAdj... to taGLTransactionHeader... I just deleted the dic & took the info out of the set file & copied the cnk in to Include New Code, but still no sp taGLModifyAccount. It didn't run through anything when I launched the PSTL like recreating tables or anything...

Was this reply helpful? Yes No
Suggested answer

Olaf Laos 1,890 on at

Like (0)

Report
Copy link

Link copied!

I presume you are logged in as the "sa" user when you are working with PSTL?

When you installed PSTL within a given Dynamics company, and first opened the "Professional Services Tools Library" window, did it go through a sequence of building functions etc before it opened the window and presented you with the registration code window?

After that process sequence, you should see taGLModifyAccount in SQL Management Studio under Programmability> Stored Procedures for that company database.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

If you don't have the SP at the company database, the install would not have completed correctly. what is that xx in 'xx.dbo.taGLModifyAccount' ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I just hit Register in the PSTL window & said OK on the reg key & it rebuilt the SPs, so it is in there now & ran successfully!! Thanks for pointing me in the right direction & for your time & prompt response to me!!! I'm relieved that my testing is done & I can go live now! :)

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Glad you made it.

Cheers!

Sanjay

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Unhandled script exception:

[Microsoft][SQL Server Native Client 10.0][SQL Server]Could not find stored procedure 'COBA2.dbo.smCreateCompanyDeleteButtonCHG'.

EXCEPTION_CLASS_SCRIPT_MISSING

SCRIPT_CMD_CALLSERVER

please help i did create new company with name test2, but when i did delete db at sql studio management with name COBA2.

i'm really wanna remove 'COMPANY COBA' FROM LIST LOGIN,

please give me solution for this.

what i already did for fix it is :

Create manual db sql on MANAGEMENT STUDIO WITH NAME COBA2,

Need Help please

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report
Copy link

Link copied!

To remove a company from the company drop down list, you need follow certain steps. Please have a look on the below links.

support.microsoft.com/.../855361

support.microsoft.com/.../849249

Hope this helps!!!

Was this reply helpful? Yes No
Amit Thakkar on at

Like (0)

Report
Copy link

Link copied!

HI I am working GP2013 and using PSTL version 12.0.1644 but there is no registration key.

When I click on 'Rebuild proc button on PSTL than it gives error message 'DBNAME.taGLModifyAccount' could not find stored procedure.

Any idea ?

Thanks

Amit

Was this reply helpful? Yes No