Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

delete item ledger entry

(0) ShareShare
ReportReport
Posted on by 422

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

  • AbduTeeyech Profile Picture
    AbduTeeyech 422 on at
    RE: delete item ledger entry

    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.

  • Verified answer
    Yogesh Kulkarni_ Profile Picture
    Yogesh Kulkarni_ 1,762 on at
    RE: delete item ledger entry

    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.

  • Verified answer
    ManishS Profile Picture
    ManishS 78 on at
    RE: delete item ledger entry

    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.

  • Verified answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: delete item ledger entry

    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.

  • Maneesha Profile Picture
    Maneesha 5,889 on at
    RE: delete item ledger entry

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

  • AbduTeeyech Profile Picture
    AbduTeeyech 422 on at
    RE: delete item ledger entry

    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.

  • Verified answer
    Maneesha Profile Picture
    Maneesha 5,889 on at
    RE: delete item ledger entry

    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  

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,971 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,846 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans