Dear Dynamics Ax Community,
May i have the advice for the ax sysquery / datasource query for below sql statement:
Select ct.accountnum, ct.name, ct.mandatorycreditlimit, ct.creditrating, ct.creditmax, ctrans.accountnum, sum(ctrans.amountmst), ctrans.paymmode
from custtable ct
inner join custtrans ctrans on ctrans.accountnum = ct.accountnum and ctrans.dataareaid = ct.dataareaid
where ctrans.paymmode in (‘10’,‘20’,‘30’) and ct.accountnum in (‘1003’,‘1009’)
group by ct.accountnum, ct.name, ct.mandatorycreditlimit, ct.creditrating, ct.creditmax, ctrans.accountnum, ctrans.paymmode
order by ct.accountnum asc