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
Solved

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

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
crm written in asp.net / c# 1 74
Hide vba in gp 7 104
Populate Dynamics CRM Case Description with Email Body 8 131
How to place a condition in a filter criteria in t-sql (#2)? 10 55
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
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…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

789 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