Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / GeneralJournalAccountE...
Finance | Project Operations, Human Resources, ...
Suggested answer

GeneralJournalAccountEntry refers to non existing GeneralJournaEntry

(0) ShareShare
ReportReport
Posted on by NDZ 120

Hello Community,

I am strugling with an issue in AX 2012 R3 CU8.

From one day to another, our management reporter stop issuing report correctly. I make it short, we found through the query below found on the internet an incoherence between GeneralJournalAccountEntry and GeneralJournalEntry (all created at the same time by a period closing in AX). We have 1035 lines in GeneralJournalAccountEntry refering to 2 GeneralJournalEntry RecId that doesn't exist ...

--transaction details with no associated transaction header information
select * from GeneralJournalAccountEntry  with (nolock)
where GeneralJournalentry not in (select  distinct RECID from GeneralJournalEntry  with (nolock))

My question is simple (I am making some tests at the same time to validate this but your opinion could help) : can I simply and safely delete the 1035 lines from GeneralJournalAccountEntry ?

Many thanks for your help !

Nicolas

  • raymonmon Profile Picture
    raymonmon 102 on at
    RE: GeneralJournalAccountEntry refers to non existing GeneralJournaEntry

    Hi Nicolas,

    Did you ever figure this issue out? I have been experiencing the same issue on my AX. Let me know if you did. Thanks!

    Regards,

    Raymon

  • NDZ Profile Picture
    NDZ 120 on at
    RE: GeneralJournalAccountEntry refers to non existing GeneralJournaEntry

    Hi again Ludwig,

    And thank you for your answer.

    DataMart reset : already try a couple of time > nothing new. I even try a new installation of the process and application service without success

    I have tried to replay the closing process following your advice on test environment with various setup (including "delete close-of-year transactions during transfer") but nothing will delete these 1035 lines. To me they are all alone in the system (reference to a non existing GeneralJournalEntry) ...

    I will speak with Microsoft Monday. Hope they can tell me more about these ghost transactions.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: GeneralJournalAccountEntry refers to non existing GeneralJournaEntry

    Hi Nicolas,

    There is a specific parameter setting for the year end close that can be setup in a way that previously run year end closing transactions are deleted. Can you check with the accountants how they set the GL parameters for that year end closing process? In case, they don't know, share a screenprint of your GL year end closing parameters.

    The other thing that you can do is resetting the data mart especially if there is a variance between Dynamics AX and the MR. Before doing that ensure that all building blocks (rows, columns, reports, ...) are backed up.

    Best regards,

    Ludwig

  • NDZ Profile Picture
    NDZ 120 on at
    RE: GeneralJournalAccountEntry refers to non existing GeneralJournaEntry

    Thank you Ludwig,

    I am going to ask the finance team to check the accounts before and after deletion of the transactions on a test environment. But it's not clear to me if I can do some other check before going live with this deletion.

    About the process behind these lost lines, it's a year closing process  that maybe went wrong (AX crash ?) ...

    Any suggestion on what I can double check (technically or functionally) ?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: GeneralJournalAccountEntry refers to non existing GeneralJournaEntry

    Hello Nicolas,

    Don't simply delete a record from the GeneralJournalAccountEntry!

    This can mess up a lot of things and I would recommend that you check with your accounting team what might have gone wrong.

    It might be the case that this is a problem with the management reporter. Especially if you maintain your system/servers and do not start the MR on time there might be a difference between what you see in GL and what you see in MR.

    Please do some further investigation with your finance team because to me it is not clear what the underlying reason of this issue really is.

    Best regards,

    Ludwig

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,432 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