I am getting below error while moving one of my report code from AX 2012 to Visual studio to build the same for D365 F&O. can someone help me to rewrite the code and clarify the issue with it. It works fine with AX 2012.
select sum(AmountCurDebit), avg(ExchRate) from _ledgerJournalTrans1 order by OffsetLedgerDimension asc group by LedgerDimension where _ledgerJournalTrans1.AccountType == LedgerJournalACType::Vend && _ledgerJournalTrans1.OffsetAccountType == LedgerJournalACType::Bank && _ledgerJournalTrans1.TransactionType == LedgerTransType::Payment && _ledgerJournalTrans1.LedgerDimension == _ledgerJournalTrans.LedgerDimension && _ledgerJournalTrans1.OffsetLedgerDimension == _dimAttrValueCombination.RecId;
Error:- Column 'OffsetLedgerDimension' is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause
The error message is correct - ordering by OffsetLedgerDimension doesn't make a good sense if it never has any value (because it's neither grouped by nor aggregate it). If you're saying that you're satisfied with the behavior anyway, you can simply remove the order by clause.
Was this reply helpful?YesNo
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.
636
Share
Report
All responses (
Answers (
