To import vendor e-invoices into Dynamics 365 Finance, you use Electronic Reporting (ER). First, import Microsoft’s PEPPOL-based Vendor invoice import configurations. Then set up the vendor, item and unit master data, and point an ER source at the folder where the invoice files arrive. A batch job then creates pending vendor invoices in Accounts payable.
E-invoicing is now a legal requirement in France, Belgium and the UAE, and more EU countries are following. This guide shows the full setup with a France example. It covers the ER components, how Dynamics 365 matches vendors, products and purchase orders, the master data you need, and how to collect UBL files from SharePoint or an SFTP server.
Overview of the Electronic Reporting Setup
The Electronic Reporting configuration described here is designed to import vendor invoices from SharePoint into Dynamics 365 Finance as part of France e-invoicing processes. While it is based on standard Microsoft ER configurations, it has been extended to support custom mandatory fields on pending vendor invoice lines.
The import process relies on structured data mapping rather than manual invoice entry. Once configured, Dynamics 365 Finance can automatically collect invoice files, validate them against master data, and create pending vendor invoices in Accounts Payable, aligning with e invoicing in France requirements.
Understanding Electronic Reporting Components
Electronic Reporting uses a layered architecture, with each component playing a specific role in the import process. Understanding how these layers work together makes troubleshooting and configuration much easier.
Data Model
The data model defines the abstract structure of the data, including fields, containers, and relationships. It acts as the contract between the incoming file format and the destination in Dynamics 365 Finance.
Format
The format defines the structure of the incoming file, such as XML, JSON, or Excel. In this scenario, the format supports UBL-based vendor invoices for France e-invoicing.
Mapping to Destination
The mapping connects data model fields to their destination tables and entities in Dynamics 365 Finance. Vendor invoice headers are written to the VendInvoiceHeaderEntity, while invoice lines are written to the related VendInvoiceLineEntity. This mapping is what ultimately creates the pending vendor invoice in the system.
How Dynamics 365 Finance Processes an Imported Vendor E-Invoice
When a vendor invoice file is imported, Dynamics 365 Finance follows a defined sequence of validation and matching steps. Each step decides whether the invoice is created, created with a warning, or rejected. The steps below follow Microsoft’s documentation on how to import vendor electronic invoices.
Vendor identification
Vendors are identified using the tax-exempt number defined on the vendor record. If no matching vendor is found, the import fails, and an error message is displayed.
Product identification
Invoice line products are identified using external item numbers, which may be vendor-specific. If no matching product is found, the import fails and an error message is displayed.
Unit of measure validation
Units of measure are matched using external unit codes. If a matching unit is not found, the import fails.
Purchase order matching
If the incoming vendor invoice file includes purchase order references, Dynamics 365 Finance uses these values to match the invoice to existing purchase orders and their related lines.
The purchase order number is read from the header-level XML element:
- Invoice\cac:OrderReference\cbc:ID
Invoice lines are matched to purchase order lines using:
- Invoice\cac:InvoiceLine\cac:OrderLineReference\cbc:LineID
When these elements are present, the system matches the invoice and its lines to confirmed purchase orders in the system.
Automatic matching
If no order references are provided, the system attempts to automatically match the invoice to confirmed purchase orders using product purchase prices.
No purchase order found
If no purchase order is found, a warning is raised, but the import continues. The invoice lines are treated as non-stock items. Therefore, the system expects that these products belong to an item model group where the Stocked product checkbox is cleared on the Inventory policy page.
Default item handling
If no non-stock products exist, the system uses a default item with the code DEFAULT_ITEM. This product must belong to an item model group where the Stocked product option is disabled.
D365 F&O ADD-ON: SYSINVOICEMATCH
Too many invoice lines landing on DEFAULT_ITEM?
Standard import only finds an item when the vendor’s external item code is already set up. Everything else becomes a non-stock line that AP has to fix by hand.
SysInvoiceMatch adds a review step before the pending invoice. Your rules map each supplier description to the right item or procurement category. Then every line is matched to its purchase order line, within each vendor’s price and quantity tolerance. As a result, AP only handles the exceptions.
Tax calculation
Taxes are calculated within Dynamics 365 Finance based on imported data and tax setup. Tax amounts are not imported as fixed values and can be adjusted manually if required.
File attachments
File attachments included in the vendor invoice are supported during the import process. Attachments are read from the following XML element:
- Invoice\cac:AdditionalDocumentReference
All attached files must include a valid file extension. If an attachment does not have an extension, Dynamics 365 Finance raises a warning and skips the attachment, while the rest of the invoice continues to import.
Expectation
After a successful import, the vendor invoice is created in Dynamics 365 Finance as a pending vendor invoice. It can be reviewed and processed under:
- Accounts payable > Invoices > Pending vendor invoices
At this stage, the invoice is available for validation, approval, and posting according to standard Accounts Payable workflows.
Prerequisites Before Importing Vendor E-Invoices
Before running the import, specific master data must be configured correctly in Dynamics 365 Finance. Missing or incomplete setup at this stage is one of the most common causes of import failures when implementing France e-invoicing.
Vendor Tax-Exempt Number
The vendor tax-exempt number is used to identify vendors during the invoice import process.
This value must be populated on the vendor record. Without it, the system cannot determine which vendor the invoice belongs to.
Edit vendor showing Tax exempt number
External Item Descriptions
External item descriptions link the item number your vendor puts on the invoice to your own released product. Without this mapping, the import can’t identify the product on the invoice line.
To configure this, open the released product and go to:
- Product information management > Products > Released products > Purchase > External item description
Then add one line per vendor with that vendor’s item number.
Released product form > External item description
In the External item descriptions form, configure the mapping between vendor and external item number:
External item descriptions showing vendor-specific item number
External Unit Codes
External unit codes allow vendor-specific unit of measure codes to be mapped to internal units in Dynamics 365 Finance.
Go to:
- Organization administration > Setup > Units
Select the relevant unit of measure and use External codes to define the vendor-specific mappings.
Units form with External codes button highlighted
Purchase Order References
When invoices include purchase order references, Dynamics 365 Finance uses the order number and line references from the invoice file to match the invoice to confirmed purchase orders. This enables accurate three-way matching and reduces manual reconciliation.
Configuring Vendor Electronic Invoice Import for France
To support vendor e-invoices for France, the appropriate ER configurations must be imported and activated.
Start by navigating to Workspaces > Electronic reporting > Repositories and opening the Dataverse configuration repository.
Configuration repositories showing Dataverse repository
From here, import the required Invoice model and related configurations. Using the Import option in the Versions section allows you to select a specific configuration version if needed.
How to import Vendor invoice import (FR) ER Configurations for France
Once imported, the vendor electronic invoice import configurations for France will appear in your list of ER configurations.
Showing imported vendor electronic invoice import ER configurations for France
How to Import UBL Vendor Invoices from SharePoint
One supported approach is to use SharePoint as the source location for UBL invoice files. Dynamics 365 Finance connects directly to SharePoint and retrieves the files automatically.
Vendor invoice files can also be retrieved from an SFTP server with the free SysBrilliance SFTP Connector. This is common when vendors or e-invoicing providers deliver invoices over SFTP rather than SharePoint or APIs.
Once retrieved, the files are processed by Electronic Reporting, and each one becomes a pending vendor invoice in Accounts payable.
FREE ADD-ON: SFTP CONNECTOR
Does your e-invoicing provider deliver files over SFTP?
Many access point providers drop vendor e-invoices in an SFTP folder rather than SharePoint. Our free SFTP Connector picks up those files in Dynamics 365 Finance & Operations, so the same import runs without extra middleware.
SharePoint Folder Structure
Create the following folder structure in SharePoint:
SharePoint folders – Error, Imported, To import, Warning
Each folder plays a role in tracking the status of imported files.
Document Types Configuration
The next step is to set up document types in Dynamics 365 Finance, with one document type created for each of the four SharePoint folders.
In this example, the configuration is shown for the Imported folder, and the same approach should be applied to the remaining folders.
Navigate to:
- Organization administration > Document management > Document types
Create and configure a document type for each folder to support the vendor invoice import process.
Document types for Vendor invoice import SharePoint folders
Configuring Electronic Reporting Source for Vendor Invoice Import
Search for the Electronic reporting source in Dynamics 365 Finance and create a new source configuration. Select the Vendor invoice import (FR) format and add a file source. Click on Settings to map the document types you created in the previous step, as shown below.
Electronic reporting source configuration
In the source settings, map each SharePoint folder to its corresponding document type.
Set the Default Mapping for Vendor Invoices in Accounts Payable Parameters
Set the default vendor invoice mapping in Dynamics 365 Finance to ensure imported invoices are processed correctly within Accounts Payable.
Navigate to:
- Accounts payable > Setup > Accounts payable parameters > Electronic documents
AP parameters electronic documents setup
This configuration determines how imported vendor invoices are handled once they enter the Accounts Payable workflow.
Run the Electronic Invoice Import Batch Job
Search for the Imported Vendor Invoice in the Dynamics 365 Finance search bar and find the said batch job.
And here is our vendor pending invoice waiting for our approval and posting!
Since the import has issued a warning, we can see that the file has been moved to the Warning folder.
Importing Vendor E-Invoices for Belgium, Other EU Countries and the UAE
Microsoft’s Vendor invoice import format is based on PEPPOL BIS 3, the UBL standard used across the EU. As a result, the setup in this guide is also the starting point for Belgium and other European countries. You import the same model and mapping, then add any country-specific fields your vendors send.
The UAE e-invoicing model also runs on the Peppol network with UBL invoices. However, the UAE adds its own mandatory fields, so the import format usually needs extending before go-live. For the timeline and the 5-corner model, read UAE e-invoicing explained and our 6-week go-live checklist.
Final Outcome
When the configuration and master data are set up correctly, you can import vendor e-invoices into Dynamics 365 Finance reliably. Each file becomes a pending vendor invoice that reflects the original invoice data, keeps its attachments and follows the tax and matching rules defined in the system.
For organizations implementing or refining e-invoicing in France, Belgium or the UAE with Dynamics 365 Finance, SysBrilliance supports ER configuration, SharePoint and SFTP integration, and validation of the vendor invoice import process.
AUTOMATE THE WHOLE FLOW
From the provider's folder to a clean pending invoice
Collect vendor e-invoices with the free SFTP Connector. Then let SysInvoiceMatch resolve items and match purchase order lines before AP confirms. Your team reviews exceptions instead of every line.
Frequently Asked Questions
How do I import vendor e-invoices into Dynamics 365 Finance?
Import Microsoft’s Vendor invoice import ER configurations, set up vendor tax-exempt numbers, external item descriptions and external unit codes, then create an Electronic reporting source for the folder where files arrive. The Import vendor invoices batch job creates pending vendor invoices in Accounts payable.
Which file format does the standard vendor invoice import support?
The standard format reads UBL invoices based on PEPPOL BIS 3, the format used for e-invoicing across the EU. Other formats need an extended or custom ER format.
Can Dynamics 365 import vendor e-invoices from SFTP instead of SharePoint?
Not out of the box. The standard ER source reads from SharePoint or a manual upload. The free SysBrilliance SFTP Connector collects the files from your provider’s SFTP folder so the same import can run.
Why do imported invoice lines end up on DEFAULT_ITEM?
The import couldn’t find a matching product or purchase order line, so it fell back to the default non-stock item. Check the external item descriptions for that vendor, or use SysInvoiceMatch to map supplier descriptions to items with rules.
Where do imported vendor e-invoices appear?
Under Accounts payable > Invoices > Pending vendor invoices, where they can be reviewed, approved and posted with your normal workflow.