I am searching for recommendations for a ERP/DMS/CMS type platform which runs on or alongside SQL-server express.
The ERP/DMS will be an extension to existing invoicing/accounting software - which runs on SQL-server express. The database is open accessible.
By the way ERP/DMS/CMS is what I think the relevant terms are.
Some clarifications are in order:
I run a small utility business.
The invoicing/accounting software has been completely overhauled from a foxpro application to SQL server express.
The software is closed source, but the database is open.
Over the last 15 years I have augmented the original invoicing
application with several tools such as customer relations, contract,
work order and payment management, based on the central invoicing
database. These tools are made with Access.
Now that that central database is changed, all the secondary tools have to been rewritten.
For the new setup, I am hoping to use a commercially or open-source available platform, limiting the conversion to customization while keeping heavy programming tasks at a minimum.
Essentially I want a front-end application system with a big emphasis on data-entry and reporting to an sql-server database backend.
It would be nice if it could be accessed from browsers allowing for
mobile use. However I don't want an online hosting solution, everything has to run in-house/self-hosted.
The intended user base is 10-20 people with varying degrees of access.
The mobile use will be partly data-entry = filling out forms (optionboxes and limited text).
During my search, I am always surprised that data-entry causes problems.
As it seems a important part of any system = to feed it with data.
Initial research has mainly shown that the field of candidates is very vast - and very confusing. Alfresco, iDempiere, Dolibarr,suiteCrm, Drupal, even Wordpress, ...
I have no preference of OS, language, db as long as it can be used together with sql express.
Suggestions are welcome
--
iDempiere java + postgresql or oracle. You must have proper implementation plan and hire professional to do that for you. Once everything is done. Adding new features are super awesome.
erpnext, python + mariadb, mobile first concept. What you need is just python hacker.
ViennaAdvantage, html5 + c# + oracle. Has dms, pos and so on. Most sexiest erp but comes with a price.