A manufacturer of children's playgrounds needed to connect their internal database with their accounting system. They managed inventory records in their custom FileMaker database, which generated goods received and issued notes. These documents were then manually re-entered into the ABRA accounting system by employees, which was time-consuming and error-prone.
We implemented a two-way data synchronization between the FileMaker database and the accounting software using a REST API. In this setup, FileMaker acted as the initiator, retrieving data and sending inventory updates. Receipts and issues were automatically transmitted from FileMaker to ABRA, eliminating the need for manual data entry and reducing the error rate.
We also retrieved customer, invoice, and accounting period information from the accounting system into FileMaker. This enabled the database to work with up-to-date accounting data and automatically detect when an accounting period is closed, thus preventing changes.
One development challenge was the complex data structure of the accounting system, where information about a single customer was spread across multiple tables (contacts, addresses, emails, etc.).
Thanks to this integration, the company achieved faster processes, ensured data consistency, and minimized errors.
