Quote from lenny_baledge on 10/01/07 at 09:54:03:
Scheduling/Capacity planning is on my todo list as well. We are constantly growing as our sales starts pushing our mnf capacity, good planning/scheduling is mandatory. A nice interface with drag/drop & the ability to push/nudge jobs around to see the results would help a lot. There are off the shelf schedulers but again, it's the same issue. They are garden variety & we will have special needs.
Should be easier than MRP, and no need to write back to DBA (which I assume you had to do for POs, etc. with the MRP). I recently wrote a browser-based order entry system and have used MySQL for storing and working with quotes. It is faster, simpler, more flexible, and works nicely through VPN for our field sales and service people. I insert the orders into the EDI module as quotes where the production managers check, convert, acknowledge, and print sales orders. It has been working so well that I'm going to do the same type of thing for RMAs now that the unified returns module is complete.
Quote from lenny_baledge on 10/01/07 at 09:54:03:
One thing to be wary of. If you are paying your IT person to do these things and they leave, the knowledge goes with them. I can guarantee it won't be documented well enough for just anyone to drop right in. If it were documented that well, it would cost you 4x more to develop. So there is a downside to have a custom widgit. For us, it's a moot point since I am an owner as well as the resident SW/HW geek.
I am the IT person: systems analyst, MRP/ERP/CRM guru, web developer, programmer, IT project coordinator, etc. The tools that I have developed for our people are browser based and use standard web development tools like PHP, XHTML, DOM, Ajax, CSS, etc. Both the code and the project are documented, for my benefit as well as the company's, but my knowledge of DBA and its structure would take awhile to replace. However, if I were to walk away tomorrow, Evo will keep going and nothing would be lost except a bit of flexibility. By sticking with the hybrid the company is protected from the downside while I am free to spend as little or as much time as I want making things work better.