AX running slow while opening 'Settle open transactions'.

AX running slow while opening 'Settle open transactions'.

- Make sure there are no Blocks by running 'EXEC SP_Who' and clear the blocks when use see session ID on 'Blk by'
- If the issue still exists, check the query plan and get the bad query
- run 'update statistics with full Scan' on the tables query is using.

This should fix the problem. Otherwise, go to tables manually and run 'Rebuilt' and 'Reorganize' by right + clicking the table.

Example : UPDATE STATISTICS tablename     WITH FULLSCAN