Default Pay Rate Table in Payroll

SUGGESTED

For the past 10+ years, we've used the same pay rate table in payroll, making changes to certified classes and wage rates as required. The table allows you to input job, certified class, certified?, pay rate, base rate.

For reference: I currently import payroll with all of the above information, plus a cost code, category, WC code, WC state, state, units, and date.

We are looking into implementing HH2, and after several conversations with their implementor, they don't have any way to make changes on their end to a category or WC code associated with an entry.

Looking at the pay rate table setup, there is the option to add category and WC code on each line - a little extra work, but I was very hopeful that it would solve my problems.

However, it did not. I get the error (whether manually entering or importing) "The Category set up for this Pay ID is invalid or has not been previously used for the Job that has been entered". It has been used for the job multiple times, so it appears the issue is the Pay ID, which does NOT have a category associated with it in the setup. I am not able to enter the category in the setup because it changes based on job vs. shop labor, regular/overtime.

Any suggestions? I was really hoping a new pay rate table would have solved the issue since I could have entered all the information I needed based on the certified class. Does anyone else use HH2 and also use categories and WC codes and have a solution?

Thanks!

  • 0
    SUGGESTED

    Pay Rate Tables do not "add" information to the imported lines of time, they are simply used to match information from the columns selected and pull the pay rate and fringe rate.

    As for the comments regarding errors and the category and WC Code changing based on job vs shop labor and regular/overtime, I would suggest working with your consultant, because it sounds like the setup you have does not suit your needs.  I have done alot of implementations and re-implementations over the decades of Payroll and have never setup a Labor category other than L.  GL accounts can be retrieved in other ways and still have a category of L assigned to it.

    Not knowing your needs and reasoning behind the setup you currently have, i believe it would be impossible for anybody to help you make internal changes to Timberline.  That being said, you could bring the export from HH2 into excel and write code that could assign whatever data you wish to append based on the conditions you require and export out the resultant dataset for import to Timberline.

    I know that isn't the answer you were looking for, but based on the information provided, its the best answer I can come up with for you.  Good Luck!!

    Cheers,

    John McLagan
    Independent Senior Consultant
    Johnny on the Spot