Sage 100

 View Only
  • 1.  Scheduling (Gantt charts) with Sage version of Production Management?

    Posted 09-06-2024 16:19

    We have a client asking about scheduling options, ideally with Gantt chart functionality, for work ticket production (through the different production steps / activities).  I am not aware of anything that works like that. 

    Does anyone know of such an enhancement / product?



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------


  • 2.  RE: Scheduling (Gantt charts) with Sage version of Production Management?

    Posted 09-06-2024 16:49

    Microsoft Scheduler is a great stand alone product.  You would have to implement an integration.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 3.  RE: Scheduling (Gantt charts) with Sage version of Production Management?

    Posted 09-09-2024 14:59

    Thanks Doug.  Google tells me MS Scheduler is more for meetings..?

    Do you mean MS Project?  (I found instructions to import into Project from a spreadsheet, but not directly from ODBC...).



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 4.  RE: Scheduling (Gantt charts) with Sage version of Production Management?

    Posted 09-09-2024 16:33
      |   view attached

    yes.  MS Project.  I know you can schedule in Project.  There are milestones, Gant charts etc.  I have used it several times for larger projects however it has been a few years.  You could also use Excel as it has Gant charts.  See the two tabs in the workbook attached to this email.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Attachment(s)



  • 5.  RE: Scheduling (Gantt charts) with Sage version of Production Management?

    Posted 09-09-2024 17:55

    Thanks again Doug.  Yes, I took a course in Project way back-in-the-day and am generally familiar with the idea of Gantt charts. 

    Client data is fairly complex (multi-layer bills), with lots of custom reports for planning production / purchasing.  A new CFO is asking questions about integrated options, which don't seem to be readily available.



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 6.  RE: Scheduling (Gantt charts) with Sage version of Production Management?

    Posted 09-09-2024 21:05
    Edited by Dan Burleson 09-09-2024 23:35
      |   view attached

    Your question got me thinking about what other Microsoft programs, less involved than MS Project, could be adapted to Sage data. This Microsoft Excel template (attached) could be a starting point to which multi-layered bills could be adapted. Rather than an Excel chart, this technique uses Conditional formatting formulas based on table (i.e. query) row data to reflect planned versus actual status. Although Microsoft doesn't officially support running Excel unattended (I've run MS Access unattended, also unsupported, for 2 decades), such a query may be able to be setup in Power BI which is supported for scheduling.



    ------------------------------
    Dan Burleson
    Software Consultant
    Connex Software
    Corvallis OR
    541-224-6642
    ------------------------------

    Attachment(s)

    xlsx
    Gantt Template.xlsx   13 KB 1 version


  • 7.  RE: Scheduling (Gantt charts) with Sage version of Production Management?

    Posted 09-09-2024 16:37

    Isn't that one of the reasons people choose Operations Management over Production Management?  Trying to avoid cost, complexity and ... other potential issues?



    ------------------------------
    Gary Feldman
    Principal
    I-Business Network
    Marietta GA
    16786270646
    http://www-i-bn.net
    ------------------------------



  • 8.  RE: Scheduling (Gantt charts) with Sage version of Production Management?

    Posted 09-09-2024 17:47

    Thanks Gary, but I don't really know anything about Operations Management.  Does it include scheduling at the step / activity level?

    (This long-term client of ours was a conversion from WO to PM, and OM was possibly not even considered).



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 9.  RE: Scheduling (Gantt charts) with Sage version of Production Management?

    Posted 05-13-2025 18:29

    I realize this post is more than 6-months old, but I will respond. I was originally looking for scheduling experiences in PM. I find the PM capabilities to be very light and only related to infinite scheduling. Based on the answers above, the PM scheduling is closer to what WO had, which is not generally useful for most customers.

    Yes, the answer is OM has an Enhanced Scheduling module. It is capacity-based and is very functional. Unfortunately, most customers don't have the time or capability to master it, so very few use it or use correctly.



    ------------------------------
    John Hoyt, Co-Founder
    Next Level Manufacturing Consulting Group
    johnh@nextlevelMCG.com
    ------------------------------