Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Errors after CDN Payroll update and Year End Reset

(0) ShareShare
ReportReport
Posted on by 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

  • Erik Myllymaki Profile Picture
    Erik Myllymaki 130 on at
    Re: Errors after CDN Payroll update and Year End Reset

    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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,111 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,934 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans