Announcements
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
Can you provide more details of what you want to achieve exactly? Are those transactions already posted?
Best regards
Ludwig
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.
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.
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,
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
