Three answers, three flags on the list
Every line item for a counterparty gets the flag. Yellow means there's no answer and a re-check is needed.
Starting point
Half a full-time role re-typing from a browser.
Open the European Commission's lookup, enter the VAT ID and country code, read the result, save it. And do that for every counterparty on the shipping list. It added up to half a full-time role a month, no trace was left in the system, and a skipped check risked an invoice error.
What we built
The bot starts itself, without a reminder.
The check starts on its own the moment a shipping list closes at status 20 or 70, or when a user triggers it from a list item. The bot takes the VAT ID and country code from the payer file, queries the VIES API, and organizes the response.
What had to change
Workflow first, then the bot.
Three things had to happen on the ERP side: turn on the workflow, add a table for the results, and change the invoice templates. The bot handles the rest using what the system already offers.
Results
Recurring data checks are the first thing worth automating.
We don't name the company. Numbers come from the audit and process measurement at the client.