Skip to main content

Notifications

Announcements

Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Ledger and Accounting ...
Microsoft Dynamics AX (Archived)

Ledger and Accounting Distribution

(0) ShareShare
ReportReport
Posted on by Peter John 288

Hi,

I want a record from the accounting distribution table based on the relation ledger table. Are these tables have any interrelations?

Please give me some advice on this...

*This post is locked for comments

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Ledger and Accounting Distribution

    Hi,

    Please check the hotfixes that have been released for currency conversions on LCS first before making a change to your system.

    I had a quick look and found a couple of hotfixes related to what you are trying to do.

    Another thing is understanding why you want to change the reporting currency.

    Why is this done and what do you try to achieve with that conversion?

    I am asking this because specific reporting scenarios cannot be handled with the reporting currency feature in AX2012 and before making a change or implementing hotfixes, it would be great to know what you try to achieve.

    Best regards,

    Ludwig

  • Peter John Profile Picture
    Peter John 288 on at
    RE: Ledger and Accounting Distribution

    Hi, Ludwig

    I have done Ledger reporting currency conversion afterward I got an error 'Cannot edit a record from Subledger Journal account entry distribution' The record has been never selected. 

    3581.Question.png

    The SubLedgerJournalAccountEntryDistribution.subledgerjournalaccountentry field does not have the records this is cause for the error. 

    So, I have to create a corresponding record to avoid the error.

    The SubLedgerJournalAccountEntryDistribution table have 5 Fields

    AccountingDistribution, Parent Distribution, Subledgerjournalaccountentry, AccountingCurrencyAmount, ReportingCurrencyAmount.

    Subledgerjournalaccountentry, AccountingCurrencyAmount, ReportingCurrencyAmount these fields getting the values in SubLedgerJournalAccountEntry table. Based on the relation in Ledger Table 

    Ledger -> General Journal Entry -> General Journal Account Entry -> SubLedgerJournalAccount // Relations

    AccountingDistribution, Parent Distribution these fields are getting the value from Accounting Distribution Table.

    I have to insert the above two fields but I do not know about relations to get the value from Accounting distribution. 

    Please advice on this kindly.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Ledger and Accounting Distribution

    Hi,

    Can you provide more details of what you want to achieve exactly? Are those transactions already posted?

    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

News and Announcements

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Microsoft Dynamics AX (Archived)

#1
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 100 Super User 2025 Season 1

#2
Community Member Profile Picture

Community Member 48

#3
Zain Mehmood Profile Picture

Zain Mehmood 6 Moderator

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans