DynDeveloper.com

DynDeveloper.com

Sign Up Now! Log In

Archives

 

Discussion for the following error 

Sql procedure error codes returned:

Error Number = 9595
Stored Procedure= taSopLotAuto
Error Description = A lot is not available with the selected Expiration Date
Node Identifier Parameters: taSopLotAuto
SOPNUMBE = ORDST2242
SOPTYPE = 2
ITEMNMBR = LOTTED01
LNITMSEQ = 16384
Related Error Code Parameters for Node : taSopLotAuto
EXPNDATE = Note: This parameter was not passed in, no value for the parameter will be returned.

<taSopLotAuto>
  <SOPTYPE>2</SOPTYPE>
  <SOPNUMBE>ORDST2242</SOPNUMBE>
  <LNITMSEQ>16384</LNITMSEQ>
  <ITEMNMBR>LOTTED01</ITEMNMBR>
  <LOCNCODE>WAREHOUSE</LOCNCODE>
  <QUANTITY>15</QUANTITY>
  <LOTNUMBR>LOT1</LOTNUMBR>
</taSopLotAuto>

The first line of code is the hardest. Where to start?

Our mission here is RAD. Rapid Development. To that end, without much discussion, you'll find below the first code that you'll need to write a VSTools modification. The sample code is on the PM Vendor Maintenance window, but any window will do.

We already have some forum postings on the DAG.exe process, this article is intended to be a RAD replacement. Just the minimum code and discussion to get you up and coding.

So, at this point you have modified a Dynamics GP Form in modifier, now we need to get the Modified fields over to Visual Studio so we can code for them.

We use Dag.exe to do that

If you've been around here for any length of time, you'll know that we're not fond of long, overly wordy articles. Our job is to get you coding quickly.

This article contains a snippet of code that will use  to get the next IV Transfer number

This is in GP 2010... it does not occur in GP2015

The error was caused by trying to eConnect a SOP document with an item number that contained a forward slant (/)

We tried troubleshooting with my usual method:

Wrap the data in a CDATA, so it would look like this: <![CDATA[MYITEM/ISBAD]]>

That didn't work

Then we tried using the PRE procedure to encode it and decode it when we got to SQL. (Our PRE and POST primer is here)

I did not solve this, except to tell the customer that they'll need to use the Item Number Changer in the Professional Tools Services Library.

But... there is some discussion of what I tried below.


 
This article contains a discussion on the Batch Header table (SY00500) and how Payables Management uses it
This article contains a discussion on the Batch Header table (SY00500) and how Payables Management Payment Entry uses it
This article contains a discussion on the Batch Header table (SY00500) and how Bill of Materials uses it
This article contains a discussion on the Batch Header table (SY00500) and how Bill of Materials uses it

Today a user asked us for some ADODB example, code to call a stored procedure with parameters. I saw that we didn't have an existing article, so I'm adding it.

Our job here is not to teach you the in-depth machinations of how code works. Our job is to give you code examples so that you can get back to the business of coding faster.

Enjoy.

In asp.net, when using forms authentication, you will often want to allow a user to access a subset of pages (like maybe a contact or about us page)

This snippit of code will allow that.

Error: Unable to update/create PO Line record - POP10110 table

I'm trying to update the Sales Transaction's ITEMNMBR and I'm getting this error "Duplicate LNITMSEQ in SOP10200"

 inside a function I have this code:

Dim doc = XDocument.Parse(strSOPTrans)
'use Linq-to-XML to select just one sop line in the document. 
Dim query = From c In doc.<root>.<eConnect>.<SO_Trans>.<Line>  Select c
'turn it back into a string so we can edit it a little
Dim line As String
For Each element As System.Xml.Linq.XElement In query
RemoveAllInecesaryNodes(element)
line = element.ToString
line = Replace(line, "Line", "taSopLineIvcInsert_ItemsTaSopLineIvcInsert")

Dim sopNumber = element.Element("SOPNUMBE").Value
Dim qty = element.Element("QUANTITY").Value
Dim PRCLEVEL = element.Element("PRCLEVEL").Value
Dim myReader As New StringReader(line)
'Deserialize the XML node from the StringReader into the taSopLineIvcInsert_ItemsTaSopLineIvcInsert object.
Dim oXmlSerializer As New XmlSerializer(GetType(taSopLineIvcInsert_ItemsTaSopLineIvcInsert))
'Cast the deserialized object to a taSopHdrIvcInsert serialization object
Dim otaSopLineIvcInsert As taSopLineIvcInsert_ItemsTaSopLineIvcInsert = CType(oXmlSerializer.Deserialize(myReader), taSopLineIvcInsert_ItemsTaSopLineIvcInsert)
     

With otaSopLineIvcInsert
            .LOCNCODE = newLoc
             .CUSTNMBR = strCUSTNMBR
            .DOCID = strDOCID
            .DOCDATE = strDocDate
             .SOPNUMBE = sopNumber
            .SOPTYPE = SOPTYPE
             .QUANTITY = qty
            .ITEMNMBR = itemnum  ' here I change the item number
             .PRCLEVEL = PRCLEVEL
             otaSopLineIvcInsert.UpdateIfExists = 1
      End With

         itemList.Add(otaSopLineIvcInsert)
