Microsoft Dynamics 365 | Integration, Dataverse...

Report as Finish in AX 2012 post very slow

(0) Share

Report

Posted on by Innoviz Solutions

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.

All responses (2)

Answers (0)

Innoviz Solutions 37 on at

Like (0)

Report

RE: Report as Finish in AX 2012 post very slow

Dear Sir,

Thanks very much for your help.
Suggested answer

Mehdi AMRANI 1,422 on at

Like (2)

Report

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,