A
A
Andrey2015-05-26 16:24:39
Automation
Andrey, 2015-05-26 16:24:39

Which accounting (information) web system engine to choose?

Task : to get an automated information system for accounting for any objects.
Required "out of the box" functions :
1) View / add / edit the object by the user in the object card.
2) Displaying the list of objects on the screen with paging.
3) Search for objects by specified fields.
4) Differentiation of user access rights to object classes.
Additional functions :
1) Import/export of data.
2) Formation of documents according to a given template.
3) History of changes in any object: by whom, when and what was changed.
4) Linking objects to the map.
5) Performing calculations on data: individually by object, in bulk for objects of the selected class.
Requirements :
1) DBMS: PostgreSQL, MySQL.
2) Web interface of the client part (front end).
3) Classes of objects. Objects of the same class form a registry.
4) Fields of objects: standard types of fields, enumerations, geometry (optional).
5) Relationships between objects: one-to-one, one-to-many, many-to-many.
6) Formation of the system model in the Administrator section without the need for programming: adding / changing object classes, object fields, object relations, object views, data validation conditions, input masks, etc.
7) The work of an authorized user with the system is carried out completely in the frontend : search, view, add, edit objects, perform operations on a group of objects.
QUESTION :
Please tell me the existing free systems that have the specified functionality and meet at least the requirements out of the box.
There is no need to mention Access, Excel, 1C and SAP :)
Example :
Model :
1) Class (registry) of objects "Rock samples" with fields:
* "Batch number" (string (100)),
* "Weight" (float) .
2) Class (registry) of "Measurements" objects with fields:
* "Name" (string(100)),
* "Breed" (relation(Rock samples)),
* "Date of measurement" (date),
* "Laboratorian" ( relation(Employees)).
3) Class (registry) of objects "Employees" with fields:
* "Department" (enum()),
* "Email" (string(25)).
Register of rock samples :
7742dfa4257147f0bbe722437896800c.pngObject card ПШ/2015-04 :
495a75de6939483ba38ed53991ce44ba.png

Answer the question

In order to leave comments, you need to log in

3 answer(s)
A
Andrey, 2015-06-04
Botviniev @abot

Thanks for answers!
Looking for a replacement for MS Access, I found this development: https://www.nubuilder.net/

S
Stanislav Makarov, 2015-05-27
@Nipheris

Several independent recommendations
1. Many of the requirements you have listed are standard for most modern information systems, and are not subject to requirements. You should think about the specific requirements and your specific processes in the enterprise or in research. Except for some advanced requirements (history and access control by class), then you have described something like Access, which, as it were, "suits" for everything.
2. Still, it is highly doubtful that you need a system to account for any objects, especially since you gave a specific description of the model. This is a meaningless goal, such a system will not really make your task easier. You should set a specific task and automate it. It is impossible to get something useful on a general level without delving into the details. At the general level, you can open Word or, again, Access, and enter data into the table.
3. If linking to a map is important to you, look in the direction of GIS systems. Many of them offer something similar to your requirements - to create objects with any set of properties (besides geometry). Only usually client software in such systems is used to work specifically with geometry - all other operations are automated separately (here it is useful to store data in a general-purpose DBMS, the classic of the genre is PostgreSQL + PostGIS).
PS Still, you seem to have a very specific task, which for some reason you are trying to generalize. A system for accounting for any objects is called a DBMS, and a tool for performing operations and calculations is called a programming language.

S
Shalf, 2015-06-04
@Shalf

And what does 1C/Axapta/SAP not suit you with? These are time-tested automation tools, with official and ongoing support, with many ready-made solutions for various business areas and the availability of ready-made specialists on the market.
As a matter of fact, I think you should look at existing frameworks depending on your preferred development language. The requirements you describe are fairly basic, and you'll be out of scope almost immediately when developing.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question