Next

and then I do this

 'create the document header
  Dim otaSopHdrIvcInsert As New Microsoft.Dynamics.GP.eConnect.Serialization.taSopHdrIvcInsert
'populate the header
      With otaSopHdrIvcInsert
                'these are the required fields
                .SOPNUMBE = strSOPNUMBE
                .SOPTYPE = intSOPTYPE
                .DOCID = strDOCID
                .CUSTNMBR = strCUSTNMBR
                .DOCDATE = dtDocDate
                .BACHNUMB = strBACHNUMB
                .UpdateExisting = 1
                'this is the field that we're updating. 
                .LOCNCODE = loc
                .CSTPONBR = poNum
            End With
'assign the header to the master
oSOPTransactionType.taSopHdrIvcInsert = otaSopHdrIvcInsert
ReDim Preserve oeConnectType.SOPTransactionType(0)
oeConnectType.SOPTransactionType(0) = oSOPTransactionType

Dim xmldoc As Xml.XmlDocument = eConnectOrderToXMLDocument(oeConnectType)
salesOrderDocument = xmldoc.OuterXml

 eConCall.UpdateTransactionEntity(sConnectionString, salesOrderDocument) 'here I got 2 errors

 ERROR 1: Duplicate LNITMSEQ in SOP10200

ERROR 2: LNITMSEQ already exist on a different Item Number

En los próximos meses la expresa va a migrar de GP a NAV. Mi pregunta es si en este sitio se podrá hacer consultas sobre Dynamics Nav?

 

Saludos.

In the coming months the express will migrate from GP to NAV. My question is whether this site may make inquiries about Dynamics Nav ?
 

Hi,

I am trying to update a payment that exists already and to a Sales order that already exists. I have the SO saving without the payment. however with the payment which is a EFT its giving me an invalid payment type.

 

This works with a SOTYPE of 3, however i am trying to attach it to a sales order and not a invoice

 

Action:

Service Create

 

Current User Name:

KRETEK2\eConnectService

 

Input parameters:

 

Exception type:

Microsoft.Dynamics.GP.eConnect.eConnectException

 

Exception message:

Sql procedure error codes returned:

 

Error Number = 4006  Stored Procedure= taCreateSopPaymentInsertRecord  Error Description = Invalid Payment Type (1=Cash Deposit, 2=Check Deposit, 3=Credit Card Deposit, 6=Credit Card Payment) Node Identifier Parameters: taCreateSopPaymentInsertRecord SOPNUMBE = 2148256 SOPTYPE = 2 PYMTTYPE = 5 Related Error Code Parameters for Node : taCreateSopPaymentInsertRecord PYMTTYPE = 5

 

 

<taCreateSopPaymentInsertRecord>

  <SOPTYPE>2</SOPTYPE>

  <SOPNUMBE>2148256</SOPNUMBE>

  <CUSTNMBR>TEST</CUSTNMBR>

  <DOCDATE>5/5/2016</DOCDATE>

  <DOCAMNT>146.93000</DOCAMNT>

  <CHEKNMBR>EFT00002493</CHEKNMBR>

  <PYMTTYPE>5</PYMTTYPE>

</taCreateSopPaymentInsertRecord>

 

 

Stack Trace:

   at Microsoft.Dynamics.GP.eConnect.EntityMessageProcessor.ExecuteSqlCommands(XElement transactionNode, EntityMessage message)

   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.ProcessMessageImport(EntityMessage message)

   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.EntityImportImplementation(String connectionString, String sXML, Boolean isTransaction)

   at Microsoft.Dynamics.GP.eConnect.eConnectMethods.CreateEntity(String connectionString, String sXML)

   at Microsoft.Dynamics.GP.eConnect.Service.CreateEntity(String ConnectionString, String sXML) Exception type:

Microsoft.Dynamics.GP.eConnect.eConnectException

 

Exception message:

Error Number = 4006 Stored Procedure taCreateSopPaymentInsertRecord  Error Description = Invalid Payment Type (1=Cash Deposit, 2=Check Deposit, 3=Credit Card Deposit, 6=Credit Card Payment) 

 

 

 

Stack Trace:

 

I have a user that is closing out GP Purchase Orders that have not been completed yet and need to stay open. Where would I find the User ID of the employee that is closing the Purchase orders?

We are in the process of testing an upgrade of GP 2010 to 2015.  I am verifying all our integrations will continue to work.  One that is failing is a cash receipts integration.  I have not modified it at all from 2010 to 2015.  The integration maps the following fields:

Batch ID 

Date

Posting Date

Customer ID

Cash Receipt Type (CC)

Amount

Checkbook ID

Check/Card Number

When I run this integration using IM 2015 it fails for customers who do not have a Credit Card ID assigned in the Customer Maintenance Options window, even though I'm passing it in the integration.  This was never a problem in 2010.  Do I need to mass update all my customer records with a credit card ID?  What will happen then if a different credit card is used for a particular transaction?  Why doesn't the same integration work in 2015?

La ventana de cheques Micelanios , que se encuentra en el menú transacciones -> Finanzas no permite crearle un acceso directo ya que esta opción aparece desactivada en el menú File.

