Small and medium business | Business Central, N...

Delete item ledger entry from code

(0) Share

Report

Posted on by Shankar

Hi, here I want to delete my Item ledger entries table through Al code in business central , how cam delete it, is there any codeunit please help it's urgent

Thnakyou

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

tanya07 1,638 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Deleting ILEs would definitely will be not good option. It will make the database vulnerable.

What is the purpose of deleting ILEs if I may ask?

Regards,

Tanya Kharbanda

Don't forget to help the community by verifying the answer if your question has been answered. It will let others know that the topic has a verified answer.

Was this reply helpful? Yes No
Suggested answer

NAV_with_Narang 2,384 Moderator on at

Like (0)

Report
Copy link

Link copied!

Deleting ILE may cause accounting mismatches, there is no default codeunit for this, I suggest do not make such a provision unless you are only just doing these for testing

Was this reply helpful? Yes No
Suggested answer

IB-29041624-0 1,191 Moderator on at

Like (0)

Report
Copy link

Link copied!

Like other here have told you. Deleting the Item Ledger Entries is not a good idea. And if you do that there is also a lot of other things you need to delete in your database to not ruin the integrity of your Business Central database.

Technically it is not an advanced operation to do but it requires a lot of other considerations before it is done.

Normally it is only something I would do if I should clear a company of all transactions and then there is probably 30 more tables i need to delete data in to keep the integrity of my system.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 101,600 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, As mentioned by previous experts, please do not delete the Item Ledger Entry table directly.

I just simply share the method. Please don't try.

If you want to modify the posted data in BC, you need to set the Permissions Property for your object first.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-permissions-property

For example,

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No