I am trying to update invoice status. Everything works fine except there is only 1 user who could not update it. The thing is that the problem is very random.
For example: This user A, when he runs the job to update invoice status for 4 invoices call invoice 1, 2, 3, 4. The status of invoice 1 and 3 are not updated. When he rerun the second time, the status of invoice 1, 4 are not updated. However, when I asks user B(exact same privileges) to run, everything works fine. I even create a new user to try, and everything works fine too. When i check the table, for this user A the record that are not updated have the recversion value set to 1, while for other users, the record have the recversion value set to random number.
Base on this article http://daxdude.blogspot.sg/2013/02/ax-issue-cannot-edit-record-in-sales.html , it is a concurrency problem, but when i check my code, i have the "forupdate" keyword:
select firstonly forupdate InvoiceStatus
from custTransSummary
where custTransSummary.RecId == invoiceSummaryRecId;
I also try to following this link: http://daxdude.blogspot.sg/2013/11/dynamics-ax-2012-resetclear-your-users.html to clear the user cache data by go to File > Tools > Option, then select Usage Data. But it still does not solve the problem
Can anyone help me point out how could I go to solve this problem?
Delete the users .AUC file from disk? https://community.dynamics.com/ax/b/axaptavsme/archive/2015/04/26/how-to-delete-auc-files