Cancel & Delete a Sales Order Packing Slip gives updateConflict Exception - Please help

(0) Share

Report

Posted on by DJRM

1,447

Hi,

I am trying to cancel and delete a sales order packing slip but AX gives me an UpdateConflict exception. Please help. I am sure that I am the only one using AX so it really confuses me why there is an updateConflict.

4466.w.PNG

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

DJRM 1,447 on at

Like (0)

Report

RE: Cancel & Delete a Sales Order Packing Slip gives updateConflict Exception - Please help

Also, there is an outer ttsbegin/ttscommit (not shown on the image).

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (1)

Report

RE: Cancel & Delete a Sales Order Packing Slip gives updateConflict Exception - Please help

Hi,

There are couple of things that need to be changed. If you delete the record from packingslipjour, it automatically deletes it from packingslipTrans as delete action of type cascade is defined on table CustPackingSlipTrans and no need to explicitly delete packingslipTrans. (Path: \Data Dictionary\Tables\CustPackingSlipJour\DeleteActions\CustPackingSlipTrans)

Next, write the statement packingSlipJour.reread() before delete statement and remove update while selecting the record and use following statements:

packingSlipJour.reread();

ttsbegin;

packingSlipJour.selectforupdate(true);

packingSlipJour.delete();

ttscommit;

Hope this helps you.

Was this reply helpful? Yes No
DJRM 1,447 on at

Like (0)

Report

RE: Cancel & Delete a Sales Order Packing Slip gives updateConflict Exception - Please help

Here are my updated codes:

Are these okay now?

Was this reply helpful? Yes No
DJRM 1,447 on at

Like (0)

Report

RE: Cancel & Delete a Sales Order Packing Slip gives updateConflict Exception - Please help

Yes and it worked but when I try to create a new packing slip using salesFormLetter, no packing slip was created.

Was this reply helpful? Yes No
Chaitanya Golla 17,225 on at

Like (0)

Report

RE: Cancel & Delete a Sales Order Packing Slip gives updateConflict Exception - Please help

Hi,

When you say new packing slip is not getting created is it through form UI (or) through some x++ code.

Was this reply helpful? Yes No
Brandon Wiese 17,788 on at

Like (0)

Report

RE: Cancel & Delete a Sales Order Packing Slip gives updateConflict Exception - Please help

Why would you ever delete a customer packing slip? The UI doesn't let you do it, and for good reason. You can cancel and correct them, to 0 if necessary, but you should leave the records of posted journals.

Was this reply helpful? Yes No