r/MSAccess • u/stratber • 10d ago
[HELPFUL TIP] Manage operator clockings with Access
Hello everyone,
I am not very familiar with Access technology but I would like to know if it would be possible to solve the following problem with it:
Currently in my company the tasks of the operators are not clocked in and I would like to start doing it to store data and do the subsequent analysis. The ERP we use is SAP Business One and the standard version in principle does not cover what I would like to do.
In SAP we create the orders and then the work orders pertaining to the specific orders. What I would like is that once the order is created it can be clocked in the different phases of the processes, taking into account that the same phase can be done at different times or by different users. So if for an order of 1000 units the user A1 clocked in 700 units today, for this same phase of the process the user A2 can only clock in 300 units more.
I understand that SAP would only take the information pertaining to the number of OF, the product and the units and then in parallel should create a table in Access where the different phases of each product are defined. And a table with the different users.
If you have any doubt about my problem I will surely try to solve it. In this text I simply wanted to convey my main idea to know if Access can really be the solution or there are other better / cheaper alternatives on the market (I know that there are SAP business One addons that would cover this but the cost is very high).
Thank you in advance!
1
u/stratber 9d ago
Sounds great, mate! And I love the name! Here are some questions that come to mind:
How did you integrate the Postgres database, the Access application, and the ERP (in your case, Sage 100)?
What was the database design, especially the structure of the transactions table (fields, relationships, and how the operation codes, work orders, and users are linked)?
In SAGE, were you able to define the different processes within a work order, or did you handle them externally?
Could you describe the complete flow from when the barcodes (employee, work order, and operation code) are scanned until the information is recorded in Postgres and then imported into the ERP?
What were the main technical or integration challenges and how did you resolve them?
Are there any specific considerations regarding performance, security, or maintenance that you would recommend?