Inserting Purchase Invoice Header and Multiple Lines via API

(5) Share

Report

Posted on by Rajaneesh H

244

Dear Techis,

I need help with inserting a Purchase Invoice Header along with multiple lines using an API.

I have already published the Purchase Invoice page (51, Document), and using the OData API URL, I’m able to successfully insert the header and a single purchase invoice line.

However, I’m encountering issues when trying to insert multiple lines using the provided payload.

Below are the API URL and example payload for reference.

Could you please suggest me on how to achieve this?

API URL : http://xxx:7448/BC/ODataV4/Company(xxxx')/PurchInv

Payload example

{
"Document_Type": "Invoice",
"Buy_from_Vendor_No": "xxx",
"Vendor_Invoice_No": "xxx",
"Posting_Date": "2025-03-10",
"Purchaser_Code": "APPROVED",
"grPurchInvPurchLines": [
{
"Line_No": 10000,
"Type": "G/L Account",
"No": "610"
},
{
"Line_No": 20000,
"Type": "G/L Account",
"No": "612"
}
]
}

Thanks in Advance!!

Categories:

Dynamics 365 Business Central migration

Dynamics 365 Business Central

Microsoft Dynamics NAV

Microsoft Dynamics RMS

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Jainam M. Kothari 14,083 Super User 2025 Season 2 on at

Like (2)

Report
Inserting Purchase Invoice Header and Multiple Lines via API

Hello,

To insert multiple lines in a Purchase Invoice using the OData API in Business Central, you need to ensure that the payload is correctly structured and that the API endpoint supports batch operations.

Here’s a step-by-step guide to help you achieve this:

Ensure Batch Operations are Enabled: Verify that your OData service supports batch operations. This allows you to send multiple requests in a single HTTP call.

Modify the Payload: The payload you provided seems correct, but you need to ensure that the lines are properly nested within the header. Here’s an example of how the payload should look

Use Batch Request: If your OData service supports batch requests, you can send multiple operations in a single HTTP request. Here’s an example of how to structure a batch request

Check for Errors: Ensure that there are no errors in the payload structure or the API endpoint. You can use tools like Postman to test your API calls and debug any issues.

Was this reply helpful? Yes No
Gerardo Rentería Ga... 24,213 Most Valuable Professional on at

Like (2)

Report

Inserting Purchase Invoice Header and Multiple Lines via API

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

Extending standard APIs (2) – Kauffmann @ Dynamics 365 Business Central

Deep insert with Business Central APIs (part 2) – Kauffmann @ Dynamics 365 Business Central

Best Regards
Gerardo

Was this reply helpful? Yes No
Ramesh Kumar 7,523 Super User 2025 Season 2 on at

Like (1)

Report

Inserting Purchase Invoice Header and Multiple Lines via API

Please make sure API payload are correct configured and pointed to purchase order line table not the header table.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/cloudmigrationapi/cloud-migration-api-overview

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 94,436 Super User 2025 Season 2 on at

Like (2)

Report

Inserting Purchase Invoice Header and Multiple Lines via API

Hope the following can give you some hints.

Solved: A custom purchase order API issue is occurring while deep inserting in Business Central

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Rajaneesh H 244 on at

Like (1)

Report

Inserting Purchase Invoice Header and Multiple Lines via API

Thank you, @YUN ZHU !! Your solution was incredibly helpful. I was able to successfully deep insert multiple lines of records into the Purchase Invoice Document. However, when I used the expand functionality to check the response for purchase invoice lines, it returned blank. Interestingly, the lines are visible in the application.

Was this reply helpful? Yes No