Wednesday, February 7, 2018
Add field description / txt to Customer Aging Report detail for AX 2012 R3
1. Add field to table: CustAgingReportTmp. (i.e. field: my_txt)
2. Update class: CustAgingReportDP, method: insertCustAgingReportTmp
2.a. add new variable:
CustTrans _custtrans;
str 200 my_txt;
2.b. add process to update temp table CustAgingReportTmp:
update_recordSet custAgingReportTmp
setting my_txt = _custtrans.Txt
join _custtrans
where custAgingReportTmp.Voucher == _custtrans.Voucher
&& custAgingReportTmp.AccountNum == _custtrans.AccountNum;
return custAgingReportTmp;
2.c. Compile the class
2.d. Build > Generate Incremental CIL
3. Edit SSRS Report : CustAgingReport
3.a. update/refersh Datasets
3.b. add my_txt field to the report.
4. Good Luck !!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment