Updating Payroll for Previous Year

Problem

Windows payroll-- when updating payroll report from previous year, updates to CURRENT year by mistake.
1993 files update to 1994 company pay file

This only happens when they are going back to the previous year and "catching up" on payroll with MacNail construction payroll software.

Diagnosis

when updating payroll from 1993 during 94, it erroneously makes a 94 company payroll file. This was an early bug that apparently was fixed on the Macintosh but not Windows.

Solution

To fix it, cell H53 should replace TEXT(now(),"yyyy") with the.pay.year so it ends up as:
=SET.NAME("co.pay",the.pay.year&".CPR")

Comments

Entered 1/11/94 by Dennis. Updated 11/23/2010.