Building a Connected Manufacturing Execution System with AnyDB

Operational Objective

Create a manufacturing execution system capable of managing production control, repair workflows, project tracking, costing, approvals, and dependencies from one structured environment.

In practice, that meant:

• Track manufacturing and repair workflows step by step
• Monitor project status across multiple departments
• Measure estimated versus actual production time
• Track labor-hour and machine-hour allocation
• Calculate estimated versus actual production costs
• Connect engineering, approvals, materials, purchasing, and production tasks
• Control dependencies between production stages
• Give each department a clear view of its tasks
• Centralize drawings, specifications, comments, quality records, and production instructions
• Use dashboards to identify bottlenecks, delayed work, and pending activities
• Register actual completion dates automatically when tasks are completed
• Send schedule alerts for tasks outside the planned timeline
• Add customer portals and additional workflows in later phases
• Complement the existing ERP while preserving fiscal operations

Project tracker as the first operating layer

The first phase focused on turning the company’s production spreadsheet into a working management system.

Each project record includes key information such as the customer or order ID, description, dates, department status, comments, responsible users, workflow stages, and completion tracking.

This gives managers a single view of active projects and makes pending, delayed, or blocked work easier to identify.

Workflow stages and production dependencies

Engineering, purchasing, machining, production, and approvals are managed with clear ownership, status, dates, and dependencies.

Statuses reflect the factory process, including pending, in progress, completed, and not applicable.

The system can control prerequisites between stages, such as requiring completed drawings before machining or technical releases before purchasing.

Department-specific views and access control

Each department works from filtered views showing the tasks relevant to its responsibilities.

Engineering can focus on drawings and approvals. Purchasing can track material releases. Production can manage execution stages. Management can review the full workflow.

AnyDB also supports custom views, permissions, and controlled editing access by team, department, or user.

This keeps the interface simple for daily users, protects sensitive information, and gives managers visibility across the full process.

Comments, responsibility, and issue tracking

Teams can add comments, tag responsible users, record observations, and mark items as resolved inside the project record.

This keeps production communication tied to the work and reduces informal follow-up.

Dashboards, alerts, and completion history

Dashboards consolidate status, pending activities, priorities, delayed work, and bottlenecks across active projects.

Visual indicators help managers identify tasks that are behind schedule or outside the normal workflow.

Automations can register the actual completion date when a task is marked complete, creating a reliable history for future analysis.

Documentation and phased expansion

Technical drawings, PDFs, specifications, images, instructions, photos, videos, inspection records, and quality evidence stay connected to the relevant project or stage.

The first version was built from existing spreadsheets and refined through testing with the team. Once the model matched the factory’s daily workflow, the company could expand into customer portals, inventory, purchasing, quality workflows, dashboards, and automation.

AnyDB works as the production layer alongside the existing ERP, improving factory control while preserving the fiscal and accounting processes required by the business.