Vendor aging report customization

 Scenario:-In this blog we see customization  of Vendor aging report 

Changes to be done at 3 Levels 

1) Duplicate report and customize as per design

2) Give Report name and design name in controller to open your report.

3) Insertion of data to custom fields if any .

Briefing:- 

1) Duplicate report and customize as per design :-

                                    Design as per your requirement.

2) Give Report name and design name in controller to open your report:- 

Extend the method and override with your report design name:-

   protected final str getReportName(VendAgingReportContract _contract)
    {
        str reportNameLocal;
        next getReportName(_contract);

       
        reportNameLocal = ssrsReportStr(MyVendAgingReport, MyDesignWithNoDetailAndNoTransactionCurCopy1);
            
        

        return reportNameLocal;
    }

3) Insertion of data to custom fields if any :-

As in standard we can't insert again just go for update .

public void processReport()
    {
        
        VendAgingReportTmp vendAgingReportTmploc   = this.vendAgingReportTmp;
        VendTable vendTable;
        DirPartyTable dirpartytable;
        next processReport();
      

        while select vendAgingReportTmploc
        {
            ttsbegin;
            vendTable = VendTable::find(vendAgingReportTmploc.AccountNum);
           
           
            vendAgingReportTmploc.selectForUpdate(true);
            vendAgingReportTmploc.Myfield = vendTable.DirPartyTable().Myfield;
            vendAgingReportTmploc.update();
            ttscommit;
        }

Output:-

Thank you!!