Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Leave and absence plan cannot be deleted while dependant Leave and absence bank transaction exist. Delete dependant Leave and absence bank transaction and try again.

Posted on by 145

Hi Guys, 

I am getting the error above when trying to delete a plan. However I can't even find this transactions, it also isn't even showing my plan in these tables. Does anyone know what I can do? I am in the right environment

pastedimage1606825417701v1.png

pastedimage1606825464488v2.png

  • Parag Chapre Profile Picture
    Parag Chapre 12,271 Most Valuable Professional on at
    RE: Leave and absence plan cannot be deleted while dependant Leave and absence bank transaction exist. Delete dependant Leave and absence bank transaction and try again.

    That's good.

  • Matt Falle Profile Picture
    Matt Falle 145 on at
    RE: Leave and absence plan cannot be deleted while dependant Leave and absence bank transaction exist. Delete dependant Leave and absence bank transaction and try again.

    Thats done the trick Parag, thank you so much! I am going to try to delete the Plan now.

  • Matt Falle Profile Picture
    Matt Falle 145 on at
    RE: Leave and absence plan cannot be deleted while dependant Leave and absence bank transaction exist. Delete dependant Leave and absence bank transaction and try again.

    Thanks Parag, managed to get them downloaded but still showing 0 records...

    Hang on ignore those, it switched company. They are showing 1 records let me see if I can delete it. 

  • Verified answer
    Parag Chapre Profile Picture
    Parag Chapre 12,271 Most Valuable Professional on at
    RE: Leave and absence plan cannot be deleted while dependant Leave and absence bank transaction exist. Delete dependant Leave and absence bank transaction and try again.

    Go to System Admin > Links > Office integration > Excel workbook designer

    Or just type Excel workbook designer in Search

  • Matt Falle Profile Picture
    Matt Falle 145 on at
    RE: Leave and absence plan cannot be deleted while dependant Leave and absence bank transaction exist. Delete dependant Leave and absence bank transaction and try again.

    How do you open the Excel workbook designer?

  • Parag Chapre Profile Picture
    Parag Chapre 12,271 Most Valuable Professional on at
    RE: Leave and absence plan cannot be deleted while dependant Leave and absence bank transaction exist. Delete dependant Leave and absence bank transaction and try again.

    This is strange.

    I did below and I can see data for entity: Leave and absence bank transaction V2

    Open Excel workbook designer

    Select the entity and select All fields

    Enable editing

    Enter the credentials

    Refresh.

    Make sure you are in the right company and have enough security roles assigned.

  • Matt Falle Profile Picture
    Matt Falle 145 on at
    RE: Leave and absence plan cannot be deleted while dependant Leave and absence bank transaction exist. Delete dependant Leave and absence bank transaction and try again.

    I have done that and waiting as well as refresh and nothing is coming through

  • Parag Chapre Profile Picture
    Parag Chapre 12,271 Most Valuable Professional on at
    RE: Leave and absence plan cannot be deleted while dependant Leave and absence bank transaction exist. Delete dependant Leave and absence bank transaction and try again.

    Can you click on enable editing in excel and wait for loading data.

  • Matt Falle Profile Picture
    Matt Falle 145 on at
    RE: Leave and absence plan cannot be deleted while dependant Leave and absence bank transaction exist. Delete dependant Leave and absence bank transaction and try again.

    Hi Parag,

    I have tried to do the export from data management as you said however am still getting no records. 

    pastedimage1606826619701v1.png

  • Suggested answer
    Parag Chapre Profile Picture
    Parag Chapre 12,271 Most Valuable Professional on at
    RE: Leave and absence plan cannot be deleted while dependant Leave and absence bank transaction exist. Delete dependant Leave and absence bank transaction and try again.

    Hi Matt,

    Did you check the entity: Leave and absence bank transaction V2 from Data management and check the data using excel workbook designer.

    Meanwhile, you can verify data in the entity: Leave and absence plan V2

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans