Small and medium business | Business Central, N...

Import multiple purchase invoices

(8) Share

Report

Posted on by STP

541

Hi all,

There is an user requirement ----- they have a file which content multiple invoice details, e.g. multiple lines in excel, but the format is JSON or XML, is it possible to import this file into Business central, and then create multiple purchase invoice?

I only find that there is an excel template of Purchase invoice header and lines from Configuration package we could use, but most likely it couldn't fulfil the user requirement.

Thank you so much.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

Jinal P. 300 on at

Like (2)

Report

Hi,

In Business Central, we can use XMLPorts to import and export data records from external sources. Please see the reference link below — hope this helps you.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-xmlport-object

https://yzhums.com/4809/

Thanks

Was this reply helpful? Yes No
Suggested answer

Bilal Haider 414 on at

Like (2)

Report

Hi,

Rapid Start configuration package is only out of the box solution that can help you creating purchase invoices from a file. But as you mentioned that it does not fulfill user requirements. So other ways are only to customize.

Most simple way is to create xmlports for header and lines and then it will import data directly to the table.

Otherwise you can create codeunit or report that read the file and insert data, or you can use APIs as well.

Was this reply helpful? Yes No
Ahmad Subhani 585 on at

Like (2)

Report

Only one feature is available in business central regarding that and that is Rapid Start.

https://www.linkedin.com/pulse/d365-bc-rapidstart-part-1-ahmad-subhani-gqnbf/

Mark the Answer as Verified if this is Helpful.

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,202 Super User 2025 Season 2 on at

Like (2)

Report

You are correct saying BC uses excel template to import invoice headers and lines to bulk create documents, but I haven't come across other ways to achieve the same. Maybe you need to get consultation from a developer to figure out if this is feasible.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,739 Super User 2025 Season 2 on at

Like (4)

Report

Hi, hope the following helps.

Dynamics 365 Business Central Blog Series: Import and Export data

https://yzhums.com/63762/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (2)

Report

Hello,

It requires custom development, as the standard Excel-based configuration packages don't support these formats.

May this can help : https://yzhums.com/4809/

https://docs.zynk.com/workflow/documentation/dynamics-365-business-central/import-purchase-invoices.html

Was this reply helpful? Yes No
Suggested answer

Kamal Khakhkhar 1,282 on at

Like (4)

Report

Hii There,

as per your requirement if you have data in XML Format you can get that using XML Port like as per my given reference link you dont need to update format of you data into other as per this.

https://youtu.be/q0K5_7vX6wA?si=dwbHCjZ2oHrz_Bit

If you found answer mark It answered.

Thank You,

Kamal Khakhkhar

Was this reply helpful? Yes No
Suggested answer

Jeffrey Bulanadi 8,760 on at

Like (2)

Report
Hi STP,

You're absolutely right — the standard Configuration Package in BC only supports Excel or CSV formats and doesn’t natively handle JSON or XML for bulk purchase invoice creation.

Here’s what you can do to meet the requirement:

If the source file is in JSON or XML, you’ll need to transform it before importing. BC doesn’t include a built-in parser for structured JSON/XML invoice data.

You can use Power Automate or Logic Apps to read JSON/XML from a file or API, convert it to a BC-compatible format, and create purchase invoices via the BC connector.

Alternatively, you can build a custom API page in AL that accepts structured invoice data and handles creation logic directly in code.

For a no-code option, consider converting the JSON/XML to Excel using a script or tool, then use the Purchase Invoice Import add-on from AppSource. It allows flexible field mapping and bulk creation without strict templates.

Helpful references:

How to Import Invoices into Dynamics 365 BC – DocuClipper
Importing Purchase Invoices via XML – Zynk Docs
Bulk invoice import discussion – Dynamics Community
How to Easily Import Data – Encore Business Solutions

If you find this helpful, feel free to mark this as the suggested or verified answer.

Cheers
Jeffrey

Was this reply helpful? Yes No
Suggested answer

Mansi Soni 8,909 Super User 2025 Season 2 on at

Like (4)

Report

Hello @STP,

Yes, it is possible to import a JSON or XML file with multiple invoice details into Business Central, but this requires a custom integration. You can build a custom codeunit or web service that parses the JSON/XML and creates purchase invoice headers and lines using AL code. The standard Configuration Package only supports structured formats like Excel or CSV, so it won’t fulfill this requirement. Alternatively, you can use Power Automate or Azure Logic Apps to process the file and call Business Central APIs to create the invoices.

Hope this answer will help you!

Regards,
Mansi Soni

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,150 Super User 2025 Season 2 on at

Like (2)

Report

Yes, it’s possible but would require customization. You can build a custom API or XMLport to parse the JSON/XML file and create multiple purchase invoices programmatically in Business Central. Work with a developer or your Microsoft partner to design this import logic.

Mark this as the verified answer if helpful. ✅

Was this reply helpful? Yes No