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

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / System hangs when Mark...
Microsoft Dynamics AX (Archived)

System hangs when Marking to settle open transactions for a customer?

(0) ShareShare
ReportReport
Posted on by Rana Anees 1,813

Hii,

When we Mark an open transaction for a customer, it takes very long time for one line to select, some times one hour.

We do customer invoice settlements from GL -> General journal.

It is happening for all the customers. Even customer has one or hundred open invoices. 

All of our AX users facing this issue even admin as well.

Please see the screen shot. What could be the possible reason and solution. Thanks 

customer-settelement.png

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello Rana Anees,

    How many open transactions do you have in your system? Are these millions of transactions or a couple of thousands?

    Do you know whether some modifications have been made to the settlement functionality e.g. in regards to importing customer/vendor bank statement files?

    Best regards,

    Ludwig

  • udaY-ch Profile Picture
    udaY-ch 5,139 on at

    Hi,

    What is the AX version and localization that you facing an error.

    Best,

    Uday.

  • Rana Anees Profile Picture
    Rana Anees 1,813 on at

    Its Dynamics AX 2012 R7 and CU7. Base currency is SAR.

  • Suggested answer
    udaY-ch Profile Picture
    udaY-ch 5,139 on at

    Hi,

    I hope this seems to be an issue with Ax 2012 R2 and there is a similar issue with the AP settlement area.

    Take a look on the below thread,

    community.dynamics.com/.../154442

    Issue have been solved,

    1.By removing unused configuration keys

    2.By creating new index.

    I'm not sure, by removing configuration will work for your case because that is something related with purchase area but creating an index in custTrans table could solve your issue. This solution can work and cannot work, please have a round testing before going forward.

    This has been done after doing a lot of research and performance monitoring to figure out the cause of the slowness and it is highly recommended to practice the solution in dev and test environment and make proper testing before moving forward with the solution into production (if in case, this works with your case).

    Best,

    Uday.

  • Rana Anees Profile Picture
    Rana Anees 1,813 on at

    We have two legal entities. And facing this issue in both.

    In CustTransOpen table there are 8500 records.

  • Rana Anees Profile Picture
    Rana Anees 1,813 on at

    Hii @Udhaya Chandran Rajendran ,
    Pleas guide how to create 2.By creating new index.

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

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#1
Nakul Profile Picture

Nakul 2

#3
Umar-Usman Profile Picture

Umar-Usman 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans