web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Cash receipt applied t...
Microsoft Dynamics GP (Archived)

Cash receipt applied to invoices

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    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,

  • Community Member Profile Picture
    Community Member on at

    Thank you so much.  that is exactly what happened.  We did get a GP Guy to find it for us.

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    You are most welcome

    If this is resolved, please feel free to close the case accordingly.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans