Dear All,
1). If i run the Customer Ageing report (with details) for one customer WGSNSW0850, we can see in below screen shot, same Journal (AR00053912) is being considered twice,
first with Negative value and due date as 9/02/2016 then with positive value and due date 10/03/2016. (Ideally one voucher should be considered once).
2) If we see second screen shot from Cust Trans Table in it if we filter with voucher number (AR00053912), we get two lines one for customer WGSNSW0850 and another for customer WGS0000096,(as this was a balance transfer transaction).
In Cust Trans Table for customer WGS0000096 due date of this voucher is 9/02/2016 and
for Customer WGSNSW0850 the due date is 10/03/2016.
So it looks like in Ageing for WGSNSW085 ,WGS000096 customer’s voucher is also getting added in this case, as one is + and another is -ve, on sum these two are getting nullified in Ageing, so Ageing is showing less than Customer Balance list.
I ran Customer Aging only for customer WGSNSW0850 . Why it's showing transaction line AR00053912 for customer WGS0000096 also.It's should show only one voucher AR00053912.
As per my analysis i debug the classes and put info in to below classes :
1. CustAgingReportDP\processReport()
custVendBalanceList.calculateDetailsForMultipe(qr, contract.parmIncludeAmountCur());
The above line calls class CustBalanceList which inherits from CustVendBalanceList.
In method calculateDetailsForMultiple in CustBalanceList i got below line :
custVendAgingCalculateTmp = agingCalculation.process(_queryRun);
That lines calls out to the process method in the CustVendAgingCalculation class. I put info and debugger in to process().
*** this.insertCustVendData(_custVendQuery);
CustVendAgingCalculation\selectTransactions method
note : It's separated Open and Closed transactions for Customer OR Vendor which is shown in to report.
this.selectClosedTransactions();
this.selectOpenTransactions();
In info it's sowing only one customer WGSNSW0850. why it's taking another customer WGS0000096 voucher AR00053912 in report ?
Finally CustBalanceList\insertIntoTmpAccountSum method in to TmpAccountSum
The TmpAccountSum table is then used by the CustAgingReportDP\processReport method
this.insertCustAgingReportTmp(reverseAmountsAndHeadings)
The contents of the TmpAccountSum are inserted into a CustAgingReportTmp table and this temp table is what is returned to the SSRS report design.
Note : Finally CustAgingReportTmp return only one customer only WGSNSW0850 why it's taking customer WGS0000096 and showing voucher AR00053912 in report ? It's showing 2 vouchers AR00053912 for 2 different customers in report. I ran for only one customer WGSNSW0850.
Please let me know the exact reason why it's happening ? asap.
It's very urgent.
Thanks!
Arpan Sen
