Finance | Project Operations, Human Resources, ...

Delete action cascade + restricted in d365fo

(1) Share

Report

Posted on by CU10121822-0

944

Hi team,

Pls let me know , how this cascade+ restricted will work?

Suppose I have 3 tables

Table A (Parent)

Table B (Child)

Table C (Grand child)

I have defined delete action = Cascade in table B and

Delete action = Restricted in Table C.

When will trying to delete record from Table A, it will trying to delete record from Table B, because it has "Cascade". Before deleting the record in Table B, it will check whether record is existed in Table C or not.

Here is two possibilities:

If record existed in Table C, and it has "Restricted". So, failed to delete record from both Table A and Table B.

If record is not existed in Table C, then it will delete the record from Table A and Table B.

Am i correct ?

Pls advise. thanks!

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (11)

Answers (0)

Sort by

Suggested answer

Subra 2,163 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @CU10121822-0

Please check the below forum and it has more information about the delete actions.

https://www.d365snippets.com/2021/10/delete-actions-in-dynamics-365-finance-and-operations.html

Thanks,
Subra

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
CU10121822-0 944 on at

Like (0)

Report
Copy link

Link copied!

Subra, Have you checked my example?

Is it correct or not. Pls advise. thanks!

Was this reply helpful? Yes No
Suggested answer

Subra 2,163 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi

Yes, you are correct with both the statements.

Thanks,
Subra

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
André Arnaud de Cal... 306,958 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!
Hi,

Your question is a bit confusing. There are four delete actions:

None

Cascade

Restricted

CascadeRestricted

The title of your question is mentions Cascase + Restricted. Initially, I thought your question was about the 4th option. In the body of the question, you mention Cascade and Restricted separately. With only Cascade or Restricted, then your two assumptions are correct.

Was this reply helpful? Yes No
CU10121822-0 944 on at

Like (0)

Report
Copy link

Link copied!

Hi Andrea, my question is about 4th option only.

Cascade+ Restricted

Could you please let me know based on my above example, how it's worked?

Is i need two tables only for cascade+restricted

Pls advise, thanks!

Was this reply helpful? Yes No
Suggested answer

Deepak Agarwal 9,287 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Let me try to help,

First to clearify my understanding based on details, you defiend action like below

On Table A, delete action for Table B = Cascade

On Table B, delete action for Table C = Restricted

Than, Yes, your understanding is correct. If deleting A cascades to B, but B has a restricted child C, then the existence of C will stop the deletion of B, and therefore the original deletion of A will also fail.
If there are no record exists in table C, then B will be deleted by cascade, and A will also be deleted successfully.

Was this reply helpful? Yes No
CU10121822-0 944 on at

Like (0)

Report
Copy link

Link copied!

Hi Deepak and Andrea,

My question is , only how cascadeRestricted worked practically.

As I mentioned above the example separate cascade and restricted., is it the way to use delete action "cascadeRestricted". If yes then fine.

If not , then pls let me know how will I implement this (cascadeRestricted ) practically.

Pls advise. thanks,!

Was this reply helpful? Yes No
CU10121822-0 944 on at

Like (0)

Report
Copy link

Link copied!

Kindly reply on this pls. thanks!

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 240,585 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You could easily test the behaviour to see it for yourself; you'd have to wait a whole day for an answer.

When you try to delete table C, it'll fail, because of the restricted delete action.

If there was CascadeRestricted between B a C, the delete of A would succeed (and all there would delete), although if you tried to delete B, it would be prevented.

Was this reply helpful? Yes No
Suggested answer

BlessyFreedaJ 47 on at

Like (0)

Report
Copy link

Link copied!
Cascade+Restricted :

A (Parent) B (Child) - Cascade C (Grandchild) - Cascade + Restricted

Deleting C directly - Not allowed (Restricted).

Deleting B - C is deleted automatically (Cascade).

Deleting A - B is deleted, which cascades the delete to C.

In short: Restricted prevents direct deletion of C, but it does not prevent C from being deleted as part of a cascade delete initiated from its parent hierarchy.

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No