Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

again: document (sales) cannot be edited

Status
Not open for further replies.

Alcar

Programmer
Sep 10, 2001
595
US
it's being edited by another user.

This has happened to me once already and for the life of me I cannot remember what I have done to solve it.

I have a 200 transaction batch integration that had some initali difficulties that resulted in tieing dow the first 4 transactions. I finally got all the rest to work.

Now when I try to edit those 4 initial transactions I get the mistical: "Cannot edit document. It's being edited by another user"

Note: I have looked in sy0500 and sy0800 and sy0801 but nothing there that matches or looks wrong.
I tried deleting the locks tables from the tempdb but still nothing.

If I remember correctly there was a table I could go to when I could simply delete the row containing the reference to that document and then I could recreated the transaction for that batch....

any ideas?

Daren J. Lahey
Programmer Analyst
FAQ183-874 contains Suggestions for Getting Quick and Appropriate Answers to your questions.
 
Well this is how I have solved it

I found in the customer table RM00401 that when I queried agains the 3 document numbers I had, they returned with some empty fields and the document status of 1 (what ever that is)
After a copy of the table I ran a delete sql query for those three documents and BINGO!! I was able to recreate the documents for the batch =)



Daren J. Lahey
Programmer Analyst
FAQ183-874 contains Suggestions for Getting Quick and Appropriate Answers to your questions.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top