General Consultant Discussion

We have a fast food chain restaurant Sage 100 client with around 200 locations and each one is a separate company. The employees move from 1 location(company) to another frequently. Their HR insurance director needs the number of weeks worked by each employee across companies to determine eligibility. Does anyone know if there is an HR software that interfaces with Sage 100 that would collect this information across company codes?

WOW..... Are you saying each company is a separate legal entity as well?? I set up Abra (er Sager HRMS) a while back for a Pizza Hut with 30 stores. It had that functionality. @ShawnSlavin ??

I've seen this. They set them up separately for protection against slip-and-falls and other liability issues. I think it's common. We used DSD multi-company to pay all the AP from one central company.

Yes, each company is a separate legal entity. We are using DSD's GL consolidation which is very helpful. Jeff, would you have time to discuss options for HRMS?

Unfortunately, I don't do HRMS any more....... Thus the @ShawnSlavin Slavin comment. You might also contact @DanBurleson. He is a wunderkind with Access. With his toolkit, he may be able to consolidate all the companies into one database so you could Query it with Excel, write Crystal to pull the data or even do that in Access. And of course, I would think the same stuff could be done in SQL.

Joe De Maria at DSD is also great at this!!

@JeffSchwenk and @DeniseSawyer - Sorry for the slow response. I am on-site with a customer. @MichelleTaylor1 saw this posting and started an internal conversation within our HRMS team to determine what course of action we would recommend. As you know, using Sage 100c in this environment doesn't facilitate this type of management because the information is spread between 200 databases. Using a system that uses a single database to manage all companies would provide a better alternative. We have several customers using Sage 100 to manage the accounting for multi-company franchise entities. We don't use Sage 100 payroll for any of them for these reasons.

@DeniseSawyer Are they using Sage 100 Payroll module? What are they using for timekeeping?

I have an MS Access tool that combines one or more Sage 100 tables for any or all companies in SY_Company into one or more tables each with an added column for company code. This allows any reporting tool to aggregate or detail P/R data by company. Call me if you would like to discuss. If your data goes beyond the Access 2 GB limit, then there are also facilities to easily shrink the data held.

How are they tracking this now - how are they getting paid right now - by each company they worked for that week via what? Payroll module? Do they log this anywhere? sounds like 201 company and create a sales order/invoice for each employee each week and then each store is an inventory item enter the number of days at each location. Ok I am reaching..... But being creative. Why buy more software!!

Hi Denise, Curious what your resolution was on this one.