Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Report as Finish in AX 2012 post very slow

Posted on by 37

I have a customer using AX 2012 , posting Report as Finish for 500++ Production order per day. What can I do to help post these transaction faster and able to finish the posting in Minutes, not Hours?

Is there anyone who experience this many transaction in AX 2012 Production module?

Really need help.

  • RE: Report as Finish in AX 2012 post very slow

    Dear Sir,

    Thanks very much for your help. 

  • Suggested answer
    Mehdi AMRANI Profile Picture
    Mehdi AMRANI 1,422 on at
    RE: Report as Finish in AX 2012 post very slow

    Hi Innoviz Solutions,

    We have faced this problem with a client for +4000 RAFs a day. as we are using Production module with Advanced Warehouse Management. In this case we started first by using the cleanup jobs (Very helpfull in this cas) here is a link for all the cleanup jobs in AX2012

    community.dynamics.com/.../improving-microsoft-dynamics-performance-cleanup-jobs

    Then you need also to do a trace when you perform a RAF to identify what process is taking that much time then you can do some indexation on the most used ones (Be carefull using to much indexation can lead to performance issues in other areas).

    Then check your database to see if you don't have Tables that are huge and not transactional to know if you are having some tables that needs to be cleaned.

    There are other fields to check for the performance issue but these worked for us and since we made this for our client the RAF is not taking more than 4 or five seconds and by the end of the month 8 to 10 seconds (before closing).

    Regards,

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

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,113 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans