web
You’re offline. This is a read only version of the page.
close
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 / Microsoft Dynamics AX (Archived) / GeneralJournalEntry - ...
Microsoft Dynamics AX (Archived)

GeneralJournalEntry - recreate records

(0) ShareShare
ReportReport
Posted on by E.Zgurova 165

Hello everyone,
We have a little problem. One record is deleted from GeneralJournalEntry and two (related to this journal) records from GeneralJournalAccountEntry. So we inserted these lines through SQL but there's a relation missing and I don't know how to recreate it. There are no original documents related to these records, no Ledger Transaction Base(Transaction origin). No nothing = problem with Trail balance. Is there any way to recreate these relations? Or any table record I'm missing (as far as I know only these three lines have been deleted).
Thank you in advance, people!

*This post is locked for comments

I have the same question (0)
  • XB Profile Picture
    XB 1,875 on at

    In the created records did you create the right relation?

    GenerealjournalAccountEntry.generalJournalEntry == GeneralJournalEntry.recId

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

    Hi Elena,

    How was it possible to have these entries deleted? The better approach would be restoring a backup if these entries were in a recent backup. Are you sure only these three records were deleted? They can have references to some other tables. You have to check them all to make sure you don't have database inconsistencies.

  • E.Zgurova Profile Picture
    E.Zgurova 165 on at

    An update:

    the balance is 0 - zero!

    I added the subledger voucher in SubledgerVoucherGeneralJournalEntry. The references are OK now - everything looks just fine - origin, sum. But this is when i look into account transactions. When I open Trial balance, choose financial dimension set and display values do not match the transactions.

    Something like:

    In the List Page View:

    Debit - 1000, credit - 1010, balance - -10

    But when you check the transactions, the sum of debit and credit is 1000 and -1000, so the balance should be 0..

  • E.Zgurova Profile Picture
    E.Zgurova 165 on at

    Hi, Javier,

    Yes, the relation is correct.

    Hi, Andre,

    It is from like a month ago, not that recent. The reference is the table I mentioned in the "update"post.

    So references, vouchers, amounts - everything looks correct as i compare it to other similar transactions.

    The thing is - a month ago something had happened and the second we invoiced some items - they were missing. Nothing specific - just additional journal with empty transactions which takes these items out of our warehouse, financially, physically. So the journal is deleted with its content.

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

    Hi Elena,

    The balances for the trial balance are taken from another table. You can try to rebuild the balances for each Dimension set. You can find this option in the General Ledger menu > Setup > Financial dimensions > Financial dimension sets.

    The rebuild will build the balances table from scratch using the accounting entries (GeneralJournalEntry + GeneralJournalAccountEntry)

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Sukrut Parab Profile Picture

Sukrut Parab 2 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans