The Item Ledger Entry does not exist.

(0) Share

Report

Posted on by manish.yadav

1,893

Dear Experts,

Unfortunately one of the user is deleted the 4 entries (4 lines ) from ILE table that's a reason we are facing problem to run the inventory adjustment report. How it is possible to insert the entries again in ILE table. Please help me to resolve it.

Microsoft Dynamics NAV
---------------------------

The Item Ledger Entry does not exist. Identification fields and values: Entry No.='6549428'
---------------------------
OK
---------------------------

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (2)

Hannes Holst 5,767 on at

Like (0)

Report

Depends how it was possible to delete the records (this is not possible normally).

If it's just the records in Item Ledger Entry, I would recommend to restore a backup and export/import then.

Was this reply helpful? Yes No
manish.yadav 1,893 on at

Like (0)

Report

For some security purposes these lines have deleted from sql server query. I think there have some references in other tables. What are these tables that I can delete the data from reference tables. Please suggest me so that we can run the inventory adjustment report.

Was this reply helpful? Yes No
Verified answer

Hannes Holst 5,767 on at

Like (0)

Report

Run the "Navigate"-function on any other Item Ledger Entry and you get an idea which tables are touched during the posting process.

Keep in mind, that Item Ledger Entries do reference on eacht other. The field is "Closed by Item Ledger Entry No.". So you might have to delete other ILE-entries too.

Was this reply helpful? Yes No
manish.yadav 1,893 on at

Like (0)

Report

I appreciate your response. But where I can find the "Closed by Item Ledger Entry No.". Please acknowledge me.

Was this reply helpful? Yes No
Verified answer

Hannes Holst 5,767 on at

Like (0)

Report

Hi,

Sorry, I think I've confused the field with a field of another Table.

In the Item Leder Entries, the entries are linked by each other using the table "Item Application Entry" (ID 339).

Check Codeunit "Show Applied Entries" (ID 5801) for details.

Was this reply helpful? Yes No
manish.yadav 1,893 on at

Like (1)

Report

When I deleted the "Item Ledger Entry" from "Item Application Table". Query is resolved.

Thank you very much.

Once again thank you.

Was this reply helpful? Yes No
Suhail 150 on at

Like (0)

Report

Hi NAV Beginners, im facing this issue now with same scenario of deleting records in ILE, my question that i got error while run a job and i all related link is deleted

so i have been delete the item application entry but still give this error.. do you have any idea..

Was this reply helpful? Yes No