La pregunta es : Es posible habilitar esta opción y como se hace?

 

Miscellaneous checks window , (Transactions > Financial > Miscellaneous Checks) does not allow create you a shortcut as this option is disabled in the File menu. The question is : Can you enable this

 


 

Hi All : 

Is there any way i can post a bank transaction entry and bank deposit entry from my .net application to GP through web service ?

 I went through all the list of methods ,but couldnt find any .

 

Thank You ,

Jaswanth

Hi All :

 Is there a way we can get Checkbook balance based on CheckbookID through GP web service ?

 I am trying to retrieve the value related to Checkbook balance in Checkbook maintaince screen ?

Thank You ,

Jaswanth

We recently decided to add LOT TRACKING to a selected group of Items with one specific CLASS ID.  What table(s) in MANUFACTURING do I need to update with LOT CODES so I can process the WOs as they complete?

I have a function to update the Location Code in a SO transaction which is working properly but the problem is that the SO transaction's contact info was changed too. I'm not even touching the sop transaction's address  fields. Maybe I have to...I don't know.

why the transaction's contact info is being modified? how is GP selecting the new contact info?
what are the minimum transactions fields do I need to specify when I want to update the SO transaction?

here is my code

 Sub ModifWarehouse(ByVal strSOPNUMBE As String, ByVal intSOPTYPE As Int16, ByVal strDOCID As String, ByVal strCUSTNMBR As String, ByVal dtDocDate As String, ByVal strBACHNUMB As String, ByVal loc As String, ByVal poNum As String)
        Try
            Dim sConnectionString = ConfigurationManager.ConnectionStrings("eConnectConnectionString").ConnectionString
            Dim intNumberOfLines As Int16 = 0 '0 = 1 line
            Dim salesOrderDocument As String
            'declare our eConnect classes
            Dim oeConnectType As New Microsoft.Dynamics.GP.eConnect.Serialization.eConnectType
            Dim oSOPTransactionType As New Microsoft.Dynamics.GP.eConnect.Serialization.SOPTransactionType
            'this is our custom eConnect Class, you can find it here: http://dyndeveloper.com/thread.aspx?Threadid=1117
            Dim eConCall As New eConnectMethods
            'Done Serializing
            '************************* 
            ReDim Preserve oeConnectType.SOPTransactionType(0)
            oeConnectType.SOPTransactionType(0) = oSOPTransactionType

            Dim z As Integer = 0
            Dim itemList As List(Of taSopLineIvcInsert_ItemsTaSopLineIvcInsert) = ModifWarehouseInOrderLines(strSOPNUMBE, intSOPTYPE, loc, strDOCID, dtDocDate, poNum, strCUSTNMBR)


            For Each item As taSopLineIvcInsert_ItemsTaSopLineIvcInsert In itemList
                ReDim Preserve oSOPTransactionType.taSopLineIvcInsert_Items(z)
                oSOPTransactionType.taSopLineIvcInsert_Items(z) = item
                z = z + 1
            Next

            'create the document header
            Dim otaSopHdrIvcInsert As New Microsoft.Dynamics.GP.eConnect.Serialization.taSopHdrIvcInsert
            'populate the header
            With otaSopHdrIvcInsert
                'these are the required fields
                .SOPNUMBE = strSOPNUMBE
                .SOPTYPE = intSOPTYPE
                .DOCID = strDOCID
                .CUSTNMBR = strCUSTNMBR
                .DOCDATE = dtDocDate
                .BACHNUMB = strBACHNUMB
                .UpdateExisting = 1
                'this is the field that we're updating. 
                .LOCNCODE = loc
                .CSTPONBR = poNum
            End With
            'assign the header to the master
            oSOPTransactionType.taSopHdrIvcInsert = otaSopHdrIvcInsert
            ReDim Preserve oeConnectType.SOPTransactionType(0)
            oeConnectType.SOPTransactionType(0) = oSOPTransactionType

            Dim xmldoc As Xml.XmlDocument = eConnectOrderToXMLDocument(oeConnectType)
            salesOrderDocument = xmldoc.OuterXml

            eConCall.UpdateTransactionEntity(sConnectionString, salesOrderDocument)
        Catch ex As System.ServiceModel.FaultException(Of eConnectSqlErrorCollection)
            Dim strMessage = ex.Detail(0).Message
            MsgBox(ex.Message + ". In ModifWarehouse method")
        Catch ex As System.ServiceModel.FaultException(Of Microsoft.Dynamics.GP.eConnect.eConnectFault)
            Dim strMessage = ex.Detail.Message
            MsgBox(ex.Detail.Message + ". In ModifWarehouse method")
        Catch ex As Exception
            MsgBox(ex.Message + ". In ModifWarehouse method")
        Finally
        End Try
    End Sub

---------------------------------------------

