Solved

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

Posted on 2008-10-15
4
467 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
  • 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

867 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now