Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Cannot create a record...
Finance | Project Operations, Human Resources, ...
Answered

Cannot create a record in Ledger journal table (LedgerJournalTable).

(0) ShareShare
ReportReport
Posted on by Rashmi 32
Hi Team,
 
Getting below error while opening the transaction in general ledger module general journal in AX2012,
 
Performed below steps to identify the issue, but still the issue is recurring again & again.
 
1. Full CIL, cleared cache & auc files
2. Number seq set to continuous 
3. Num seq status list also cleared, it's fine once status list is cleared but again the issue is raising .
 
 
Regards,
Rashmi
  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 230,198 Most Valuable Professional on at
    DIXF _ Cannot create a record in Ledger journal table (LedgerJournalTable).
    I believe the discussion about why you shouldn't be using continuous number sequences, for instance, may be useful for others. Therefore there is a change that users would lose if we deleted the thread. I'm not going to do it.
  • Rashmi Profile Picture
    Rashmi 32 on at
    DIXF _ Cannot create a record in Ledger journal table (LedgerJournalTable).
    Hi Martin,
     
    Ok I will raise new post Can I delete this entire conversation, because which is not helpful for others as well
     
    Regards,
    Rashmi
  • Martin Dráb Profile Picture
    Martin Dráb 230,198 Most Valuable Professional on at
    DIXF _ Cannot create a record in Ledger journal table (LedgerJournalTable).
    The description and the screenshot about are about a problem with a form. You also said you had a problem with other number sequences as well, but it's been resolved.

    Now you want to talk about a problem with data import, but that will be a new discussion, which will start by asking you to explain what you're doing, we'll discuss your DIXF setup and so on. It's not what this thread was about and I'm not going to start a discussion about something else from scratch here.

    If you see it differently, please explain. Otherwise simply describe your problem with data import in a new thread.
  • Rashmi Profile Picture
    Rashmi 32 on at
    DIXF _ Cannot create a record in Ledger journal table (LedgerJournalTable).
    Hi Martin,
     
    Apologies for the wrong thread that was updated earlier.
     
    After multiple trials & investigation, came to know this error is because DIXF. Now I edited thread as DIXF......
     
    Can you confirm/advise me is it mandatory step to save journal before importing the transaction through DIXF process.
     
    Thanks in advance,
    Rashmi
  • Suggested answer
    Rashmi Profile Picture
    Rashmi 32 on at
    Cannot create a record in Ledger journal table (LedgerJournalTable).
    Hi Martin,
     
    Can you suggest me, Journal which is created in General ledger module should be saved first before importing the transaction through DIXF?
     
    If yes then this issue is resolved. 
     
    Regards,
    Rashmi
  • Martin Dráb Profile Picture
    Martin Dráb 230,198 Most Valuable Professional on at
    Cannot create a record in Ledger journal table (LedgerJournalTable).
    Yes, I understand that you have a problem with data import, but this thread is about "Getting below error while opening the transaction in general ledger module general journal"
  • Suggested answer
    Rashmi Profile Picture
    Rashmi 32 on at
    Cannot create a record in Ledger journal table (LedgerJournalTable).
    Hi Martin,
     
    Issue is not yet resolved still facing the error as "Cannot create record in ledger journal table"
     
    This error is occurring only when we are doing journal import through DIXF process, not sure where it is going wrong all set up's are correct.
     
    Regards,
    Rashmi
  • Martin Dráb Profile Picture
    Martin Dráb 230,198 Most Valuable Professional on at
    Cannot create a record in Ledger journal table (LedgerJournalTable).
    It's great that your problem has been resolved. Please don't forget to verify the answer.
     
    Regarding your other problem (with data import), please create a new thread next time and explain your problem in detail there, instead of changing the topic of an existing thread.
    Anyway, are you saying that the import doesn't work when you try to import a journal with no ID and it works if you generate and assign an ID? Then it make sense; a journal needs an ID.
    To eliminate the manual ID generation and assignment, configure your import project mapping to auto-generate values of the ID field.
    If you mean something else, please explain in the new thread.
  • Suggested answer
    Rashmi Profile Picture
    Rashmi 32 on at
    Cannot create a record in Ledger journal table (LedgerJournalTable).
    Hi Martin,
     
    Error: Cannot create a record in ledger journal table, Name GL_Genjnl is appearing only for DIXF process.
     
    When we try to import journal for general ledger module (General journal) we create journal batch number# first to update in DIXF file while creating if we save & then try to import click on lines this error is not appearing.
     
    If we do not save the journal & try to import, click on lines of general journal we are getting error (Cannot create a record in ledger journal table, Name GL_Genjnl).
     
    Is there anyway system itself has to save & refresh, allow user to process.
     
    Regards,
    Rashmi
  • Martin Dráb Profile Picture
    Martin Dráb 230,198 Most Valuable Professional on at
    Cannot create a record in Ledger journal table (LedgerJournalTable).
    Identify the number sequence and check it's Next value. Then look into the table; there probably already is a record with such a value.
     
    This may be caused a wrong data import, wrong change the number sequence setup, a problem in code...

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 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