Function ModifWarehouseInOrderLines(SOPNUMBE As String, SOPTYPE As Int16, ByVal newLoc As String, ByVal strDOCID As String, ByVal strDocDate As String, ByVal poNum As String, ByVal strCUSTNMBR As String) As List(Of taSopLineIvcInsert_ItemsTaSopLineIvcInsert) ' Microsoft.Dynamics.GP.eConnect.Serialization.taSopLineIvcInsert_ItemsTaSopLineIvcInsert
        Dim val As Boolean = False
        Dim itemList As New List(Of taSopLineIvcInsert_ItemsTaSopLineIvcInsert)
        Dim sConnectionString = ConfigurationManager.ConnectionStrings("eConnectConnectionString").ConnectionString
        Dim oeConnectType As New Microsoft.Dynamics.GP.eConnect.Serialization.eConnectType
        Dim oSOPTransactionType As New Microsoft.Dynamics.GP.eConnect.Serialization.SOPTransactionType
        Try
            'get an XML document that represents the customer 
            'this uses our SalesTransactionRetrieve class documented here
            'http://dyndeveloper.com/articleview.aspx?ArticleID=173
            Dim oSalesTransactionRetrieve As New SalesTransaction
            oSalesTransactionRetrieve.retrieveSalesTransaction(SOPNUMBE, SOPTYPE)
            Dim strSOPTrans As String = oSalesTransactionRetrieve.SOPDoc

            '==========================================================
            'parse the line
            '==========================================================
            'strSOPTrans is an XML document in string form
            'parse it into XDocument form
            Dim doc = XDocument.Parse(strSOPTrans)

            'use Linq-to-XML to select just one sop line in the document. 
            Dim query = _
                From c In doc.<root>.<eConnect>.<SO_Trans>.<Line>
                Select c

            'turn it back into a string so we can edit it a little
            Dim line As String
            For Each element As System.Xml.Linq.XElement In query
                RemoveAllInecesaryNodes(element) 
                line = element.ToString
                line = Replace(line, "Line", "taSopLineIvcInsert_ItemsTaSopLineIvcInsert")

                Dim sopNumber = element.Element("SOPNUMBE").Value
                Dim qty = element.Element("QUANTITY").Value
                Dim itemnum = element.Element("ITEMNMBR").Value
                Dim PRCLEVEL = element.Element("PRCLEVEL").Value
                Dim myReader As New StringReader(line)
                'Deserialize the XML node from the StringReader into the taSopLineIvcInsert_ItemsTaSopLineIvcInsert object.
                Dim oXmlSerializer As New XmlSerializer(GetType(taSopLineIvcInsert_ItemsTaSopLineIvcInsert))
                'Cast the deserialized object to a taSopHdrIvcInsert serialization object
                Dim otaSopLineIvcInsert As taSopLineIvcInsert_ItemsTaSopLineIvcInsert = CType(oXmlSerializer.Deserialize(myReader), taSopLineIvcInsert_ItemsTaSopLineIvcInsert)
                With otaSopLineIvcInsert
                    .LOCNCODE = newLoc
                    .CUSTNMBR = strCUSTNMBR
                    .DOCID = strDOCID
                    .DOCDATE = strDocDate
                    .SOPNUMBE = sopNumber
                    .SOPTYPE = SOPTYPE
                    .QUANTITY = qty
                    .ITEMNMBR = itemnum
                    'these fields are not required, but they will be 0 or '' if the value is not set
                    .PRCLEVEL = PRCLEVEL
                    otaSopLineIvcInsert.UpdateIfExists = 1
                End With

                itemList.Add(otaSopLineIvcInsert)
            Next
        Catch ex As Exception
            Throw New Exception(ex.Message)
        End Try
        Return itemList
    End Function

Hi All :

When i try to  connect to enconnect from my .net app . I get the following error .

Additional information: There was no endpoint listening at net.pipe://localhost/Microsoft/Dynamics/GP/eConnect/EntityOperations that could accept the message. This is often caused by an incorrect address or SOAP action.

 

I verified the Service if its running or not . Its running as expected .

 

 

Thank You ,

J

Please note that the Primary Vendor ID is 03822 for item 549535.      Where is the Primary Vendor ID assigned and maintained ?  And which GP table ?

 

Thank you,

K. Koehle

 

Hi all,

          I'm working on my first eConnect solution. I have my code in a try, catch, finally block. I currently write it to the screen/ console. My question is how do I write the error message if there is an error message to a SQL table?

catch (System.Exception sysexc)
 
             {
                         Console.WriteLine(sysexc.ToString());
             }

 

Best regards,

Steve

 

Deseo aprender a crear add-ins en visual estudio, pero por mas que intento instalar los componentes no logro que me funcione. no me aparece dynamic en new proyect.

 

yo utilizo GP10.0, Visial estudio 2010 y windows 7. podrian ayudarme para lograr configurar mi maquina e iniciar las practicas con add-ins. 

I want to learn how to create add-ins in Visual Studio, but I try to install more components that I can not work for me . I do not appear in new 'Dynamics' project.

I'm using GP 10, Visual Studio 2010 and Windows 7. Can you help me to set up my machine and start practices with add- ins.

 

Hi All

I am trying to post Bank Transaction Entry from .NET application to GP through eConnect.

After posting and  querying in SQL Server on CM 20200 table, I am able to fetch data, which I posted, but i'm not sure that this posting will complete the Bank Transaction Entry process.

Please let me know if I missed any thing.

XML schema I used is as below, 

