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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Receivables Transactio...
Microsoft Dynamics GP (Archived)

Receivables Transaction Entry edited by another user

(0) ShareShare
ReportReport
Posted on by Community Member

Hi all,

I have a query with a problem I am facing in GP10. I have one of my users who needs to enquire details on a credit note she issued some time ago, from the receivables transactions entry window.

When the user inputs the credit note number and tries to load the document, a message from GP comes up stating that I could not edit this document since it is being edit by another user.

Do you have any idea in which tables the receivables transactions are stored?

Kind Regards

Scubax58

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,619 Super User 2025 Season 2 on at
    RE: Receivables Transaction Entry edited by another user

    Sounds like a lock on the record.  Look in the ACTIVITY and SY00800 tables in your DYNAMICS database and see if there's someone in that record.  Also look in SY00500 in the company db.

  • Community Member Profile Picture
    Community Member on at
    RE: Receivables Transaction Entry edited by another user

    Hi,

    I have checked all tables you mentioned and also checked DYNAMICS..SY00801, TEMPDB..DEX_LOCK, TEMPDB..DEX_SESSION. I have actually cleared all tables in question, except for SY00500, but still gave me the same message when I tried to access the record.

    Thanks and Regards

    scubax58

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: Receivables Transaction Entry edited by another user

    This situation could be possible if information was imported into RM WORK incorrectly or as the result of an interrupted posting.  If, as you say, the activity tables and SY00500 do not show the transaction, there is one last place you could look, but I'd suggest doing the following first:

    1.  Back-up and Restore to a Test Company.

        KB 871973 - Set up a test company that has a copy of live company data by using SQL Server 7.0, SQL Server 2000, SQL Server 2005, or SQL Server 2008

    mbs.microsoft.com/.../KBDisplay.aspx

    2.  Run Check Links on Receivables Open Transaction Files (GP -> Maintenance -> Check Links).

    3.  Run Reconcile on Outstanding Document Amounts (GP -> Tools -> Utilities -> Sales -> Reconcile).

    If this does not resolve your issue, I would suggest opening a Support case with the Receivables Management team to troubleshoot.

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September 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