I have a custom Agreement table with an Agreement No. and a Dimension Value.
On the Sales Order Header, I added an Agreement No. field. The Tender No. field is also located in the Sales Order Header and represents Shortcut Dimension 5.
My requirement is simple:
When the user selects an Agreement No., I want Business Central to automatically take the Dimension Value from that Agreement and populate the Tender No. field in the Sales Order Header.
For example:
Agreement No. 1 → Dimension Value = 11/200/2025
After selecting Agreement No. 1:
Tender No. = 11/200/2025
The Dimension Value already exists in the system.
However, every attempt to update Shortcut Dimension 5 causes this error:
"We can't save your changes right now, because a record in table 'Sales Header' is being updated in a transaction done by another session."
I also tested without the dimension code, and the transaction error still occurred when selecting the Agreement.
Could you please provide the correct AL implementation/code for this scenario, including the correct event or trigger to use, without causing a Sales Header transaction/locking conflict?
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Share
Report
182
All responses (
Answers (