<eConnect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<BRBankTransactionType>
<eConnectProcessInfo xsi:nil="true" />
<taRequesterTrxDisabler_Items xsi:nil="true" />
<taBRBankTransactionDist_Items>
<taBRBankTransactionDist>
<Option>1</Option>
<ACTNUMST>XYZ</ACTNUMST>
<CRDTAMNT>20</CRDTAMNT>
</taBRBankTransactionDist>
</taBRBankTransactionDist_Items>
<taAnalyticsDistribution_Items xsi:nil="true" />
<taBRBankTransactionHeader>
<Option>1</Option>
<TRXDATE>05/20/2016</TRXDATE>
<CHEKBKID>ABC</CHEKBKID>
<CMTrxNum>0000000001</CMTrxNum>
<TRXAMNT>20</TRXAMNT>
</taBRBankTransactionHeader>
</BRBankTransactionType>
</eConnect>

Thank You ,

Jaswanth

 

HI All

I write a stored procedure to get check book balance using checkbook id.

How to call the store procedure in .NET application  using econnect.

Thank You ,

Prakash

I would like to include the Customer PO Number on the SSRS Sales Historical Aged Trial Balance. Do I edit the seermHATBSRSWrapper stored procedure? Is there a way to do without editing that stored procedure?

 

Thanks,
Laura

I have a third-party database that resides on my GP Server.  I'd like to create a Smartlist using Smartlist Designer.  It appears that I can't add the tables for the third-party application.  Instead, I will have to create views to the third-party application within the GP Database.  

Is that accurate?  For some reason, I thought that Smartlist Designer would let me touch any database/table on the Dynamics SQL server.  

Thanks 

I'm new to Dynamics GP and need some guidance. We need to import sales orders (XML files) placed in a local folder to GP.

I have gone through the eConnect, MSMQ and incoming webservice documentation. Is there are way import the files without writing an application for this?

 Any help is appreciated.

We are running GP 2010 and using eConnect to integrate inventory adjustment transactions.  We want to force the unit cost per line item on the transaction, but GP seems to be changing our specified costs to the current cost somewhere in the background.  Below is the XML we are submitting.  For the line with item number 07T-10501 we are passing $17.15 as the unit cost.  The integration goes through without error, but then when we look at the transaction in GP the cost is showing $16.71 (the current cost of that item).  How can we get it to persist to the number we are passing, $17.15?

<?xml version="1.0" encoding="UTF-8"?>
 
 
 
-<IVItemMasterType>
 
<eConnectProcessInfo xsi:nil="true"/>
 
<taRequesterTrxDisabler_Items xsi:nil="true"/>
 
<taUpdateCreateItemRcd xsi:nil="true"/>
 
<taUpdateCreateItemCurrencyRcd_Items xsi:nil="true"/>
 
<taIVCreateItemPriceListLine_Items xsi:nil="true"/>
 
<taIVCreateItemPriceListHeader xsi:nil="true"/>
 
 
-<taItemSite_Items>
 
 
-<taItemSite>
 
<ITEMNMBR>LABOR - PRODUCTION1</ITEMNMBR>
 
<LOCNCODE>CREATPRO</LOCNCODE>
 
</taItemSite>
 
 
-<taItemSite>
 
<ITEMNMBR>FLOOR PARTS - PRODUCTION1</ITEMNMBR>
 
<LOCNCODE>CREATPRO</LOCNCODE>
 
</taItemSite>
 
 
-<taItemSite>
 
<ITEMNMBR>613-00043</ITEMNMBR>
 
<LOCNCODE>CREATE294</LOCNCODE>
 
</taItemSite>
 
 
-<taItemSite>
 
<ITEMNMBR>613-00044</ITEMNMBR>
 
<LOCNCODE>CREATE294</LOCNCODE>
 
</taItemSite>
 
 
-<taItemSite>
 
<ITEMNMBR>617-00004</ITEMNMBR>
 
<LOCNCODE>CREATE294</LOCNCODE>
 
</taItemSite>
 
 
-<taItemSite>
 
<ITEMNMBR>617-00005</ITEMNMBR>
 
<LOCNCODE>CREATE294</LOCNCODE>
 
</taItemSite>
 
 
-<taItemSite>
 
<ITEMNMBR>072-00037</ITEMNMBR>
 
<LOCNCODE>CREATE294</LOCNCODE>
 
</taItemSite>
 
 
-<taItemSite>
 
<ITEMNMBR>072-SMSX</ITEMNMBR>
 
<LOCNCODE>CREATE294</LOCNCODE>
 
</taItemSite>
 
 
-<taItemSite>
 
<ITEMNMBR>07T-10401</ITEMNMBR>
 
<LOCNCODE>CREATE294</LOCNCODE>
 
</taItemSite>
 
 
-<taItemSite>
 
<ITEMNMBR>07T-10501</ITEMNMBR>
 
<LOCNCODE>CREATE294</LOCNCODE>
 
</taItemSite>
 
 
-<taItemSite>
 
<ITEMNMBR>391-00037</ITEMNMBR>
 
<LOCNCODE>CREATE294</LOCNCODE>
 
</taItemSite>
 
 
-<taItemSite>
 
<ITEMNMBR>394-00010</ITEMNMBR>
 
<LOCNCODE>CREATE294</LOCNCODE>
 
