Solved

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

Posted on 2008-10-15
4
478 Views
Last Modified: 2008-12-16
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
Comment
Question by:RamyBouchra
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 

Author Comment

by:RamyBouchra
ID: 22718637
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
 

Author Comment

by:RamyBouchra
ID: 22718639
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
 
LVL 24

Accepted Solution

by:
DBAduck - Ben Miller earned 500 total points
ID: 22989378
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
 

Author Comment

by:RamyBouchra
ID: 23181807
thank you and i will do that

0

Featured Post

Technology Partners: 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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question