Hi,
For testing, i have replicated ILE from HO to Store. Now I cannot delete it in the store database, showing permission error.
Any other way to clear Item ledger entries?
Regards,
Abdul Rahman.
*This post is locked for comments
Thanks all,
I was doing this as part of my learning, to replicate the ILE to the store test server and check if there is any way to block negative inventory sale fro POS level.
Now, I deleted the ILE from the sql.
Thanks again.
Abdul.
For an Item Ledger Entry, with the help of developer, you can navigate the Transactions and delete all the ledgers related to that transaction. By this you will nullify all the ledger entries.
-Yogesh Kulkarni
Please verify, if you find answer helpful.
You cannot delete ILE, posted documents.
What you can try is to create a page and give permission on that page, and the try to delete.
For deleting ILE you need to have developer license as it is posted entry. You can not delete with customer license.
You can write codeunit for deleting those entries by providing proper permissions in codeunit.
Please note it is not recommended to delete ILE entry from system which will make your db vulnerable and will not have record for tracing as it is connected to lot of tables
You can reverse the entry and pass correct entries in ILE.
what kind of permission error you are getting ? can u paste it here
hi maneesha,
I know this NAV rule, not to allow users to delete the ILE.
I am doing it in the store server, no posting is done in shop server, so no worries about deleting ILE.
there must be any code unit to run clear ILE Table.
Abdul.
Hi Abdul Rahman T H ,
This might be happen by several way
make sure you have enough DB level to grant permission by DB admins
development environment permission allowed
also its grate if you can paste the error message/screen shot
NOTE : Any way Deleting ledger entries is not a good thing also we cannot recommend it , if it is not effect much keep as it is
if you wanna change some thing (In/out/change) you can use several programs for it
André Arnaud de Cal...
291,971
Super User 2025 Season 1
Martin Dráb
230,846
Most Valuable Professional
nmaenpaa
101,156