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

API End point for completed and deleted sales orders

(7) Share

Report

Posted on by CU31031353-0

Hi Team,

Please help us find the completed and deleted Sales orders from the front end with all the amount-related columns.

And help us identify the API endpoint to extract the completed and deleted Sales Orders.

Thanks

Thulasi

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (13)

Answers (0)

Sort by

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

Like (3)

Report
Copy link

Link copied!

Hi

I hope this can help you.

Delete salesOrders - Business Central | Microsoft Learn

Delete Method in MS Dynamics 365 Business Central API. (sauravdhyani.com)

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

Best

GR

Was this reply helpful? Yes No
CU31031353-0 42 on at

Like (3)

Report
Copy link

Link copied!

The below API end point is to Delete a sales order object from Business Central. But I need an API endpoint to get all these deleted Sales orders.

Was this reply helpful? Yes No
KasparsSemjonovs 4,838 Super User 2026 Season 1 on at

Like (5)

Report
Copy link

Link copied!

Once deleted, the orders are no longer there.
You can enable Order Archiving, and then You should be able to get the last archived version number, and filter the values there.

Was this reply helpful? Yes No
CU31031353-0 42 on at

Like (3)

Report
Copy link

Link copied!

Hi Kaspars,

how can we extract the completed / deleted sales orders from API end point?

Is there API endpoint is available to extract the completed / deleted sales orders?

Thanks,

Thulasi.

Was this reply helpful? Yes No
Jun Wang 8,220 Moderator on at

Like (3)

Report
Copy link

Link copied!

you might need to provide more info on what happened.

Was this reply helpful? Yes No
CU31031353-0 42 on at

Like (3)

Report
Copy link

Link copied!

Hi Jun,

We would like to extract the Completed/Deleted Sales orders (The sales order that were moved to archival) OR Sales Order History data using the API endpoint.

Thanks

Thulasi.

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,423 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Hi Thulasi 👋

Thanks for your question!

In Dynamics 365 Business Central, accessing completed and deleted sales orders via the front end and API requires a few considerations:

✅ From the Front End:

Completed Sales Orders are typically converted into Posted Sales Invoices or Posted Sales Shipments. You can view them under:

Posted Sales Invoices

Posted Sales Shipments

Deleted Sales Orders are not retained unless Change Log or Audit Trail is enabled. If enabled, you can track deletions via the Change Log Entries.

✅ API Endpoint for Completed Sales Orders:

Use the Posted Sales Invoice API:
GET /businesscentral/companies({companyId})/postedSalesInvoices

Use the Posted Sales Shipment API:
GET /businesscentral/companies({companyId})/postedSalesShipments

✅ API Endpoint for Deleted Sales Orders:

There is no direct API for deleted records. To track deletions:

Enable Change Log for the Sales Order table.

Use the Change Log Entries API (if exposed) or query the table directly via OData.

💡 Make sure to include amount-related columns like totalAmount, amountIncludingTax, etc., in your API queries or custom API pages.

Hope this helps!
✅ Please mark this reply as helpful if it answered your question.
Best regards! 👋

Was this reply helpful? Yes No
Suggested answer

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

Like (2)

Report
Copy link

Link copied!

Hi, There is no field in the standard API to determine this status. You need to customize a new API to filter it out.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/api/dynamics_salesorder_get?wt.mc_id=DX-MVP-5004336

PS: Dynamics 365 Business Central: Can we extend standard APIs? – Download Standard Source Code for APIs

https://yzhums.com/20960/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,280 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

What do you mean by Completed, (Shipped and Invoiced) if so you can get that information from the posted sales shipments or posted sales invoices but remember there is a possibility of having more than one shipment and invoice for an order and regarding deleted sales orders system does not store them in BC so you cannot access them unless you archive them before deleting, then you can access them from Sales Order Archive but there is no easy way to find if that order is deleted or completed.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/api/dynamics_salesshipment_get

Was this reply helpful? Yes No
Suggested answer

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

Like (2)

Report
Copy link

Link copied!

In Business Central, once a sales order is posted, it becomes a Posted Sales Invoice (and/or Shipment). You can access these via the API endpoint:

/api/v2.0/companies({companyId})/salesInvoices

This will return all posted sales invoices with amounts, customer, and other details. Deleted invoices aren’t available, only those posted and stored in BC.

✅ Mark this as the verified answer if helpful.

Was this reply helpful? Yes No