</taItemSite>
 
 
-<taItemSite>
 
<ITEMNMBR>399-CL4TVT-075-120J</ITEMNMBR>
 
<LOCNCODE>CREATE294</LOCNCODE>
 
</taItemSite>
 
 
-<taItemSite>
 
<ITEMNMBR>601-00004</ITEMNMBR>
 
<LOCNCODE>CREATE294</LOCNCODE>
 
</taItemSite>
 
 
-<taItemSite>
 
<ITEMNMBR>610-00003</ITEMNMBR>
 
<LOCNCODE>CREATE294</LOCNCODE>
 
</taItemSite>
 
 
-<taItemSite>
 
<ITEMNMBR>610-00004</ITEMNMBR>
 
<LOCNCODE>CREATE294</LOCNCODE>
 
</taItemSite>
 
 
-<taItemSite>
 
<ITEMNMBR>613-00022</ITEMNMBR>
 
<LOCNCODE>CREATE294</LOCNCODE>
 
</taItemSite>
 
 
-<taItemSite>
 
<ITEMNMBR>613-00027-01</ITEMNMBR>
 
<LOCNCODE>CREATE294</LOCNCODE>
 
</taItemSite>
 
 
-<taItemSite>
 
<ITEMNMBR>613-00028</ITEMNMBR>
 
<LOCNCODE>CREATE294</LOCNCODE>
 
</taItemSite>
 
 
-<taItemSite>
 
<ITEMNMBR>90HV1-W00GN/20TG075-120</ITEMNMBR>
 
<LOCNCODE>CREATPRO</LOCNCODE>
 
</taItemSite>
 
</taItemSite_Items>
 
<taCreateItemVendors_Items xsi:nil="true"/>
 
<taCreateKitItemRcd_Items xsi:nil="true"/>
 
<taCreateInternetAddresses_Items xsi:nil="true"/>
 
</IVItemMasterType>
 
 
-<IVInventoryTransactionType>
 
<eConnectProcessInfo xsi:nil="true"/>
 
<taRequesterTrxDisabler_Items xsi:nil="true"/>
 
<taUpdateCreateItemRcd xsi:nil="true"/>
 
<taIVTransactionSerialInsert_Items xsi:nil="true"/>
 
<taIVTransactionLotInsert_Items xsi:nil="true"/>
 
 
-<taIVTransactionLineInsert_Items>
 
 
-<taIVTransactionLineInsert>
 
<IVDOCNBR>ADJ27148</IVDOCNBR>
 
<IVDOCTYP>1</IVDOCTYP>
 
<ITEMNMBR>LABOR - PRODUCTION1</ITEMNMBR>
 
<UOFM>EA</UOFM>
 
<TRXQTY>-1159</TRXQTY>
 
<UNITCOST>1.00</UNITCOST>
 
<TRXLOCTN>CREATPRO</TRXLOCTN>
 
<IVIVOFIX>3093</IVIVOFIX>
 
</taIVTransactionLineInsert>
 
 
-<taIVTransactionLineInsert>
 
<IVDOCNBR>ADJ27148</IVDOCNBR>
 
<IVDOCTYP>1</IVDOCTYP>
 
<ITEMNMBR>FLOOR PARTS - PRODUCTION1</ITEMNMBR>
 
<UOFM>EA</UOFM>
 
<TRXQTY>-406</TRXQTY>
 
<UNITCOST>1.00</UNITCOST>
 
<TRXLOCTN>CREATPRO</TRXLOCTN>
 
<IVIVOFIX>3093</IVIVOFIX>
 
</taIVTransactionLineInsert>
 
 
-<taIVTransactionLineInsert>
 
<IVDOCNBR>ADJ27148</IVDOCNBR>
 
<IVDOCTYP>1</IVDOCTYP>
 
<ITEMNMBR>613-00043</ITEMNMBR>
 
<UOFM>EA</UOFM>
 
<TRXQTY>-90</TRXQTY>
 
<UNITCOST>0.14</UNITCOST>
 
<TRXLOCTN>CREATE294</TRXLOCTN>
 
<IVIVOFIX>3093</IVIVOFIX>
 
</taIVTransactionLineInsert>
 
 
-<taIVTransactionLineInsert>
 
<IVDOCNBR>ADJ27148</IVDOCNBR>
 
<IVDOCTYP>1</IVDOCTYP>
 
<ITEMNMBR>613-00044</ITEMNMBR>
 
<UOFM>EA</UOFM>
 
<TRXQTY>-45</TRXQTY>
 
<UNITCOST>0.13</UNITCOST>
 
<TRXLOCTN>CREATE294</TRXLOCTN>
 
<IVIVOFIX>3093</IVIVOFIX>
 
</taIVTransactionLineInsert>
 
 
-<taIVTransactionLineInsert>
 
<IVDOCNBR>ADJ27148</IVDOCNBR>
 
<IVDOCTYP>1</IVDOCTYP>
 
<ITEMNMBR>617-00004</ITEMNMBR>
 
<UOFM>EA</UOFM>
 
<TRXQTY>-45</TRXQTY>
 
<UNITCOST>0.19</UNITCOST>
 
<TRXLOCTN>CREATE294</TRXLOCTN>
 
