Copy Payroll from one company to another

[35mph]

We need to copy Payroll from one (old) company to a new company... including employees.

A TK explains to simply copy the Payroll folder from one company to another... then run year-end to clear out YTD and history. Obviously, this relates to the Pervasive database... for SQL Server, do you think it is as simple as copying all the DD and UPR tables... then running year-end in the new company to clear out history and YTD? (I did see a change that will need to be made to UPR41600.) DOes anyone already have a script that will do this?

 

[stef315]

I believe there are some KnowledgeBase articles about which setup tables to copy to just get master record information. You wouldn't need to remove history then.

Running year end doesn't clear out history really.

 

[35mph]

Thanks for the reply... I've seen the TechKnowledge articles you're probably referring to, and they DO define the tables that include MOST of the master file info... just not the employess themselves.... which we need...

 

[stef315]

Look at the UPR00100 file. Also, master record information is normally kept in files that start with 00. You can always look up tables from within Great Plains by going to Tools-Resources-Tables or something like that (don't have the program open in front of me).

 

[35mph]

Thanks, stef315...