Cannot edit a record in Purchase orders (PurchTable). Update must be performed inside a transaction.

(1) Share

Report

Posted on by SII1MNL

1,295

Hello,

I needs help, I am adding up a logic updating a record in the purchTable when I click confirm after the operation is complete it cannot proceed when I use my extension class. Can anyone explain or how is it possible to add a logic once the PO is confirmed? Thank you.

I have the same question (0)

All responses (10)

Answers (2)

Verified answer

Puneet Darji 166 on at

Like (1)

Report

Hi,

If you are getting the error as you mentioned in subject in that case you need to write your logic between ttsbegin and ttscommit.

Was this reply helpful? Yes No
Navneeth Nagrajan 2,438 Super User 2025 Season 2 on at

Like (1)

Report

Hello SII1MNL,

As per your subject, if that's the error that you are facing then ttsbegin and ttscommit is what you need to write your code in.

A few questions:
1. The field that you are trying to update is it a custom field?
2. Which operation are you referring to? Is it that PO after confirmation needs to update details in the PurchTable?
3. Once you click the confirm button, your PO needs to be updated?

If the answer to the third question is yes, then write an event handler on the click event of the Confirm button inside the extension class.

Thanks,
Navneeth Nagrajan | Dynamics 365 Technical Consultant

Was this reply helpful? Yes No
Verified answer

WillWU 22,361 on at

Like (0)

Report
Hi SII1MNL,

As Puneet said, you should put ttsBegin and ttsCommit.

Add ttsbegin before query statement,and add ttscommit after the operation

Just like the following codes:

static void dodelete(Args _args) { InventParameters invent; ttsBegin; select forUpdate invent; invent.doDelete(); ttsCommit; info("Done...."); }

Hope this helps.

Was this reply helpful? Yes No
SII1MNL 1,295 on at

Like (0)

Report

yes a custom field, nothing mandatory, just getting the Description on PO Line 1st line. if it is blank the it will do nothing if there is , then it will get the description to custom field right after it is confirmed.

yes it is number 2. after confirmed

Was this reply helpful? Yes No
Rahul Mohta 21,032 on at

Like (0)

Report

give us more insight as to where the extension code is being written ?

are you using CoC or something else?

Was this reply helpful? Yes No
WillWU 22,361 on at

Like (0)

Report

Hi partner,

I don't think adding an event handler on the click event of the Confirm button is a good choice, if the confirmation didn't come in from the button click, it will doesn't work.

Add post event handlers on the update method of PurchTable,or you can copy the vaild method on PurchFormLetter class

Please refer to the following article about adding event before confirmation.

http://asharpx.blogspot.com/2018/01/how-to-check-custom-validation-on.html

Was this reply helpful? Yes No
Suggested answer

SII1MNL 1,295 on at

Like (0)

Report

Thank you I forgot to add ttsbegin and ttscommit , now it is working.

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

Will ,

Overlayering is not allowed since 8.0 so it is not recommended.

salesConfirmJourCreate class is used during posting confirmation which creates record in CustConfirmJour and CustConfirmTrans. You should look at this class instead and do COC on appropriate method which does posting.

Was this reply helpful? Yes No
WillWU 22,361 on at

Like (0)

Report

Hi Sukrut,

Thank you for guidance.

I'm sorry that my description is not precise.

I mean copy event handlers on PurchFormLetter, please take a look at my link.

Was this reply helpful? Yes No
Puneet Darji 166 on at

Like (0)

Report

Hi,

Please mark the post as answer if your query is solved.

Thanks!

Was this reply helpful? Yes No