delete item ledger entry

(0) Share

Report

Posted on by AbduTeeyech

428

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

I have the same question (0)

All responses (7)

Answers (4)

Sort by

Verified answer

Maneesha 5,891 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
AbduTeeyech 428 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Maneesha 5,891 on at

Like (1)

Report
Copy link

Link copied!

what kind of permission error you are getting ? can u paste it here

Was this reply helpful? Yes No
Verified answer

Amol Salvi 18,698 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

ManishS 86 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

Yogesh Kulkarni_ 1,762 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
AbduTeeyech 428 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No