web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Customer Open Transact...
Microsoft Dynamics AX (Archived)

Customer Open Transaction Report

(0) ShareShare
ReportReport
Posted on by Community Member

Dear Experts

We face a problem with the customer open transaction per date report as the report taking a long time and some times it issues a time out error message, is there a way to make the report faster

note that there is no customizations in the report but there is a huge amount of data in the tables

thanks

Rabea 

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Customer Open Transaction Report

    Hi Rebea, This system behaviour seems to be very strange and I think that your only chance is to debug and analyze the issue with a technical AX guy. All the best, Ludwig

  • Community Member Profile Picture
    Community Member on at
    RE: Customer Open Transaction Report

    Dear Ludwig

    the problem is that the report is running and getting data viewed on the screen some times and some times issues the above error for the same customer account, we select just one customer

    regards

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Customer Open Transaction Report

    Hi Rebea, Does your report run at all? Have you been able to run it lets say for a single customer and do you have performance issues there? If there is no other option maybe users can try running the report in pieces e.g. customer A-B, C-D, etc. Yet, irrespective of that I would recommend that you talk to your system administrator. I do not know how many data are included in your report but they can probably have a look at the reporting services server and help you getting out the report in a timely manner. All the best, Ludwig

  • Community Member Profile Picture
    Community Member on at
    RE: Customer Open Transaction Report

    The Error Is

    A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond

    any ideas ??

  • Community Member Profile Picture
    Community Member on at
    RE: Customer Open Transaction Report

    dear Ludwig

    thank you for your kind reply, I will try it

    regards

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Customer Open Transaction Report

    Hi Rabea,
    Have you tried the customer balance list report instead?
    It should run faster as it summarizes the transactions by customer.
    Alternatively, you can try to customer account statement report and filter only on the open transactions.
    What you can also try is running the customer open transaction report in batch mode, which should make a significant difference in the time the report runs.
    All the best.
    Ludwig

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans