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.
