Merging two company databases

I have one company split between two databases, payroll on one, and the daily entries on the other. It's been this way for many years until our controller, who handled payroll & taxes had recently passed. Our accountant has adjusted one DB to reflect our last fiscal year end, which I will be running on solely once I've closed the current year. Since I'm transferring payroll to a separate database manually, I'm worried of the lack of history there will be and that I will need to go between DB's when doing ROE's or other reports. Does it matter if I enter year to date amounts or is manually re-entering all payroll detail best? I would love to hear from someone that has gone through a similar situation. Any tips would be very helpful.

Parents
  • 0

    I don't know if this can be done but if it can then Tony Martin at Code 6 Programming would be the one I would turn to for help. I suspect that the database would have to both be from the same version of Sage 50.

  • 0 in reply to Alwyn

    Yes, both DB's are the same version & on the same computer in fact (separate databases & users). However, since I've never handled the payroll etc, I feel I'm in way over my head. Thus far, I've manually entered the payroll beginning Jan 2015 to date (fiscal YE is May 31st). Of course the only way to do it was to re-enter each cheque individually in the paycheque module in order to adjust tax amounts manually.

Reply
  • 0 in reply to Alwyn

    Yes, both DB's are the same version & on the same computer in fact (separate databases & users). However, since I've never handled the payroll etc, I feel I'm in way over my head. Thus far, I've manually entered the payroll beginning Jan 2015 to date (fiscal YE is May 31st). Of course the only way to do it was to re-enter each cheque individually in the paycheque module in order to adjust tax amounts manually.

Children