You’re offline. This is a read only version of the page.
286
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
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
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.
Hi,
Can you provide more details of what you want to achieve exactly? Are those transactions already posted?
Best regards
Ludwig
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (