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.
Dear Sir,
Thanks very much for your help.
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,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156