We have a payment that we need to apply to the customer invoices. The process was started, but the customer has paid incorrectly. Today was are unable to pull up the payment to look at again. We are getting the message "you cannot display this record while another user is editing it" How do we determine the user editing it. The payment is showing applied to invoices, however we cannot find the payment in the cash receipts batch it was entered into yesterday.
*This post is locked for comments
You are most welcome
If this is resolved, please feel free to close the case accordingly.
Thank you so much. that is exactly what happened. We did get a GP Guy to find it for us.
Apparently, there is a corrupted record somewhere. Initially, run the below queries after you make sure that all users are logged out the system
SELECT * FROM DYNAMICS..ACTIVITY SELECT * FROM DYNAMICS..SY00800 SELECT * FROM DYNAMICS..SY00801 SELECT * FROM TEMPDB..DEX_LOCK SELECT * FROM TEMPDB..DEX_SESSION
If the above retrieved any records, you do need to proceed with the below queries
DELETE DYNAMICS..ACTIVITY DELETE DYNAMICS..SY00800 DELETE DYNAMICS..SY00801 DELETE TEMPDB..DEX_LOCK DELETE TEMPDB..DEX_SESSION
At this point, you may proceed with the un-apply process for the transactions, since in AR transactions are not automatically moved to history.
Let us know if you need any further assistance,
Share
Report
All responses (
Answers (
32,738
