1,833
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
---------------------------
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..
When I deleted the "Item Ledger Entry" from "Item Application Table". Query is resolved.
Thank you very much.
Once again thank you.
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.
I appreciate your response. But where I can find the "Closed by Item Ledger Entry No.". Please acknowledge me.
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.
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
288,584
Super User
#2
Martin Dráb
225,864
Super User
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (