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

Database Lock in Business Central 27

(7) Share

Report

Posted on by HS-12110736-0

In my business production sandbox, I am getting an error when trying to release production orders, item journals, transfer orders, and sales invoices. I have already restarted the environment, cleared all user sessions, turned off automatic cost posting, and changed the automatic cost adjustment setting from “Always” to “Day” as shown below.

Despite these efforts, the error is still occurring. Please assist urgently, as my clients are getting frustrated.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

OussamaSabbouh 12,803 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

Your posting errors likely come from stuck cost adjustment or posting queues in Business Central.
Run Adjust Cost - Item Entries manually, clear any failed Job Queue Entries, and ensure your Inventory Setup matches (cost posting and G/L accounts).
If still failing, update to the latest BC cumulative build, as known issues exist in v26–27.

Regards,
Oussama Sabbouh

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,732 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hello,

The error persists because it’s likely caused by unresolved cost adjustments, posting setup issues, or negative inventory rather than environment settings.

To fix it, manually run Adjust Cost – Item Entries and Post Cost to G/L, verify all General/Inventory Posting Setup accounts, and check for negative inventory or pending cost entries.

If still blocked, review the detailed error message and disable any conflicting background jobs.

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Sumit Singh 11,757 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi,

Could you please share the error screenshot, it will help further to drill down the probable cause.

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report
Copy link

Link copied!

if this provide some hints: https://learn.microsoft.com/en-us/dynamics365/release-plan/2023wave1/smb/dynamics365-business-central/control-database-locking-behavior

https://yzhums.com/27263/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,055 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Is this caused by customization? BC27 has already implemented simultaneous posting of Item Ledger Entries, so this situation should rarely occur. If it's not enabled, you can try enabling it first.

Thanks.

ZHU

Was this reply helpful? Yes No