Announcements
No record found.
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
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.
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
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.
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
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 757 Super User 2026 Season 2
YUN ZHU 451 Super User 2026 Season 2
AndrewThomas81 391 Super User 2026 Season 2
