You’re offline. This is a read only version of the page.
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
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.
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (