web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... API's - Use Buffer tab...

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

Suggested Answer

API's - Use Buffer table as the source Table

(1) Share

Report

Report

Posted on by Hein Kruger

666

Hi,
I looked at the Base Sales Order API (https://github.com/microsoft/ALAppExtensions/blob/main/Apps/W1/APIV2/app/src/pages/APIV2SalesOrders.Page.al)

The Source Table is a Buffer table: "Sales Order Entity Buffer";

Is this best practise to use a buffer table prevent deadlocks or why would you not directly use the Sales Header and Sales Line tables?

Thank you in Advance

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Khushbu Rajvi. 22,132 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Using buffer tables in Business Central is primarily for enhancing performance, managing concurrency, and ensuring data integrity during transactions. Buffer tables facilitate optimized data handling, reduce the risk of deadlocks by allowing multiple processes to interact without directly locking primary tables, and help in validating changes before they affect the main data structure. This practice simplifies the API interactions and improves overall efficiency in data processing.

Hope this helps https://yzhums.com/4223/

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 1,949 Super User 2026 Season 1

#2

YUN ZHU 1,064 Super User 2026 Season 1

#3

Khushbu Rajvi. 559 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans