CustAging report D365fo

Creating custom fields in Custom aging report and getting data from CustTrans fields.

1. Create extension for class CustAgingReportTmpFromCustTmpAccountSum
2. Global variables
   • public CustAgingReportDPParameters cdp;
   • public CustTmpAccountSum tmpAccountSum;
3. Get tmp table instance in newFromCustAgingReportDP method
   • public static CustAgingReportTmpFromCustTmpAccountSum newFromCustAgingReportDP(CustAgingReportDPParameters _custAgingReportDPParameters)
   • {
   • CustAgingReportTmpFromCustTmpAccountSum instance = next newFromCustAgingReportDP(_custAgingReportDPParameters);
   • instance.cdp = _custAgingReportDPParameters;
   • return instance;
   • }
4. COC fpr onExecuted
   • protected void onExecuted()
   • {
   • next onExecuted();
   • CustAgingReportTmp custAgingReportTmp = cdp.custAgingReportTmp;
   • tmpAccountSum = cdp.custTmpAccountSum;
   • ttsbegin;
   • update_recordset custAgingReportTmp
   • setting customTxt = custTrans.Txt
   • join custTrans
   • where custTrans.AccountNum == custAgingReportTmp.AccountNum
   • && custTrans.Voucher == custAgingReportTmp.Voucher
   • && custTrans.TransDate == custAgingReportTmp.TransDate;
   • ttscommit;
   • }