The author developed an ERP framework for a construction company by integrating five distinct software products rather than building a single monolithic database. This approach separates data sources—such as 1C for payments and Bitrix24 for requests—to maintain data integrity and prevent unreliable metrics.
The system includes a financial core that links payments, requests, and contracts, and a document generator that prepares Word-based contracts from templates. A dedicated time-tracking service monitors employees, while a separate bot tracks workforce numbers on construction sites, including contractors.
The integration process involves matching payments to requests, invoices, and contracts. The system uses heuristic search to link data, flagging ambiguous matches for human review. It also includes automated checks to prevent duplicate payments and ensure that payments do not exceed contract limits or accepted work volumes.
The final component is a management dashboard that displays summaries from the other services without duplicating their logic. The author emphasizes that while the system automates routine tasks, it maintains human oversight for decision-making, particularly in legal and financial approvals.
The author notes that this modular structure allows for better error tracking and data validation. By keeping the responsibility for facts within their original sources, the system avoids the complexities of maintaining multiple versions of business rules across different databases.