<IVIVOFIX>3093</IVIVOFIX>
 
</taIVTransactionLineInsert>
 
 
-<taIVTransactionLineInsert>
 
<IVDOCNBR>ADJ27148</IVDOCNBR>
 
<IVDOCTYP>1</IVDOCTYP>
 
<ITEMNMBR>617-00005</ITEMNMBR>
 
<UOFM>EA</UOFM>
 
<TRXQTY>-45</TRXQTY>
 
<UNITCOST>0.19</UNITCOST>
 
<TRXLOCTN>CREATE294</TRXLOCTN>
 
<IVIVOFIX>3093</IVIVOFIX>
 
</taIVTransactionLineInsert>
 
 
-<taIVTransactionLineInsert>
 
<IVDOCNBR>ADJ27148</IVDOCNBR>
 
<IVDOCTYP>1</IVDOCTYP>
 
<ITEMNMBR>072-00037</ITEMNMBR>
 
<UOFM>EA</UOFM>
 
<TRXQTY>-45</TRXQTY>
 
<UNITCOST>5.45</UNITCOST>
 
<TRXLOCTN>CREATE294</TRXLOCTN>
 
<IVIVOFIX>3093</IVIVOFIX>
 
</taIVTransactionLineInsert>
 
 
-<taIVTransactionLineInsert>
 
<IVDOCNBR>ADJ27148</IVDOCNBR>
 
<IVDOCTYP>1</IVDOCTYP>
 
<ITEMNMBR>072-SMSX</ITEMNMBR>
 
<UOFM>EA</UOFM>
 
<TRXQTY>-45</TRXQTY>
 
<UNITCOST>0.80</UNITCOST>
 
<TRXLOCTN>CREATE294</TRXLOCTN>
 
<IVIVOFIX>3093</IVIVOFIX>
 
</taIVTransactionLineInsert>
 
 
-<taIVTransactionLineInsert>
 
<IVDOCNBR>ADJ27148</IVDOCNBR>
 
<IVDOCTYP>1</IVDOCTYP>
 
<ITEMNMBR>07T-10401</ITEMNMBR>
 
<UOFM>EA</UOFM>
 
<TRXQTY>-45</TRXQTY>
 
<UNITCOST>63.85</UNITCOST>
 
<TRXLOCTN>CREATE294</TRXLOCTN>
 
<IVIVOFIX>3093</IVIVOFIX>
 
</taIVTransactionLineInsert>
 
 
-<taIVTransactionLineInsert>
 
<IVDOCNBR>ADJ27148</IVDOCNBR>
 
<IVDOCTYP>1</IVDOCTYP>
 
<ITEMNMBR>07T-10501</ITEMNMBR>
 
<UOFM>EA</UOFM>
 
<TRXQTY>-45</TRXQTY>
 
<UNITCOST>17.15</UNITCOST>
 
<TRXLOCTN>CREATE294</TRXLOCTN>
 
<IVIVOFIX>3093</IVIVOFIX>
 
</taIVTransactionLineInsert>
 
 
-<taIVTransactionLineInsert>
 
<IVDOCNBR>ADJ27148</IVDOCNBR>
 
<IVDOCTYP>1</IVDOCTYP>
 
<ITEMNMBR>391-00037</ITEMNMBR>
 
<UOFM>EA</UOFM>
 
<TRXQTY>-45</TRXQTY>
 
<UNITCOST>1.87</UNITCOST>
 
<TRXLOCTN>CREATE294</TRXLOCTN>
 
<IVIVOFIX>3093</IVIVOFIX>
 
</taIVTransactionLineInsert>
 
 
-<taIVTransactionLineInsert>
 
<IVDOCNBR>ADJ27148</IVDOCNBR>
 
<IVDOCTYP>1</IVDOCTYP>
 
<ITEMNMBR>394-00010</ITEMNMBR>
 
<UOFM>EA</UOFM>
 
<TRXQTY>-45</TRXQTY>
 
<UNITCOST>12.35</UNITCOST>
 
<TRXLOCTN>CREATE294</TRXLOCTN>
 
<IVIVOFIX>3093</IVIVOFIX>
 
</taIVTransactionLineInsert>
 
 
-<taIVTransactionLineInsert>
 
<IVDOCNBR>ADJ27148</IVDOCNBR>
 
<IVDOCTYP>1</IVDOCTYP>
 
<ITEMNMBR>399-CL4TVT-075-120J</ITEMNMBR>
 
<UOFM>EA</UOFM>
 
<TRXQTY>-45</TRXQTY>
 
<UNITCOST>158.87</UNITCOST>
 
<TRXLOCTN>CREATE294</TRXLOCTN>
 
<IVIVOFIX>3093</IVIVOFIX>
 
</taIVTransactionLineInsert>
 
 
-<taIVTransactionLineInsert>
 
<IVDOCNBR>ADJ27148</IVDOCNBR>
 
<IVDOCTYP>1</IVDOCTYP>
 
<ITEMNMBR>601-00004</ITEMNMBR>
 
<UOFM>EA</UOFM>
 
<TRXQTY>-45</TRXQTY>
 
<UNITCOST>1.02</UNITCOST>
 
