Optimization of the integration solution between the custom-developed source system and Business Central

Dansk Producentansvar (DPA) manages producer-responsibility for products such as electronics, cars, batteries, packaging, single-use plastics, and fishing gear. DPA supports the circular economy by developing IT solutions for the collection and recycling of products.

The challenge

After a few productive meetings, we agreed to develop a new integration between their custom-developed source system and Business Central (BC). The previous integration had several challenges in handling errors.

The solution

To address these challenges, we implemented a dynamic shadow table in Business Central. This shadow table serves as a temporary storage unit where the APIs can write data without immediate validation. The data is then validated in the customer and sales invoice tables based on the shadow table, ensuring efficient error handling.

With the shadow table, we can quickly identify errors and gaps before the data reaches the critical tables. This gives us much better control over data integrity and minimizes the risk of incorrect invoicing, explains CFO Thomas Hansson.

The conclusion

The implementation of the new integration solution has resulted in more stable and secure data transfer between the source system and Business Central. With the shadow table serving as a buffer, we have achieved a more structured validation process that eliminates customer duplicates and ensures correct invoicing.

The new solution has given us a much better understanding of our data flow between our core systems, and it has created a more secure invoicing process. This is crucial for us, concludes Thomas Hansson.