Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Cannot edit a record i...
Microsoft Dynamics AX (Archived)

Cannot edit a record in Subledger journal account entry distribution

(1) ShareShare
ReportReport
Posted on by ian2buckz 105

Hello,

I am attempting to run the Ledger Accounting Currency Conversion job in GL->Periodic->Currency Conversions and I am receiving this error:

0363.123.png

(Cannot edit a record in Subledger journal account entry distribution (SubledgerJournalAccountEntryDistribution).

The record has never been selected.)

We retrieved this snippit from the AOT after digging through the error:

3187.456.png

The logic is trying to update a record, which doesn't exist. For the SubledgerJournalAccountEntry, there are no distributions.

We are at a standstill on this issue.

Has anyone come across this?

*This post is locked for comments

  • ian2buckz Profile Picture
    ian2buckz 105 on at
    RE: Cannot edit a record in Subledger journal account entry distribution

    We created a new legal entity instead of converting currency to get around this error.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot edit a record in Subledger journal account entry distribution

    Hi,

    They found some solution, I have the same problem

    Thanks.

    VUL

  • ian2buckz Profile Picture
    ian2buckz 105 on at
    RE: Cannot edit a record in Subledger journal account entry distribution

    Ludwig,

    OK. I am not crazy on the hotfix side. I could not find any myself.

    The legal entity was bought out by another in a different county.

    I'll see what we can do.

    Cheers,

    Ian

  • Verified answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Cannot edit a record in Subledger journal account entry distribution

    Hello ian2buckz,

    For CU12 there seems no fix available on LCS.

    Because the currency conversion process is quite critical I would recommend that you get into contact with the MS support team.

    They might have additional Infos available how to get this fixed.

    Best regards,

    Ludwig

    P.S. Why do you want/need to change the accounting currency?

  • ian2buckz Profile Picture
    ian2buckz 105 on at
    RE: Cannot edit a record in Subledger journal account entry distribution

    Kumkum,

    Yes, we have a lot of lines of data in that table.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cannot edit a record in Subledger journal account entry distribution

    do you have any data in your SubledgerJournalAccountEntry table

  • ian2buckz Profile Picture
    ian2buckz 105 on at
    RE: Cannot edit a record in Subledger journal account entry distribution

    Ludwig,

    AX2012R3 CU12. I did not see any relevant LCS hotfixes pertaining to this error.

    Thank you!

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Cannot edit a record in Subledger journal account entry distribution

    Hi,

    Which AX2012 version do you operate?

    If you are not on the latest version, have you already checked and installed the hotfixes that are available for FX revaluation problems published at LCS?

    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

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans