How to update the item ledger entries in the database ?

(1) Share

Report

Posted on by LLEV

Hello,

Unfortunately our item ledger entries have been created with the wrong "Posting Date" and I would like to update them with the "SystemCreatedAt" Date. Is there a way to update the value stored in the database not simply for the reports?

Thanks in advance,

Ludovic

Categories:

Dynamics 365 Business Central

All responses (5)

Answers (2)

Sort by

Suggested answer

Dynamics_Decoded_Gokul 487 on at

Like (2)

Report
Copy link

Link copied!

Hi,

If your are a developer,

Create a processOnly report

Select dataItem as Item Ledger Entry.

trigger OnAfterGetRecord()

use this trigger write a code for updating the posting date as system created date

item ledger entry modify.

provide permission for item ledger entry in the Permission property.

but changing this will impact the difference between ledger and subledger.

Correct way to do this reversing and posting the document again.

Thanks
Gokulnath
Gerardo Rentería Ga... 27,623 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi

In this case you need to reverse the operation, we are not only talking about the item ledger entry table.

Please revise.

Dynamics 365 Business Central: Reverse Postings (Undo, Correct, Cancel, Reverse Transaction…) | Dynamics 365 Lab (yzhums.com)

BR

GR
LLEV 73 on at

Like (1)

Report
Copy link

Link copied!

Thanks you both for your prompt answer.

GR: This is a great post and I'll definitely keep it in my marks, but in my case I was looking for a mass update solution like Gokulnath proposed even though I understand it is definitely not recommended.
Verified answer

Jun Wang 8,222 Moderator on at

Like (2)

Report
Copy link

Link copied!

the proper way is create a credit memo to reverse it and then create a new one with correct posting date

Jun Wang
Verified answer

YUN ZHU 103,712 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

This may cause data inconsistency if you modify it directly from the code.

But technically, it is possible.

As with the standard, you only need to add the Permisions property to the executed code.

Hope this helps as well.

Thanks.

ZHU