EM SmartFill

emSmartFill — Keep your Belgian customer data accurate via BCE/KBO

The emSmartFill module connects your Dolibarr to the official Belgian BCE/KBO business registry (Banque-Carrefour des Entreprises) via the cbeapi.be API. In one click, you verify your Belgian third parties, pre-fill their cards with official data, and bulk-clean malformed VAT numbers across your database. Ideal for accountants, freelancers and SMBs that want a clean customer base — and now a prerequisite for the upcoming Belgian Peppol B2B e-invoicing obligation (2026).

✅ One-click verification from the third-party card

• A "Verify with BCE" button appears on every Belgian third-party card
• Real-time fetch of official name, full address, legal form, status (active/ceased) and NACE activity codes
• Verification status persisted on the card: Verified, Not found, Error
• Last verification date visible directly on the third party

🎯 Smart pre-fill — per-field diff

Rather than a blind overwrite that destroys your local edits, emSmartFill compares field by field the BCE data against your Dolibarr values, and lets you choose precisely what to update:

• Visual comparison Current value / BCE value / Status for each field
• Individual checkboxes — pre-checked by default only for empty or different fields
• Shortcuts: "Select all differences" and "Select empty fields only"
• Fields covered: name, alias, address, postal code, city, country, company number (BCE), VAT number

🧹 Bulk VAT normalization — multi-country

Most customer bases accumulate malformed VAT numbers over time: missing country prefix, dots, dashes, spaces, inconsistent case. emSmartFill detects and fixes them in a few clicks, across your entire base, for 10 European countries:

• 🇧🇪 Belgium, 🇫🇷 France, 🇱🇺 Luxembourg, 🇳🇱 Netherlands, 🇩🇪 Germany, 🇪🇸 Spain, 🇮🇹 Italy, 🇵🇹 Portugal, 🇦🇹 Austria, 🇮🇪 Ireland
• 3 tabs: Analysis (categorization), Auto-corrections (in bulk), Manual review (ambiguous cases)
• Every correction logged in the audit journal (before/after)
• Nothing changes without your explicit confirmation

⚡ Mass verification up to 4000+ third parties

Got a large base to verify? The module handles it without timeouts or API saturation:

• Chunked AJAX pipeline — no HTTP call lasts more than 10 seconds
• Pause / Resume at any time — close the tab and resume later
• Filters: all, never verified, not verified since (date), retry errors, retry not-found
• Configurable throttle to respect API quotas
• Automatic detection of interrupted runs (browser crash, disconnect) and one-click resume
• Detailed per-run report with status filters and direct links to each third party

🤖 Optional automation

• Dolibarr triggers: automatic verification on third-party create/modify (option, off by default)
• Automatic pre-fill upon creation (independent option)
• Compatible with Dolibarr's native VAT button — emSmartFill replaces it with a version that actually works for Belgium

📊 Audit log & maintenance

• Every verification, pre-fill and correction is logged (who, when, what)
• Debug page: filters by action type / status / date / user, expandable view of raw API responses
• Maintenance page: database integrity check, extrafield repair if needed

🛡️ Security & compliance

• Strict CSRF validation on all sensitive actions
• API key encrypted in Dolibarr config and never re-exposed in HTML
• Automatic retry / backoff on API load spikes (429, 5xx)
• Non-intrusive architecture: hooks and triggers only, no core Dolibarr modification

🔌 Prerequisites

The module uses the cbeapi.be API, a Belgian provider specialized in BCE/KBO registry access. 2500 requests per day free upon signup — more than enough for most SMBs. For higher volumes (over 2500 verifications/day, typically accountants with a large client base), paid plans are available directly from cbeapi.be.

Note: this module works only for Belgian companies (verification against the BCE/KBO). VAT normalization, however, is multi-country EU.

🔧 Compatibility

• Dolibarr: 17.0 → 22.0
• PHP: 8.0 → 8.3
• Compatible with or without the Multicompany module
• Zero external dependencies (no composer in production)

📚 Learn more

👉 emSmartFill product page

👉 Full documentation — installation guide, cbeapi.be API key setup, FAQ and use cases

🔗 Synergies with other E-dem modules

emSmartFill prepares the ground for Peppol e-invoicing made mandatory in Belgium for B2B in 2026. A clean third-party base = Peppol invoices that go through without errors. Pair it with:

• emPeppol — send/receive invoices via the Peppol network

🤝 Support & updates

Actively maintained module. Responsive email support.

• 📧 Support: support@e-dem.com
• 🌐 Website: www.e-dem.com