2,040
|
|
*This post is locked for comments
I got same case and check on spSearchOnAllDB 'CASH RECEIPT VOUCHER'
Something interesting i write on my blog by this link
www.dynamicszr.web.id/.../rm-cash-receipt-when-open-document-show.html
I know that this is an old thread and may have been answered in another question - but to those that find this thread here is the answer to this matter ( at least what worked for me )
In my case - and it appears in the ones above - the user could not open a specific Cash Reciept and so when I was confirming this I completed the following steps in Microsoft Dynamics GP
1. Ensure all users are logged out of GP
2. Log in as SA
3. Open Sales >> Transactions >> Cash Receipts
4. Enter the Receipt number ( that is apparently stuck )
5. Should get the same error message - reason for this is to determine if logging out of users does not free up the document.
Open SQL Server Management Studio and
Make a Backup of the Dynamics DB and the Company DB
Open a new Query window to do the following:
select * from RM00401 where DOCNMBER = '<receipt number>'
- Looking into the Company.RM00401 - RM Keys File
- for the document that you can not open - make a note of the Dex_Row_ID
select * from RM10201 where DOCNMBER = '<receipt number>'
- Look into the Company.RM10201 - Distribution Work and Open
- for the same document - make a note of the DEX_Row_ID
Now in my case, and the one above the Document was partly created in the RM Keys and the RM Distribution Work and Open. If the Document does not show in the RM10201 replace it with the RM10201 and note the Dex_Row_ID as it may be the header that exists and the missing section would be the distribution.
Final step is to remove the partial documents from the RM00401 and RM10201
delete from RM00401 where DOCNMBER = '<receipt number>' and the Dex_Row_ID = <found above>
delete from RM10201 where DOCNMBER = '<receipt number>' and the Dex_Row_ID = <found above>
After this you may need to re-open the Sales >> Transaction >> Cash Reciept window and enter the Document ID, and click on DELETE from the menu bar. This was the final step I needed to remove any reference from the system of that document. After doing this we were able to re-enter the document ( same ID ) and select the various APPLY to documents with no further error.
Hope this helps anyone else.
Hi Ronie,
I have got the same issue as yours. I have tried all the proposed solutions by running scripts in backend and it does not help. I have also found the payment # in RM00401 and RM10101 with missing info. How do you delete the docnumbr in backend?
Thank you in advance for your reply.
Just to share, I got the same issue - the transaction does not exist in the work table RM10201 even in the SY00500.
I tried all soluton above but the warning message still prompting "You cannot display this record while another user is editing it."
I do some research on the SQL server and I found out that the document number that has a problem is in the RM Key File (RM00401) table, I just deleted the document number then it work fine, and the user can proceed now using the same document number.
This fix my issue and hope this will help you. :)
Hi,
The tables SY00800 and SY00801 can be found in DYNAMICS database. Please follow previous advice from our peers and you should be OK. In addition, please look into SY00500 in the company database which may contain the batch that this document is initially saved with.
Cheers,
Dencio
I'm using GP 7.5, in my SQL table don't have sy00800 and sy00801.
Lee,
Follow the following steps
1) Inform all user to log out from GP
2) Most Important Take Backup of Dynamics as will as Production Company Database.
3) Restart your SQL Server serivice
4) Run the following SQL Script
To delete all the records in the specified tables, run the following statements against the Dynamics database. | |
To delete all the records in the specified tables, run the following statements against the TEMPDB database. |
5) Run CheckLink on Receivable Open Transaction
*** AGAIN Most important do not forget to keep backup of your Dynamics as well as Production Company DB before doing any above task.
Hope above solution will help you.
Thanks
Sandip
Hi!
You could try the following:
1. Inform all GP users to logout from GP.
2. Make a SQL Database Backup for Company and Dynamics Database.
3. Stop and Restart the SQL Server.
4. Try Running Checklinks on all items in Sales Series.
Try to enter the Cash Receipt and see whether the error is gone.
Regards,
Mohan
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,436
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
