2 Replies Latest reply on Sep 9, 2015 12:03 PM by Karthik Appsys

    Customer Aging 7 bucket takes too much time for back dated request.

    arunpr

      Dear Team,

       

       

      We are facing an Performance kind off issue in Customer Aging report. When i used to run the customer aging report with Current Dated request,the request completes in 3-5 mins. But when i run the same report with Backdated. The time taken to complete is around 30 mins and over or even more than 1 hour. Is there any performance tuning we need to do.

       

       

      Customer Aging report with this parameter completes in 3-4 minutes

      Parameters : 1000, 2021, ARXAGS, 50308, , Customer, I, B, 2015/09/06 00:00:00, Collections, DETAIL, , , , , , , , , , , , NONE    [[[ Current Date ]]]

       

       

      But when i run the request in old dated it completes more than 1 hour

      Parameters :1000, 2021, ARXAGS, 50308, , Customer, I, B, 2015/01/31 00:00:00, Collections, DETAIL, , , , , , , , , , , , NONE [[[ Backdated]]]

       

       

      Please help in this to sort it out..

       

      Thanks

      Arun Kumar