<TRXLOCTN>CREATE294</TRXLOCTN>
 
<IVIVOFIX>3093</IVIVOFIX>
 
</taIVTransactionLineInsert>
 
 
-<taIVTransactionLineInsert>
 
<IVDOCNBR>ADJ27148</IVDOCNBR>
 
<IVDOCTYP>1</IVDOCTYP>
 
<ITEMNMBR>610-00003</ITEMNMBR>
 
<UOFM>EA</UOFM>
 
<TRXQTY>-45</TRXQTY>
 
<UNITCOST>2.11</UNITCOST>
 
<TRXLOCTN>CREATE294</TRXLOCTN>
 
<IVIVOFIX>3093</IVIVOFIX>
 
</taIVTransactionLineInsert>
 
 
-<taIVTransactionLineInsert>
 
<IVDOCNBR>ADJ27148</IVDOCNBR>
 
<IVDOCTYP>1</IVDOCTYP>
 
<ITEMNMBR>610-00004</ITEMNMBR>
 
<UOFM>EA</UOFM>
 
<TRXQTY>-45</TRXQTY>
 
<UNITCOST>2.76</UNITCOST>
 
<TRXLOCTN>CREATE294</TRXLOCTN>
 
<IVIVOFIX>3093</IVIVOFIX>
 
</taIVTransactionLineInsert>
 
 
-<taIVTransactionLineInsert>
 
<IVDOCNBR>ADJ27148</IVDOCNBR>
 
<IVDOCTYP>1</IVDOCTYP>
 
<ITEMNMBR>613-00022</ITEMNMBR>
 
<UOFM>EA</UOFM>
 
<TRXQTY>-45</TRXQTY>
 
<UNITCOST>2.67</UNITCOST>
 
<TRXLOCTN>CREATE294</TRXLOCTN>
 
<IVIVOFIX>3093</IVIVOFIX>
 
</taIVTransactionLineInsert>
 
 
-<taIVTransactionLineInsert>
 
<IVDOCNBR>ADJ27148</IVDOCNBR>
 
<IVDOCTYP>1</IVDOCTYP>
 
<ITEMNMBR>613-00027-01</ITEMNMBR>
 
<UOFM>EA</UOFM>
 
<TRXQTY>-45</TRXQTY>
 
<UNITCOST>8.31</UNITCOST>
 
<TRXLOCTN>CREATE294</TRXLOCTN>
 
<IVIVOFIX>3093</IVIVOFIX>
 
</taIVTransactionLineInsert>
 
 
-<taIVTransactionLineInsert>
 
<IVDOCNBR>ADJ27148</IVDOCNBR>
 
<IVDOCTYP>1</IVDOCTYP>
 
<ITEMNMBR>613-00028</ITEMNMBR>
 
<UOFM>EA</UOFM>
 
<TRXQTY>-45</TRXQTY>
 
<UNITCOST>2.08</UNITCOST>
 
<TRXLOCTN>CREATE294</TRXLOCTN>
 
<IVIVOFIX>3093</IVIVOFIX>
 
</taIVTransactionLineInsert>
 
 
-<taIVTransactionLineInsert>
 
<IVDOCNBR>ADJ27148</IVDOCNBR>
 
<IVDOCTYP>1</IVDOCTYP>
 
<ITEMNMBR>90HV1-W00GN/20TG075-120</ITEMNMBR>
 
<UOFM>EA</UOFM>
 
<TRXQTY>45</TRXQTY>
 
<UNITCOST>314.86</UNITCOST>
 
<TRXLOCTN>CREATPRO</TRXLOCTN>
 
<IVIVOFIX>3093</IVIVOFIX>
 
</taIVTransactionLineInsert>
 
</taIVTransactionLineInsert_Items>
 
<taAnalyticsDistribution_Items xsi:nil="true"/>
 
<taIVTransactionMultiBinInsert_Items xsi:nil="true"/>
 
 
-<taIVTransactionHeaderInsert>
 
<BACHNUMB>C05-31-16 01:24</BACHNUMB>
 
<IVDOCNBR>ADJ27148</IVDOCNBR>
 
<IVDOCTYP>1</IVDOCTYP>
 
<DOCDATE>5/31/2016</DOCDATE>
 
</taIVTransactionHeaderInsert>
 
</IVInventoryTransactionType>
 
</eConnect>

Hi guys, first time poster here.

I have experience with eConnect and I've used it to create SOP documents and lately I've also been using it to create PO receipts.  I can create receipt headers and lines just fine but I was wondering about updates and deletes/rollbacks.  

Updating SOP documents is easy because you just pass an existing document number instead of grabbing a new one and pass a value to the "UpdateExisting" node.  However, I tried using an existing PO receipt number and PO number and I'm given this error:  "Input variable contains a duplicate  document (POPRCTNM)"

I know this receipt number exists, that's why I passed it!  I tried using the DeleteEntity and DeleteTransactionEntity methods by passing the same PO receipt XML document through and I get booleans returning "true" indicating it's supposed to work, but the items remain in GP.  However, I read that those methods only work on procedures that have nodes for an explicit delete, and I don't think the PO receipt line and headers have one.

Any ideas on how to modify/delete PO receipt lines and headers using eConnect?