{"id":329,"date":"2025-11-07T13:46:43","date_gmt":"2025-11-07T13:46:43","guid":{"rendered":"https:\/\/bjornproost.nl\/?page_id=329"},"modified":"2025-11-07T13:46:43","modified_gmt":"2025-11-07T13:46:43","slug":"11-5-1-solution-design-voorbeeld","status":"publish","type":"page","link":"https:\/\/bjornproost.nl\/?page_id=329","title":{"rendered":"11.5.1 Solution Design \u2013 Voorbeeld"},"content":{"rendered":"\n

Solution Design Document (SDD)<\/strong><\/h2>\n\n\n\n

Proces:<\/strong> Factuurverwerking \u2013 Inkomende Facturen
Versie:<\/strong> 1.0
Datum:<\/strong> 6 november 2025
Auteur:<\/strong> Bj\u00f6rn Proost \u2013 Business Analyst
Doel:<\/strong> Technische blauwdruk van de automatisering voor het inkomende-facturenproces<\/p>\n\n\n\n

\n\n\n\n

Step 0 \u2013 Introduction<\/strong><\/h3>\n\n\n\n

Projectnaam:<\/strong>
Factuurverwerking \u2013 Inkomende Facturen<\/p>\n\n\n\n

Organisatie:<\/strong>
FinAdWise B.V.<\/p>\n\n\n\n

Beschrijving:<\/strong>
Deze oplossing automatiseert de verwerking van inkomende facturen via e-mail of uploadportalen.
De automatisering leest bijlagen, herkent leveranciersgegevens en bedragen, valideert data op btw- en boekhoudregels,
en boekt de facturen automatisch in de boekhoudsoftware.<\/p>\n\n\n\n

Doelstelling:<\/strong><\/p>\n\n\n\n

    \n
  • Verminderen van handmatige invoer > 70 %.<\/li>\n\n\n\n
  • Verkorten van de verwerkingstijd van 5 minuten naar < 1 minuut per factuur.<\/li>\n\n\n\n
  • Verbeteren van datakwaliteit en audittrail.<\/li>\n<\/ul>\n\n\n\n
    \n\n\n\n

    Step 1 \u2013 Process Overview<\/strong><\/h3>\n\n\n\n
    Categorie<\/strong><\/th>Beschrijving<\/strong><\/th><\/tr><\/thead>
    Pre-requisites<\/strong><\/td>Facturen worden digitaal aangeleverd (pdf, UBL) via factuur@finadwise.nl<\/a>.<\/td><\/tr>
    Applicaties<\/strong><\/td>Factuurverwerkingssoftware (bijv. Scan & Recognize Tool), Boekhoudsoftware, SharePoint, Power BI.<\/td><\/tr>
    Infra<\/strong><\/td>Virtuele server \u2013 Windows 11 Enterprise, Robot runtime UiPath 2024 LTS.<\/td><\/tr>
    Interactie<\/strong><\/td>Robot monitort mailbox, verwerkt bijlagen, uploadt resultaten naar SharePoint en API-post naar boekhoudpakket.<\/td><\/tr>
    Conventies<\/strong><\/td>Naming standaard = FVR_<leverancier>_<datum><\/code>. Logbestanden in C:\\Automation\\Logs.<\/td><\/tr>
    Projectorganisatie<\/strong><\/td>Sponsor \u2192 Finance Director \u2022 PM \u2192 Jan Vermeer \u2022 BA \u2192 Bj\u00f6rn Proost \u2022 SA \u2192 Eva Veldhuis \u2022 Dev \u2192 Sam Peeters<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
    \n\n\n\n

    Step 2 \u2013 Diagram (High-Level Process Flow)<\/strong><\/h3>\n\n\n\n

    Tekstuele weergave:<\/strong><\/p>\n\n\n\n

      \n
    1. Trigger:<\/strong> Nieuwe e-mail met bijlage in Inkomende Facturen-mailbox<\/em>.<\/li>\n\n\n\n
    2. Input Check:<\/strong> Controleren of bijlage pdf\/UBL is.<\/li>\n\n\n\n
    3. OCR\/Extractie:<\/strong> Uitlezen leverancier, factuurnummer, bedrag, btw, IBAN.<\/li>\n\n\n\n
    4. Validatie:<\/strong> Controle op duplicaten, openstaande orders en btw-regels.<\/li>\n\n\n\n
    5. Boeking:<\/strong> Uploaden van data via API naar boekhoudsoftware.<\/li>\n\n\n\n
    6. Rapportage:<\/strong> Logging en statusmelding in Power BI.<\/li>\n\n\n\n
    7. Archivering:<\/strong> Factuur en log verplaatsen naar SharePoint-mappen Processed<\/em> of Rejected<\/em>.<\/li>\n<\/ol>\n\n\n\n
      [Email Trigger] \u2192 [Read Attachment] \u2192 [Extract Data] \u2192 [Validate Rules] \u2192 [Post to Accounting System] \u2192 [Archive + Log]\n<\/code><\/pre>\n\n\n\n
      \n\n\n\n
      Step 3 \u2013 Design<\/strong><\/h3>\n\n\n\n
      Modulaire opbouw (whiteboard workflow):<\/strong><\/p>\n\n\n\n
      Module<\/strong><\/th>Beschrijving<\/strong><\/th>Ontwikkelduur<\/strong><\/th><\/tr><\/thead>
      M1 \u2013 Email Listener<\/strong><\/td>Detecteert nieuwe berichten en downloadt bijlagen.<\/td>1 dag<\/td><\/tr>
      M2 \u2013 Data Extractor<\/strong><\/td>OCR \/ UBL-parser voor factuurdata.<\/td>2 dagen<\/td><\/tr>
      M3 \u2013 Validation Engine<\/strong><\/td>Controleert duplicaten, btw-nummers, ordermatching.<\/td>3 dagen<\/td><\/tr>
      M4 \u2013 Accounting Uploader<\/strong><\/td>API-koppeling naar boekhoudsoftware.<\/td>2 dagen<\/td><\/tr>
      M5 \u2013 Report Generator<\/strong><\/td>Genereert Power BI dataset met logs en fouten.<\/td>1 dag<\/td><\/tr>
      M6 \u2013 Exception Handler<\/strong><\/td>Foutafhandeling en notificaties per e-mail.<\/td>1 dag<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Totale geschatte ontwikkeltijd:<\/strong> \u00b1 10 dagen (laag-tot-middelmatige complexiteit).<\/p>\n\n\n\n
      Principes:<\/strong> modulariteit \u2022 herbruikbaarheid \u2022 gescheiden configuratie \u2022 central logging.<\/p>\n\n\n\n
      \n\n\n\n
      Step 4 \u2013 Development & Testing<\/strong><\/h3>\n\n\n\n
        \n
      • Ontwikkeling in UiPath Studio 2024 LTS.<\/li>\n\n\n\n
      • Elke module getest via Unit Test<\/em> met gesimuleerde input.<\/li>\n\n\n\n
      • Integration Test<\/em> uitgevoerd in testomgeving met 100 testfacturen.<\/li>\n\n\n\n
      • Testrapporten vastgelegd in Technical Testing Plan v1.2<\/em>.<\/li>\n<\/ul>\n\n\n\n
        Wijzigingen tijdens ontwikkeling:<\/strong><\/p>\n\n\n\n
          \n
        • Extra validatie toegevoegd voor dubbele IBAN-nummers.<\/li>\n\n\n\n
        • API-endpoint gewijzigd na update boekhoudsoftware (versie 5.4).
          \u2192 Beide aanpassingen geregistreerd in Revisiehistorie rev 1.3<\/em>.<\/li>\n<\/ul>\n\n\n\n
          \n\n\n\n
          Step 5 \u2013 Asset Management<\/strong><\/h3>\n\n\n\n
          Asset<\/strong><\/th>Type<\/strong><\/th>Locatie<\/strong><\/th>Opmerking<\/strong><\/th><\/tr><\/thead>
          EmailListener.xaml<\/td>Workflow<\/td>\\Projects\\FVR\\Modules<\/td>Trigger via Outlook API<\/td><\/tr>
          ExtractInvoiceData.xaml<\/td>Workflow<\/td>idem<\/td>OCR \/ UBL-extractie<\/td><\/tr>
          ValidationRules.json<\/td>Configbestand<\/td>\\Projects\\FVR\\Config<\/td>Bevat validatieregels<\/td><\/tr>
          AccountingUploader.xaml<\/td>Workflow<\/td>idem<\/td>API-verbinding<\/td><\/tr>
          PowerBI_ReportTemplate.pbix<\/td>Rapportage<\/td>\\Projects\\FVR\\Reports<\/td>Dashboardtemplate<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
          \n\n\n\n
          Step 6 \u2013 Queues & Triggers<\/strong><\/h3>\n\n\n\n
          Onderdeel<\/strong><\/th>Beschrijving<\/strong><\/th><\/tr><\/thead>
          Queue Name<\/strong><\/td>InvoiceProcessingQueue<\/em><\/td><\/tr>
          Triggers<\/strong><\/td>Mailtrigger \u2013 Nieuwe e-mail in map \u201cInbox\\Invoices\u201d<\/td><\/tr>
          Retry-policy<\/strong><\/td>3 keer met interval van 10 minuten<\/td><\/tr>
          Timeouts<\/strong><\/td>60 seconden per transactie<\/td><\/tr>
          Folderstructuur<\/strong><\/td>\/Input \u2022 \/Processed \u2022 \/Rejected \u2022 \/Logs<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
          \n\n\n\n
          Step 7 \u2013 Code Dependencies<\/strong><\/h3>\n\n\n\n
          Package \/ Library<\/strong><\/th>Versie<\/strong><\/th>Bron<\/strong><\/th>Goedkeuring<\/strong><\/th><\/tr><\/thead>
          UiPath.Mail.Activities<\/td>1.20.3<\/td>UiPath Official<\/td>✅ Ja<\/td><\/tr>
          UiPath.PDF.Activities<\/td>3.9.0<\/td>UiPath Official<\/td>✅ Ja<\/td><\/tr>
          Newtonsoft.Json<\/td>13.0.2<\/td>NuGet Open Source<\/td>✅ Security Check<\/td><\/tr>
          PowerBIRestAPI.dll<\/td>1.4.1<\/td>Intern ontwikkeld<\/td>✅ Eigen beheer<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
          \n\n\n\n
          Step 8 \u2013 Compliance & Security<\/strong><\/h3>\n\n\n\n
            \n
          • Alle data wordt verwerkt binnen EU-servers (Azure West Europe).<\/li>\n\n\n\n
          • Credentials opgeslagen via UiPath Orchestrator Assets (met encryptie AES-256).<\/li>\n\n\n\n
          • Factuurdata bevat persoonsgegevens \u2192 voldoet aan AVG artikel 28.<\/li>\n\n\n\n
          • Logging geanonimiseerd: leveranciersnamen en bedragen worden gehasht in Power BI.<\/li>\n\n\n\n
          • Pen-test uitgevoerd (rapport #2025-FVR-SEC-003).<\/li>\n<\/ul>\n\n\n\n
            \n\n\n\n
            Step 9 \u2013 Reporting & Dashboarding<\/strong><\/h3>\n\n\n\n
            Operationele KPI\u2019s:<\/strong><\/p>\n\n\n\n
              \n
            • Aantal verwerkte facturen per dag\/week.<\/li>\n\n\n\n
            • Gemiddelde verwerkingstijd (AHT).<\/li>\n\n\n\n
            • Percentage automatisch goedgekeurd.<\/li>\n\n\n\n
            • Aantal exceptions \/ fouten.<\/li>\n<\/ul>\n\n\n\n
              Business KPI\u2019s:<\/strong><\/p>\n\n\n\n
                \n
              • Bespaarde manuren (FTE\u2019s).<\/li>\n\n\n\n
              • Foutpercentage voor en na automatisering.<\/li>\n\n\n\n
              • Doorlooptijd van ontvangst tot boeking.<\/li>\n<\/ul>\n\n\n\n
                Visualisatie:<\/strong>
                Power BI-dashboard met:<\/p>\n\n\n\n
                  \n
                • real-time status per leverancier,<\/li>\n\n\n\n
                • trending-grafieken,<\/li>\n\n\n\n
                • heatmap voor foutoorzaken,<\/li>\n\n\n\n
                • exportfunctie naar Excel en SharePoint.<\/li>\n<\/ul>\n\n\n\n
                  \n\n\n\n
                  Revision History<\/strong><\/h3>\n\n\n\n
                  Rev#<\/strong><\/th>Datum<\/strong><\/th>Omschrijving van wijziging<\/strong><\/th>Auteur \/ Rol<\/strong><\/th><\/tr><\/thead>
                  1.0<\/td>06-11-2025<\/td>Eerste versie \u2013 opgezet volgens AMM-richtlijnen<\/td>Bj\u00f6rn Proost (BA)<\/td><\/tr>
                  1.1<\/td>10-11-2025<\/td>API-endpoint en IBAN-check toegevoegd<\/td>Eva Veldhuis (SA)<\/td><\/tr>
                  1.2<\/td>15-11-2025<\/td>Power BI-logging uitgebreid<\/td>Sam Peeters (Dev)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
                  \n\n\n\n
                  Key Contacts<\/strong><\/h3>\n\n\n\n
                  Rol<\/strong><\/th>Naam<\/strong><\/th>E-mail<\/strong><\/th>Organisatie<\/strong><\/th><\/tr><\/thead>
                  Sponsor<\/td>Lisa Hendriks<\/td>lisa.hendriks@finadwise.nl<\/a><\/td>FinAdWise B.V.<\/td><\/tr>
                  Process Owner<\/td>Thomas van Beek<\/td>thomas.vbeek@finadwise.nl<\/a><\/td>FinAdWise B.V.<\/td><\/tr>
                  Project Manager<\/td>Jan Vermeer<\/td>jan.vermeer@finadwise.nl<\/a><\/td>FinAdWise B.V.<\/td><\/tr>
                  Developer<\/td>Sam Peeters<\/td>sam.peeters@finadwise.nl<\/a><\/td>FinAdWise B.V.<\/td><\/tr>
                  Solution Architect<\/td>Eva Veldhuis<\/td>eva.veldhuis@finadwise.nl<\/a><\/td>FinAdWise B.V.<\/td><\/tr>
                  Business Analyst<\/td>Bj\u00f6rn Proost<\/strong><\/td>bjorn.proost@finadwise.nl<\/a><\/td>FinAdWise B.V.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
                  \n\n\n\n
                  Bijlage \u2013 High-Level Visual Process Flow<\/strong><\/h3>\n\n\n\n
                   \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n \u2502  Email Inbox\u2502\n \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n        \u2502Trigger\n        \u25bc\n \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n \u2502 Extract Data\u2502 \u2190 OCR \/ UBL\n \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n        \u25bc\n \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n \u2502 Validate Data\u2502\n \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n        \u25bc\n \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n \u2502 Bookkeeping \u2502 \u2190 API\n \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n        \u25bc\n \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n \u2502 Reporting & \u2502\n \u2502 Archiving   \u2502\n \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n<\/code><\/pre>\n\n\n\n
                  \n\n\n\n
                  Einde document \u2013 Solution Design Document (Factuurverwerking Inkomende Facturen)<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"
                  Solution Design Document (SDD) Proces: Factuurverwerking \u2013 Inkomende FacturenVersie: 1.0Datum: 6 november 2025Auteur: Bj\u00f6rn Proost \u2013 Business AnalystDoel: Technische blauwdruk van de automatisering voor het inkomende-facturenproces Step 0 \u2013 Introduction Projectnaam:Factuurverwerking \u2013 Inkomende Facturen Organisatie:FinAdWise B.V. Beschrijving:Deze oplossing automatiseert de verwerking van inkomende facturen via e-mail of uploadportalen.De automatisering leest bijlagen, herkent leveranciersgegevens en bedragen, […]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_joinchat":[],"footnotes":""},"class_list":["post-329","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/bjornproost.nl\/index.php?rest_route=\/wp\/v2\/pages\/329","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bjornproost.nl\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/bjornproost.nl\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/bjornproost.nl\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bjornproost.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=329"}],"version-history":[{"count":1,"href":"https:\/\/bjornproost.nl\/index.php?rest_route=\/wp\/v2\/pages\/329\/revisions"}],"predecessor-version":[{"id":331,"href":"https:\/\/bjornproost.nl\/index.php?rest_route=\/wp\/v2\/pages\/329\/revisions\/331"}],"wp:attachment":[{"href":"https:\/\/bjornproost.nl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}