Error when running "Payroll - Canada>>Year End File Reset"

[Smirnoff2006]

Hi all,

I got "A get/change last operation on table 'P_CPY_MSTR_LY' failed accessing SQL data." when i ran Payroll - Canada>>Year End File Reset after installation of 2005 Canadian Payroll Year-End Update.

Thanks
Smirnoff

 

[jazgeek]

are you logged in as SA?

-----------
and they wonder why they call it Great Pains!

jaz

 

[Smirnoff2006]

Yes I'm logged as sa.

Do we need to run any scripts in tasklist?

 

[barbola]

I also got this error, and just clicked past it and everything worked out fine. After the update was completed, I had to run Grant.sql and our vendor also gave me a couple of other sql scripts to run.

One was for the tax exemption amounts that weren't being updated properly. Please check your TD1 amounts to make sure they updated properly.

 

[Smirnoff2006]

I ran grant70.sql against company database but i still have the error.

FYI, I did Great Plains 7.5 SP7 before i updated 2005 Canadian Payroll Year-End Update.

I followed instructions that came with this update and there was no errors.

After the process finished, i wanted to check if the updates took place and that error appeared.

 

[barbola]

Yes I also had to install SP7 and it was fine. So, even after running grant70.sql you still get the error? I know we have a user who gets asked for a password when running Detail Range Reports on LY. You can check the permissions I suppose, but Grant70.sql should take care of this.

Is there a way you can do a spot check in SQL on the historical tables? (CPY50100).

Did you ask your vendor?

Here are the scripts I was emailed by our vendor:
---------------------------------------------------
/* Microsoft Dynamics - GP Canadian Payroll Tax Credit 2006
Set Quebec Employee Tax Credits for 2006 in the CPY10100.
*/

update CPY10100 set PQuebecMR19Base=9555.00 where PTaxableProvince = 'QC' and PQuebecMR19Base in (9330.00, 9610.00)


update CPY10100 set PQuebecMR19Line12=9555.00 where PTaxableProvince = 'QC' and PQuebecMR19Base in (9330.00, 9610.00)
--------------------------------------------------------

/* Microsoft Dynamics - GP Canadian Payroll Tax Credit 2006
Set CPR Employee Tax Credits for 2006 in the CPY10105.
*/
/* update Federal tax credits */
update CPY10105 set PBasicPersonalAmount=9039.00 where PJurisdiction = 'CA' and PBasicPersonalAmount in (8148.00, 8327.00)


update CPY10105 set PSpousalAmount=7675.00 where PJurisdiction = 'CA' and PSpousalAmount in (6919.00, 7071.00)


update CPY10105 set PEquToMarriedAmt=7675.00 where PJurisdiction = 'CA' and PEquToMarriedAmt in (6919.00, 7071.00)


update CPY10105 set PAgeAmount=4066.00 where PJurisdiction = 'CA' and PAgeAmount=3979.00


update CPY10105 set PDisabilityAmount=6741.00 where PJurisdiction = 'CA' and PDisabilityAmount=6596.00


update CPY10105 set PCaregiverAmount=3933.00 where PJurisdiction = 'CA' and PCaregiverAmount=3848.00


update CPY10105 set PDisabledDependantAmt=3933.00 where PJurisdiction = 'CA' and PDisabledDependantAmt=3848.00


/* update Manitoba tax credit */
Update CPY10105 set PBasicPersonalAmount=7734.00 where PJurisdiction='MB' and PBasicPersonalAmount in (7634.00, 7734.00)

--------------------------------------------------------
--Grant70.sql

/*Count : 1 */

declare @cStatement varchar(255)

declare G_cursor CURSOR for select 'grant select,update,insert,delete on [' + convert(varchar(64),name) + '] to DYNGRP' from sysobjects
where (type = 'U' or type = 'V') and uid = 1

set nocount on
OPEN G_cursor
FETCH NEXT FROM G_cursor INTO @cStatement
WHILE (@@FETCH_STATUS <> -1)
begin
EXEC (@cStatement)
FETCH NEXT FROM G_cursor INTO @cStatement
end
DEALLOCATE G_cursor

declare G_cursor CURSOR for select 'grant execute on [' + convert(varchar(64),name) + '] to DYNGRP' from sysobjects
where type = 'P'

set nocount on
OPEN G_cursor
FETCH NEXT FROM G_cursor INTO @cStatement
WHILE (@@FETCH_STATUS <> -1)
begin
EXEC (@cStatement)
FETCH NEXT FROM G_cursor INTO @cStatement
end
DEALLOCATE G_cursor
----------------------------------------------------------

 

[Smirnoff2006]

Sorry for delay.

Q: Is there a way you can do a spot check in SQL on the historical tables? (CPY50100).

A: All i see in this table is informations about our employees.

Qid you ask your vendor?
A: the vendor said to run grant70.sql against the company database.

The following is what i did yesterday but it did not fix the problem.

I did a database restoration and then reinstallation of SP7 and Canadian
Payroll. Results are the same errors.

Do i need to run all the scripts just after SP7 installation or after
Canadian Payroll?

Do i need to click on YES to update new code after SP7 installation?

Thanks

 

[barbola]

You need to include the new code for SP7 first and then log out and then install the payroll update.

 

[Smirnoff2006]

This is what i did.

I opened a case with M$ and I'm wainting for their call.

Thanks

 

[barbola]

I meant to check CPY50100 to see if records were showing for the year 2005. This would mean that your files were transferred to history.