Disappearing Data in Item Ledger Entries - Inventory gone

(5) Share

Report

Posted on by LG-01031739-0

I'm looking for someone heavily experienced in inventory posting routines in Business Central (v14 on-prem), who might be able to help me unpack a problem and provide a rollback solution.

Below is a screenshot of ALL item ledger entries for a single item, and somehow 21 units have gone missing.

I do know that a business user attempted to post a transfer for this item that returned insufficient inventory errors, and that somewhere behind the scenes, the posting routine turned up incomplete.

In the Item Application Entries table, I have an ILE entry number that should be in the ILE table, but it seems to have disappeared.

Has anyone seen this before? Can anyone advise where else I can look, to determine what can be reversed?

Here is the Item Application Entry that is causing us grief when trying to run the 'Adjust Cost - Item Entries' report. Item Ledger Entry number 462273 does not exist in the ILE table. I do not know how this entry 'disappeared' and what I can do to reverse this Item Application Entry.

Any suggestions are welcome!

Categories:

Dynamics 365 Business Central

Microsoft Dynamics NAV

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (2)

Report

Unfortunately, it is hard to guess what is happening without access to the system, but if you have any customization around posting routine then that would be causing the issue. I have not seen that kind of issue with standard NAV/BC, usually customization causes these issues.

Was this reply helpful? Yes No
Suggested answer

Ramesh Kumar 7,527 Super User 2025 Season 2 on at

Like (2)

Report

Hi,

Item ledger reconciliation is difficult to answer based on the question alone, as it requires reviewing each line and its related tables.

I suggest starting with the latest or top row and checking the related tables it impacts or adjusts, such as sales orders, purchases, and transfers.

If this helped you, please check the box Does this answer your question?

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 31,439 Super User 2025 Season 2 on at

Like (3)

Report

Personally I haven't seen anything like this before. Do you have any customizations related to the inventory posting routine?

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,439 Super User 2025 Season 2 on at

Like (2)

Report

Agree with previous responses, is there any customization that is affecting this?

Was this reply helpful? Yes No
Verified answer

LG-01031739-0 39 on at

Like (2)

Report

All,

Thank you for your responses. I'm sure there is a customization that caused this. However, at the end of it all, what I needed to do was fix the problem since we could not run the Adjust Cost job (it was getting stuck on this entry issue). So, I used a developer license to add in the missing ILE, and then the missing Value Entry, and was able to move on with running the Adjust Cost job.

Considering my own question resolved.

Was this reply helpful? Yes No