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 !!

No comments:

Post a Comment