Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / July 8, MS update issu...
Finance | Project Operations, Human Resources, ...
Suggested answer

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

(1) ShareShare
ReportReport
Posted on by M Christopher 46
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?
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,735 Super User 2024 Season 2 on at
    July 8, MS update issue: Write failed for table row of type 'VendInvoiceJournalLineEntity'.
    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.
  • Suggested answer
    M Christopher Profile Picture
    M Christopher 46 on at
    July 8, MS update issue: Write failed for table row of type 'VendInvoiceJournalLineEntity'.
    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?
  • M Christopher Profile Picture
    M Christopher 46 on at
    July 8, MS update issue: Write failed for table row of type 'VendInvoiceJournalLineEntity'.
    @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.
  • Suggested answer
    Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    July 8, MS update issue: Write failed for table row of type 'VendInvoiceJournalLineEntity'.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,735 Super User 2024 Season 2 on at
    July 8, MS update issue: Write failed for table row of type 'VendInvoiceJournalLineEntity'.
    Hi M Christopher,
     
    Are there some changes related to this entity or what changes were applied to your environment?  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,735 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans