BeyondERP.Newsletter
Menu

Job page · Accounts payable

Import one-time vendors and invoices

A public sector periodic task that imports a file of one-time vendor and invoice information into a staging table.

Business process
Process supplier invoices
Menu item
action:VendOneTimeVendorImport_PSN
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 public sector periodic task that imports a file of one-time vendor and invoice information into a staging table.
What you do hereUse this page to create many one-time vendors and their invoices at once when no purchase order or approval is required and no master vendor record exists.
ExampleAn organization needs to pay jury duty, registration payments and customer refunds, but master vendor records don't exist for the payees.
Import one-time vendors and 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

Business processManage accounts payable › Process supplier invoices
Menu pathAccounts payable › Periodic tasks › Import one-time vendors and invoices
Set up firstAccounts payable parameters Microsoft Learn
Used next byProcess one-time vendors and invoices Microsoft Learn
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 you need to pay many vendors you have no regular relationship with, and no purchase order or approval is required.
How oftenOn demand, each time a file of one-time vendors and invoices is ready.
What the output showsStaged one-time vendors and invoices, or an error report listing the entries that failed. No vendors or invoices are created yet.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Accounts payable > Periodic tasks > Import one-time vendors and invoices.
  2. Browse for and select the CSV file with the one-time vendor and invoice information.
  3. In the Account structure field, select the account structure that the invoice accounts follow.
  4. Select OK to import the vendors and invoices into the staging data.
  5. If an error report prints, correct the listed entries in the file and import it again, then run Process one-time vendors and invoices.

Source: Microsoft Learn

Test checklist

  1. No error report printed, or all its entries were fixed.
  2. The number of staged records matches the file.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneYes, before processing: The import only stages data. Correct the file and import again; nothing is created until you run the processing step. Microsoft Learn
If you change it laterLoads one-time vendor and invoice data into a staging table for the processing step. Microsoft Learn
Technical architect

5Technical

Menu itemaction:VendOneTimeVendorImport_PSN Checked in Dynamics 365
FormVendImportOneTimeVendFileUpload_PSN 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:VendOneTimeVendorImport_PSN
Everyone

7Sources