• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 487
  • 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
invoice.
But if I want to save the detail items using econnect while the invoice is
opened
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                              
 
SOPNUMBE = INV2002
SOPTYPE = 3
Related Error Code Parameters for Node : taSopLineIvcInsert                  
               
UpdateIfExists = 1
 

please advise me what to do.
thank you
0
RamyBouchra
Asked:
RamyBouchra
  • 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,
0
 
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
fast.

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,
0
 
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.
0
 
RamyBouchraAuthor Commented:
thank you and i will do that

0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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