After the opportunity is Closed/Won then what?

I'm looking for some advice about how best to handle contracts that are won - that is, where do we go after the sales process has been successful. We installed the Community Edition and it looks like this will work great for sales and marketing. But after that we need to manage the actual project and I would prefer not to create multiple data silos - we already have to get the CRM data into QuickBooks for accounting.  I definitely want the salespeople to have reports comparing things like the lead source and date, quoted price and quote-won date, and the ultimate project completion date and cost.  Profitability and time from lead to billing are pretty important metrics.

In our case we are dealing with construction projects where most of our cost is labor.  We have about 50 workers and managing the job assignment calendar can be a nightmare.  Weather delays, materials not being delivered on time, illness, accidents, etc. all require constant juggling of the calendar.

In the office we need an easy way to see the "big picture" calendar - maybe even on a big screen TV to replace the current marker board.  We also need a way to send the daily/weekly assignments to the workers by email, or by handing them a printed sheet in the morning.  Finally, we need to enter the actual hours worked to match our cost to the original quote, and to prepare payroll files.

Obviously it would be best to keep all account/contact/opportunity information in a single database (Sugar CRM) and add a module or custom code to manage the workers, hours and jobs.  Is there a Sugar CRM module we should look at?  Is this kind of thing built into the paid versions of Sugar CRM?  Some other way to keep all the information together in one place?

Any advice appreciated.


Parents
  • Mike, take a look at this QuickBooks integration module from Faye Business Systems:

    http://fayebsg.com/sugarcrm-quickbooks-integration-2/

    Their video demo is very informative and if it works as advertised it would solve many of my problems.

    For worker scheduling I am leaning toward a custom solution.  I have already made something simple that gets the Closed/Won Opportunities from Sugar and lists those on a page.  Then the supervisor can assign workers to each job, including the day/time.  That information all appears on a list-type report as well as a calendar page.  If I put a little more time into this I might have all the reports and scheduling tools we need.

    I just had time for a quick look at Mavenlink, but I don't see any Sugar CRM integration.  Everything we add from now on has to be integrated into everything else - no more data silos.  In case I missed it I will take a more detailed look later today.  But the other problem I have with most project management systems is that they are simply too complicated for my typical small business consulting client.


Reply
  • Mike, take a look at this QuickBooks integration module from Faye Business Systems:

    http://fayebsg.com/sugarcrm-quickbooks-integration-2/

    Their video demo is very informative and if it works as advertised it would solve many of my problems.

    For worker scheduling I am leaning toward a custom solution.  I have already made something simple that gets the Closed/Won Opportunities from Sugar and lists those on a page.  Then the supervisor can assign workers to each job, including the day/time.  That information all appears on a list-type report as well as a calendar page.  If I put a little more time into this I might have all the reports and scheduling tools we need.

    I just had time for a quick look at Mavenlink, but I don't see any Sugar CRM integration.  Everything we add from now on has to be integrated into everything else - no more data silos.  In case I missed it I will take a more detailed look later today.  But the other problem I have with most project management systems is that they are simply too complicated for my typical small business consulting client.


Children
No Data