Vendor Aging Report D365FO

Vendor Aging Report D365FO

As we all know customization in Vendor Aging reports or Customer Aging reports is a nightmare.
The same thing I faced in the previous week. when a task was assigned to me to debug the vending Report.

Report elements

 I have done some research in two days on this and found the below information:

1)      Using CustVendTable Map and VendTable Query: Inserting data into CustVendTransAging Table.

(Referà  Class : VendBalanceList :: calculateDetailsForMultiple ->> CustVendAgingCalculation à process method à insertCustVendData() method.

2)      Inserting data into CustVendAgingProcessingTmp table using VendTrans and VendSettlement Tables.

( Refer à Class : CustVendAgingCalculation àselectTransactions()  à selectOpenTransactions() and selectClosedTransactions() methods .

3)      Inserting data into CustVendAgingProcessingDetailsTmp from CustVendAgingProcessingTmp Table

( Refer à Class : CustVendAgingCalculation à selectDetailsOfTransactions()

   Inserting data into CustVendAgingCalculatedTmp using CustVendAgingProcessingTmp Table and CustVendAgingProcessingDetailsTmp Tables.

( Refer : Class : CustVendAgingCalculation:Process method).

5)      Inserting data into VendTmpAccountSum Table using CustVendAgingCalculatedTmp.

(Refer : Class ::VendBalanceList: insertIntoTmpAccountSum())

6)      Inserting data into VendAgingReportTmp Table (which is the main temporary table used for populating data in the report) using VendTmpAccountSum and CustVendTransAging tables.(VendAgingDP class)

I would request you to debug and check the classes above and tables and that would help you get more information.