How to detect where the record gets updated when update method is not triggered

(3) Share

Report

Posted on by devgirlX

Hello,

I have an issue that Qty field in Invoice journal line (CustInvoiceTrans) gets wrong value so I want to debug it. It happens when I post free text invoice.

When insert method hits, it gets correct value and during whole process it has correct value but suddenly when it is finished, it resets to 1.

Update method doesnt hit at all.

Any suggestions how can I debug why and where it gets wrong value in the end?

Thanks

Categories:

Dynamics 365 Finance

All responses (6)

Answers (0)

Martin Dráb 230,468 Most Valuable Professional on at

Like (0)

Report

How to detect where the record gets updated when update method is not triggered

To read uncommitted data in T-SQL queries, you can use NOLOCK hint in select statements, e.g. SELECT * FROM CustInvoiceTrans WITH (NOLOCK). Or you can utilize SET TRANSACTION ISOLATION LEVEL.
devgirlX 90 on at

Like (0)

Report

How to detect where the record gets updated when update method is not triggered

How can I detect uncommitted changes in the db?
techAx 8 on at

Like (0)

Report

How to detect where the record gets updated when update method is not triggered

While I was debugging through all references that I found that are pointing to that field, it had everywhere correct value.
Martin Dráb 230,468 Most Valuable Professional on at

Like (0)

Report

How to detect where the record gets updated when update method is not triggered

How have you checked that "during whole process it has correct value"? Did you periodically check uncommitted (!) values in the database? Or do you mean that you merely checked values loaded to a particular variable (which tell you nothing about changes done by any other code)?
techAx 8 on at

Like (0)

Report

How to detect where the record gets updated when update method is not triggered

I tried that, it doesn't hit as well.
Suggested answer

Mohamed Amine Mahmoudi 10,770 Super User 2024 Season 2 on at

Like (0)

Report

How to detect where the record gets updated when update method is not triggered

Hi @devgirlX,

Try validateField or doUpdate method.

Best regards,

Mohamed Amine MAHMOUDI