Finance | Project Operations, Human Resources, ...

July 8, MS update issue: Write failed for table row of type 'VendInvoiceJournalLineEntity'.

(1) Share

Report

Posted on by M Christopher

Hello,

On July 8th, we MS pushed through some changes to D365FO which seemed to have caused an issue with our Power Automate solution. Now we are receiving the following message:

/An error has occurred. Write failed for table row of type 'VendInvoiceJournalLineEntity'. Infolog: Info: Cannot edit a record in Ledger journal table (LedgerJournalTable)./An update conflict occurred due to another user process deleting the record or changing one or more fields in the record../

Some records are posted and the others error out. My best guess is that it is timing related, i.e. we need to wait 5 seconds between transactions before posting the rest but am not sure.

Any ideas on how we could resolve this?

I have the same question (0)

All responses (5)

Answers (0)

André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi M Christopher,

Are there some changes related to this entity or what changes were applied to your environment?

Was this reply helpful? Yes No
Suggested answer

Hana Xue Microsoft Employee on at

Like (0)

Report

Hi,
This error usually occurs when you are trying to update a table, but the table was previously updated by another operation. For details, you can check this blog：
D365FO – AX – How to resolve error “Cannot edit a record in ….. table (….). An update conflict occurred due to another user process deleting the record or changing one or more fields in the record.” – AX / Dynamics 365 For Finance and Operations blog (d365ffo.com)
And you can also check out another blog with similar issue:
DAX Dude - Dynamics AX: AX Issue: Cannot edit a record in Sales Orders (SalesTable). An update conflict occured due to another user process deleting the record or changing one or fields in the record
Best Regards,
Hana

Was this reply helpful? Yes No
M Christopher 50 on at

Like (0)

Report

@Hana Xue:

I will take a look at the blogs to see if those solves the issues and get back to you.

@Andre Arnaud de Calavon

I don't believe there is any relationship but could be wrong. What I know is the Power Automate script worked perfectly up to July 7th and then on Monday (July 10th) it stopped working. When I checked Feature Management, I saw that new features were introduced into the system:

Every time the script break seems to coincide with when features are added. I will review the blog that Hana suggested and provide an update.

Was this reply helpful? Yes No
Suggested answer

M Christopher 50 on at

Like (0)

Report

So we were able to solve the problem. I had to delete the previous Fin & Ops connector and re-add it.

Someone mentioned it is likely that the connector has to be re-certified every time an update is pushed. If this makes sense, is there a way to manage this?

Was this reply helpful? Yes No
André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi M Christopher,

Maybe Microsoft also changed the connector, but I haven't heard of continuously editing your flows after updates. However, it is a good learning that a kind of connector refresh can actually solve particular issues. Thanks for coming back with this information.

Was this reply helpful? Yes No

Join the conversation

Community site session details

July 8, MS update issue: Write failed for table row of type 'VendInvoiceJournalLineEntity'.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

July 8, MS update issue: Write failed for table row of type 'VendInvoiceJournalLineEntity'.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates