Deadlocks in Sales Invoice report

poppins · 2016-06-21

Hi evryone,

I made a customization in the Sales Invoice report, in the OnAfterGetRecord trigger of the Sales Invoice Header dataset.
I added a code that is modifying the sales invoice lines (the physical ones, not the temp ones).
Can that be source of deadlocks when many users run the report in the same time?

Thanks in advance

Marije_Brummel · 2016-06-21

Yes

RockWithNAV · 2016-06-21

Hey Poppins,

Yes and Locking is something which will come.You should design your code a better way and should use Rec.Locktable to avoid it. It will give you a level of relaxation but not like it will never come again.

Deadlocks in Sales Invoice report

Answers

Categories