Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / SourceDocumentHeader, ...
Microsoft Dynamics AX (Archived)

SourceDocumentHeader, SourceDocumentLine, AccountingEvent, AccountingDistribution and SubledgerJournalAccountEntryDistribution Records are getting deleted from posted Vendor Invoices

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Dear All,

I am using MS Dynamics AX 2012 R3 (Kernel and Application versions: 6.3.164.0) and we are using Procurement categories to process PR to Invoices Cycle. The system was implemented in 2015 and there is no further upgrade due to some heavy customizations in HR module. In 2018, we noticed that for some of the invoices, the relevant records are getting deleted automatically during Vendor Invoice Posting process from following tables:

  1. AccountingDistribution
  2. AccountingEvent
  3. SubledgerJournalAccountEntryDistribution
  4. SourceDocumentHeader
  5. SourceDocumentLine

The issue is at alarming stage now as the system is deleting the records from above tables for already posted invoices randomly from the previous years i.e., 2015, 2016, 2017, 2018 etc.

Just to add up, there is no customization in the invoicing or accounting distribution process except in Vendor Invoice Report

Looking forward from your support in this regard.

*This post is locked for comments

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: SourceDocumentHeader, SourceDocumentLine, AccountingEvent, AccountingDistribution and SubledgerJournalAccountEntryDistribution Records are getting deleted from posted Vendor Invoices

    Hello Muzammil Ahmad,

    Please get a developer involved asap who can help debugging this code.

    It might also be smart getting the MS support involved here as deleting such records is a serious issue from an accounting perspective. I would trying getting them involved in parallel to doing some internal investigations.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SourceDocumentHeader, SourceDocumentLine, AccountingEvent, AccountingDistribution and SubledgerJournalAccountEntryDistribution Records are getting deleted from posted Vendor Invoices

    As I mentioned there is no customization in the invoicing process except Vendor invoice report.

    We started to face this issue early 2018. However, the number is increasing with an alarming percentage. now we have around 800 invoices out of which 600 infected records are from previously posted invoices.

  • SouravDam Profile Picture
    SouravDam 11,721 on at
    RE: SourceDocumentHeader, SourceDocumentLine, AccountingEvent, AccountingDistribution and SubledgerJournalAccountEntryDistribution Records are getting deleted from posted Vendor Invoices

    Hi fawad343 ,

    You are facing this issue since when?

    Posting of any new transactions should not create impact in any posted transactions. However, are you sure that nobody ran the sysdatabasetransdelete by mistake and stopped the process in between which ultimately deleted few records from ERP?

    Best regards,
    Sourav Dam

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans