Database for the organization and / or EDMS - which system to choose?

Question

Database

There is an organization, people 100+ employees, budgetary, although there is a small income. 90% of the employees in this organization, in addition to doing their job, fill out many different journals. On the basis of these logs, statistics are collected for reporting (sent to the appropriate department in the ministry every quarter and on special occasions), the size of the "bonus" is calculated every month for all employees, and some other statistics are also collected for internal needs.
The department in the ministry that oversees us believes that we should do everything manually on paper with a pen. We have not been provided with any automated systems / databases / EDMS and will not be provided soon. The position of "IT specialist" is not even provided (no admins). So we solve the problem on our own.
On our own, we created an internal portal in PHP with a MySQL database and implemented these "logs" (simple functionality for working with them such as adding, editing, searching, selecting, reporting / statistics).
In addition to magazines, there are "goodies" designed to make life easier for employees from the accounting department, office, deputies, etc. It works, everyone is happy. If not for one "but": often the forms of statistical reporting change. Sometimes "indicators" appear, in order to calculate which you need to add additional fields to the database, make changes to the "interface", rewrite report scripts.
And of course, the world is changing, the needs of the organization are growing. I would like to be able to store documents in the "base" (scans, for example, and / or word / excel / pdf documents, etc.). Still it would not be bad not only to store, but also search and goodies. And the use of a self-propelled gun "on the knee" is not solid and it is already difficult to "modernize" all this.
Please tell me which system to choose (or at least a class of systems so that you can google further). I just can’t imagine what it should be (for example, with various EDMS I have a lot of misunderstandings, for example, is it possible to organize different tables, relationships between them, directories, report builders, etc. or EDMS is just shuffling "documents" according to departments, office, accounting and management). in the end, try something at least for a couple "

Answer 1

I advise you to look towards the workflow from Atlas-Soft . It's all there.