BeyondERP.Newsletter
Menu

Job page · Accounts payable

Import vendor invoices

A periodic task that imports vendor electronic invoices in PEPPOL-based formats (including the German XRechnung format) by using Electronic reporting.

Business process
Import supplier invoices from a third-party solution in Dynamics 365 Finance
Menu item
Action:VendInvoiceImport_W
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA periodic task that imports vendor electronic invoices in PEPPOL-based formats (including the German XRechnung format) by using Electronic reporting.
What you do hereUse this periodic task to bring incoming electronic vendor invoices into Finance as pending vendor invoices, identifying vendors, products and purchase orders from the file data.
ExampleVendor invoice files are placed in a SharePoint folder that is set up as the source, and the import runs in the background; vendors are identified by their tax-exempt number.
Import vendor invoices page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

When to run it

When to run itWhen electronic vendor invoices in PEPPOL or XRechnung format arrive in the source folder.
How oftenOn demand or on a recurring batch schedule while invoices arrive.
Batch settingsSchedule it as a recurring batch job reading the SharePoint source so new invoice files are picked up.
What the output showsPending vendor invoices matched to vendors, products and purchase orders. A file that failed usually has a vendor, product or unit that couldn't be matched; it moves to the failed-files location if one is set.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Accounts payable > Periodic tasks > Import vendor invoices.
  2. On Electronic report parameters, in the File source section, select the Source settings for batch import, or pick a single file when prompted.
  3. Leave the Description field empty.
  4. Make sure vendors carry the tax exempt number used in the files and products have external item numbers; otherwise the import fails.
  5. Select OK, then open Pending vendor invoices to review the imported invoices.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Source settingsThe source location of the invoice files for batch import.Microsoft Learn
Solution architect

4Design impact

Can it be undoneYes, before posting: Imported invoices are pending; delete them before posting if the import was wrong. Microsoft Learn
If you change it laterCreates pending vendor invoices from incoming electronic invoice files and moves the processed files. Microsoft Learn
Technical architect

5Technical

Menu itemAction:VendInvoiceImport_W Checked in Dynamics 365
Roles to set it up and use itTo use itAccounts payable manager VendInvoiceAccountsPayableManagerAccounts payable clerk VendInvoiceAccountsPayableClerkRental manager RentalManagerRental coordinator agent RentalCoordinatorAgentLanded cost agent ITMAgentGive people one of these roles. On this system, 7 roles can run this page.Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=Action:VendInvoiceImport_W
Everyone

7Sources