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

Could not update the data in Sales Order After Posted

(0) Share

Report

Posted on by RevanthM

Hi Team,

We are facing the below error,

"We could not update the data right now. Please try again later. Technical details : A record in table G/L Entry was locked for use in another session. Administrators can see current locks on the Database locks page or use telemetry."

Once this error thrown, it has been created a Posted Sales Shipment and Posted Sales Invoice Document, But it has not updated the Sales Line (Quantity Shipped) value for partial shipment and invoice. If we did fully shipment and invoice also, quantity shipped value was not updated and sales order document has not been deleted.

Note : The entries in the posted document are updated correctly.

Thank you!

Regards

Revanth

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

MahGah 15,529 on at

Like (0)

Report

Hi

Just checking to see if at the time of error you had a chance to check database lock to see who is locking the database? We had something similar (in other area) and we find one of customization cause database lock. in another case some finance report was causing this error (we switched them to Read-Only).

Also, do you use any G/L account in your SO (something like shipping charge)?

Was this reply helpful? Yes No
Robert Jolliffe 885 on at

Like (0)

Report

We've seen this kind of behavior when there is a badly written code that runs between clicking the post button and the post routine ending.

The "it has not updated the Sales Line (Quantity Shipped)" makes me think this is custom code. You should be able to look at the "Help/About this page" or whatever it's called in the help screen and it will list the extensions running on this page. Are there any custom extensions?

Was this reply helpful? Yes No
RevanthM 55 on at

Like (0)

Report

Hi @MahGah,

Thank you for your response. Yes, we are using G/L account in Sales Order

Was this reply helpful? Yes No
RevanthM 55 on at

Like (0)

Report

Hi @Robert,

Thank you for your response. We are not able to see the failure message in Telemetry to know more about which extension was causing this error. Is there any other way to troubleshoot this further.

Thank you!

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (0)

Report

Hi RevanthM

Seems like Robert provided some feedback. I hope that help. is it possible that someone is entering transaction for the G/L account that is in SO at the same time and that is why that account is locked?

Do you see this issue in all shipments or on a few of them? Is it in certain time of the day or all day long?

Thanks

Was this reply helpful? Yes No