Bulk Purchase Invoice Uploads to Microsoft Dynamics 365 Business Central

(7) Share

Report

Posted on by CU03070051-0

I am an Accountant interested in using the Microsoft Dynamics 365 Business Central Configuration Vendor Tables 38 Purchase Header and 39 Purchase Line to post multiple Purchasing invoices in one posting. Can anyone familiar with this process provide some guidance?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (6)

Sort by

Verified answer

Mansi Soni 10,176 Super User 2026 Season 1 on at

Like (6)

Report
Copy link

Link copied!

Hello,

https://yzhums.com/16530/
https://learn.microsoft.com/en-us/dynamics365/business-central/ui-batch-posting

Hope this resources will help you to achieve the same.

Regards,
Mansi Soni

Was this reply helpful? Yes No
Verified answer

Kamal Khakhkhar 3,422 on at

Like (4)

Report
Copy link

Link copied!

Hii There as per your requirement you can go as per mansi suggested . in that check validations so in some of cases found some of errors as per validations in fields.

https://yzhums.com/16530/

mark it answered if you found answer.

Thank You.

Kamal Khakhkhar.

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,177 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Maybe this give you a hint to resolve your problem

https://community.dynamics.com/forums/thread/details/?threadid=9ccc7784-81c5-4f8f-a824-441c92f80acf

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 101,995 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hi, hope the following helps as well.

Dynamics 365 Business Central Blog Series: Import and Export data

https://yzhums.com/63762/

Thanks.

ZHU

Was this reply helpful? Yes No
Verified answer

Andrés Arias 5,192 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hello,

If possible, I recommend to check the following link:

https://yzhums.com/16530/

I hope I can help.

Regards,

Andres

Was this reply helpful? Yes No
Verified answer

Jeffrey Bulanadi 9,123 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi

If you're looking to post multiple purchase invoices in one go using Tables 38 and 39, there are a couple of solid options depending on how you want to approach it

Here’s what you can try

Use the Batch Posting feature in Business Central to post multiple documents at once. You can select several purchase invoices from the list and post them together. This is built-in and doesn’t require custom development

If you're importing from Excel or another system, consider using the Purchase Invoice Import add-on. It lets you bulk upload invoices and credit memos from Excel without needing a strict template. You choose the fields you want to import, and it handles the rest

For automation, you can also set up Job Queues to post invoices in the background, which helps avoid performance issues during work hours

If you're comfortable with AL development, you can write a codeunit that loops through your data and inserts records into Tables 38 and 39, then calls the posting routines

There’s a walkthrough video showing how to use Excel with the Bulk Purchase Invoice Creation App that might help visualize the process

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

Cheers
Jeffrey

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

Gerardo Rentería Ga... 27,087 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Hi, good day
I hope this can help you, and give you some hints.

Dynamics 365 Business Central: How to post document/journal via Power Automate | Dynamics 365 Lab

Best Regards
Gerardo

Was this reply helpful? Yes No