Item Ledger Entries Losing Key Details After Posting

(6) Share

Report

Posted on by Sumit Singh

10,079

Hi everyone,

We’ve come across a strange issue in our Business Central environment. Some item ledger entries—posted correctly with types like Transfer, Consumption, Output, etc.—initially show all expected details (Document No., Lot No., Description, etc.). However, after a few days, these details disappear, leaving only the Item Code and Quantity.

We’ve checked for any batch jobs or reports that might be modifying or clearing the data, but haven’t found a clear cause. The issue isn’t consistent—around 10–15 entries per month are affected—and we haven’t been able to replicate it.

Has anyone experienced something similar or found a solution/workaround? Any insights would be greatly appreciated.

Thanks in advance!.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (5)

Verified answer

Mohana Yadav 60,993 Super User 2025 Season 2 on at

Like (3)

Report

I didnt hear anything but can you please enable change log for this table and check?

Or telemetry

Was this reply helpful? Yes No
Sumit Singh 10,079 on at

Like (2)

Report

There is huge volume of data posted every hour so I am not sure whether it will impact performance if I enable change log for ILE. I can heck the telemetry option and share an update.

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

Like (3)

Report

Change log is your best friend. Enable it.

Also use page inspection and check Modified By and Modified At.

I hope you will find the reason.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (1)

Report

It seems that the problem is caused by customization. It is recommended that you uninstall the third-party program and try again.

Thanks.

ZHU

Was this reply helpful? Yes No
Sumit Singh 10,079 on at

Like (3)

Report

Thank you All, for your answers. Let me check all these options and let's see, if we are able to find out what's causing this.

Was this reply helpful? Yes No
Verified answer

DAnny3211 11,397 on at

Like (3)

Report
Hi Sumit 👋

Thanks for your question!

The issue you're describing—item ledger entries losing key details like Document No., Lot No., and Description after posting—is unusual and concerning, especially since it’s intermittent and not easily reproducible.

✅ Here are a few things to investigate:

Customizations or Extensions

Review any custom code or third-party extensions that interact with item ledger entries. Even a small customization could be unintentionally clearing fields post-posting.

Batch Jobs or Scheduled Reports

Double-check all scheduled tasks, especially those that might archive, consolidate, or clean up data. Look for any jobs that run periodically and affect the Item Ledger Entry table.

Data Retention Policies

Ensure there are no retention or cleanup policies configured that might be trimming metadata from entries.

Table Triggers or Events

Review AL code for any OnModify or OnAfterPost triggers on the Item Ledger Entry table that could be modifying records after posting.

Database Logging

If possible, enable Change Log for the affected fields to track when and how they’re being modified. This can help pinpoint the source of the issue.

💡 Since the issue affects only a small number of entries monthly, it may be tied to specific conditions—such as certain item types, locations, or posting groups.

Hope this helps!
✅ Please mark this reply as helpful if it answered your question.
Best regards! 👋

Was this reply helpful? Yes No
Verified answer

Sohail Ahmed 11,136 Super User 2025 Season 2 on at

Like (2)

Report

That’s not standard BC behavior item ledger entries don’t lose data after posting. This usually points to a customization, extension, or integration overwriting fields. I’d suggest turning on Change Log for Document No./Lot No. to catch what’s modifying them. Most likely it’s not BC itself but something external.

✅ Mark this as the verified answer if helpful.

Was this reply helpful? Yes No