How to delete related records, when a record is deleted? How to recalculate data after the deletion?

(0) Share

Report

Posted on by Community Member

Hi,

I want to ask for an advise on what approach should I use, as I have the following scenario:

After a record (say Assignment) is deleted in the AX 2012, all the related records (say Time Entries) should be deleted, and a complex recalculation should be triggered for another reporting record (containing all the Assignments that are remaining).

I am new to Axapta and I have a few years experience with CRM.

I will check the Axapta SDK today, but from what I understand, I can have a workflow to delete the related entities, once the Assignment is deleted, but the recalculation might be quite complex to be handled by the workflow itself... so what could I use for it? Or should I use something else instead of a workflow for the entire process?

Thanks.

Best Regards,

Evgeni Dyulgerov

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (3)

Verified answer

Florian Hopfner 2,461 on at

Like (0)

Report

The deletion scenario you describe is usually done by using delete actions on the tables. These allow you to automatically delete records in related tables.

For the recalculation, you can add an event handler to the delete method of the assignment table to trigger the recalculation logic.

Was this reply helpful? Yes No
Verified answer

Sukrut Parab 71,710 Moderator on at

Like (1)

Report

Workflow is not suitable in your scenario. Delete action can take care of your fist question. Read more about delete action on below link. Regarding recalculation you can do that in pre event handler.

docs.microsoft.com/.../how-to-create-delete-actions

Was this reply helpful? Yes No
Verified answer

Hossein.K 6,648 on at

Like (1)

Report

as mentioned , and also event handler:

www.erpsoftwareblog.com/.../event-handling-in-microsoft-dynamics-ax-2012

Was this reply helpful? Yes No