web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Errors after CDN Payro...
Microsoft Dynamics GP (Archived)

Errors after CDN Payroll update and Year End Reset

(0) ShareShare
ReportReport
Posted on by Erik Myllymaki 130

I applied the latest CDN Payroll update yesterday and it all went smoothly (after a small initial hiccup due to lingering errors from a previous SP - the errors were not with any of the companies affected by the issue detailed below).

I ran one full backup prior to applying the update and then ran another full backup after applying the update.

I then went into the 5 companies (of 12 total companies) that have payrolls and performed the Year End Reset (I've listed my steps for this below).

When staff went in to perform a payroll, the first one, for the first company that the year end reset was performed on worked just fine. However, the other 4 companies had many errors.

The errors all related to not being able to find tables and stored procedures.

On a backup SQL machine I restored the backup made just after the CDN Payroll service pack was applied and just prior to the Year End procedure of one of the affected companies. The database contained these now-missing tables and SPs at that point. In this particular company, it is missing 16 tables and 180 SPs - from my quick scan they are all CPY, or CDN Payroll related objects.

So the Year End Procedure deleted these objects?!

Any advice greatly appreciated.

*Year End Reset procedure.

In each Company that has payroll:

1.    Update tax tables:
go into the Tools|setup|Payroll Canada|Control window. Click on the Tax credits button (lower left of screen) and update the values with the 2009 tax-year values (Federal = $10100.00, BC = $9373.00, etc.)

2. Tools->Routines->Canadian Payroll->Year-end File Reset

      click "Copy Files to History" and OK and YES your way through the dialogues.

      click "Tax Credit Indexation" and confirm that CA - Canada Federal = 1.0250  (it did in all 5 cases)

      Click "Reset Employee Masters" and OK and YES your way through the dialogues.

3. Bring up an employee card and verify that the TD1 values match those in the tax tables of step 1.
   (They did in all cases).

*This post is locked for comments

I have the same question (0)
  • Erik Myllymaki Profile Picture
    Erik Myllymaki 130 on at

    Here's what I have ended up doing and so far it is allowing staff to calculate payroll:

    I dropped all Auto Procedures in the CDN Payroll product for each of the five companies affected. I then recreated all of the Auto Procedures in those five companies.

    I copied the 16 missing table structures from the one company that is not having any trouble calculating payroll, to the five Companies that are in a loop with this main block (gparc is the company that is OK):

    IF OBJECT_ID('WEST..CPY30164') IS  NULL
begin
select * 
into WEST..CPY30164
from gparc..CPY30164
delete from WEST..CPY30164
grant insert, update, select, delete on WEST..cpy30164 to dyngrp
end

    I checked all these tables and they appear to be just work tables - they are either empty or contain data from the last run payroll. There is a chance that those tables that did have a few records in them from the last run payroll might need to have that data there, I do not know.

    Of course ultimately i would really like to know what could have possibly caused this to happen in the first place.

    On the data partition I was down to ~200MB of free space (it is not he boot partition - it is a separate partition just for sql data; sql logs are on another partition again), but I don' think that would have caused it. I have freed up > 1GB of space now and plan on moving the data partition to a much larger drive in the new year.

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
HP-11021721-0 Profile Picture

HP-11021721-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans