Micro Force

Micro Force Case Study

• Case Study: District Council 37

   

  District Council 37 is New York City’s largest municipal public employee union, providing services to 125,000 non-uniformed city employees. DC 37, like many other unions in the U.S., needed to comply with a new reporting requirement mandated by the Department of Labor.
  
  Unions are required to submit seperate forms for each vendor who receives $5,000 in each of the LM-2 categories. They feared that the new requirements would require additional staffing.
  
  Through special LM-2 meetings with local unions, The Department of Labor recommended the use of seperate books. Mike Crudele knew that this would take an enormous amount of time. "We knew what we had to do, but had no means of doing it," said Mr. Crudele, adding that he "did not want to add additional work to the staff."

  In the fall of 2004, Micro Force and DC 37 were on a mission to find a solution for LM-2 that could integrate with their newly implemented Microsoft Dynamics GP (Great Plains). They needed to work fast, the DOL had announced that changes would be going into affect immediately.
  
  According to Mr. Crudele, it soon became apparent "that there was no system available that could provide an electronic LM-2 solution to integrate into the back office system."

  Many systems were available through accounts receivables. However, Mr. Crudele knew that it was imperative for the information to pull from the payable side. In the end, both parties agreed that the system would need to be built from scratch.
  
  The staff at Micro Force worked closely with DC 37 to ensure that all their needs were met. They decided that it was best to capture the schedule details in the payables module versus the general ledger. This way, the schedules could be determined at the time of vouchering and the LM-2 program could be written to report based on the payment.
  
  LM-2 groups were set up with specified percentage breakdowns. As payments were entered, the percentage default would automatically pull from Great Plains.
  
  With over 1,000 GL accounts, DC37 knew how much time they would be saving. When all was said and done, DC 37 commented that, "the payback will be enormous" and Micro Force agreed.