web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
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

I have the same question (0)
  • 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

  • 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!

  • Community Member Profile Picture
    Community Member 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

    Kumkum,

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

  • 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

    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

  • Community Member Profile Picture
    Community Member 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

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

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
Community Member Profile Picture

Community Member 2

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans