Purchase Invoice Import

The Purchase Invoice Import add-on allows a bulk import of several Purchase Invoices and Purchase Credit Memos into Business Central from a regular Excel file. You can select what fields you want to import, and the add-on will put all the values in the right places – no need to follow a template!

This can be useful for organizations who enter more than 10-15 invoices into Business Central weekly, as Purchase Invoices and Credit Memos will now be uploaded in bulk, simply by entering them into Excel and running the import.

Users can focus on the fields that are relevant to them in their import file, without worrying about all the additional fields on the Business Central application.

The add-on will perform validations to make sure that any required fields have been entered, codes are valid, dimension values exist, etc.

Once the Excel file is ready, run the import in Business Central, select the Excel file, and that’s it! The add-on will create all the invoices and credit memos within a few seconds.

Watch the demo/training video:

Click Here for a Free Trial on Microsoft AppSource

Filling in the Excel File

Lighthouse Experts Group will provide your team with a list of fields to choose from – you can then pick which Purchase Invoice/Credit Memo fields you want to use in your import file.

Download the list of available fields here

If there is a custom field, or other non-standard field you want to use in your import – let us know!

The point is – each user decides which fields are relevant to them, which fields they want to use in their import, and they choose the ordering of the fields in their file.

This means different users can use different templates, or the same user can use different templates depending on the types of invoices they want to import. The add-on dynamically adjusts to whatever template you choose.


Running the Purchase Invoice Import in Business Central

Once the app has been installed, use the Search button to run the “Purchase Invoice Import”

Screenshot 2023-04-19 at 5.26.36 PM

You will then be presented with a pop-up window that asks you to select the Excel file to import:

Screenshot 2023-04-19 at 5.26.43 PM

To do this, press on the Ellipsis button (…), select “Choose…”, then select the Excel file to import:

Screenshot 2023-04-19 at 5.31.56 PM

Once the file is selected, press OK.

Screenshot 2023-04-19 at 5.32.23 PM

You will be presented with a progress window while the invoices and credit memos are being created.

Screenshot 2023-04-19 at 5.33.52 PM

When the import is complete, the import will show a message saying “Import Successful” along with the number of lines that were imported from the Excel file.

Screenshot 2023-04-19 at 5.34.01 PM

You will now see the imported invoices on the Purchase Invoices page. They are now ready for you to review, send for approval, or post.


Click Here for a Free Trial on Microsoft AppSource