• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 490
  • Last Modified:

E-Connect Updating invoice while it is opened from Screen ERROR

Dear EE

I am using E-Connect, VS2005, C#
I am working on Sales Transaction Entry screen
The bussinees I want to do is the following:
The user will add the header part and then I want to add in the detail part
many items using Econnect.
this above idea succeded when the user add the header and then save and the
But if I want to save the detail items using econnect while the invoice is
I have this error:  
Sql procedure error codes returned:
Error Number = 2079  Stored Procedure taSopLineIvcInsert  Error Description
= Document is currently being edited by another user
Node Identifier Parameters: taSopLineIvcInsert                              
Related Error Code Parameters for Node : taSopLineIvcInsert                  
UpdateIfExists = 1

please advise me what to do.
thank you
  • 3
1 Solution
RamyBouchraAuthor Commented:
Dear EE

i did do the following:
i went to Tempdb--> dbo.dex_Lock
i deleted a row with my Session ID.
i tested my scenario and it worked fine using EConnect.
I refresh the invoice, data was retrieved, and it was fine too
I edited some information in the invoice and I save it
I reopen my invoice again and it was very good

Please advise me what is the problem using the above scenario?

thank you,
RamyBouchraAuthor Commented:
I want to tell you why I want to do that:

1  In the scrolling window I must add 99 Items and the user will only add
the quantity

2  We have a data entry for invoices daily by thousands, so it must be very

3  I am sure I will not remove other lock for other user

4  The whole idea is that I want the user to add the header part of the
invoice only

Please tell me your opinion.
Thank you,
DBAduck - Ben MillerPrincipal ConsultantCommented:
The lock is put on the item for transactional consistency.  In many cases Dynamics cannot guarantee the transaction if the invoice is open in Dynamics, so that is why there is a lock there.  If you delete it because you know that they will not  be doing anything, that is one thing, but if you are going to do that, you will also buy in that in the event that it does happen, you live with the consequences.

You should have the user add the header part and close the screen.  Then you can add the items via econnect.
RamyBouchraAuthor Commented:
thank you and i will do that

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now