web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

eConnect API error

(0) ShareShare
ReportReport
Posted on by

I have a question in regards to creating a transaction entity using the eConnect API. I am trying to accomplish two things in one Transaction Scope:

1.) Create Item
2.) After the item is created, Create the Price Level(s) for the item

within my TransactionScope are two CreateTransactionEntity calls which use different XmlDocuments.

Creating the item XML:

<?xml version="1.0" encoding="UTF-8"?>
<eConnect xmlns:xsd="www.w3.org/.../XMLSchema" xmlns:xsi="www.w3.org/.../XMLSchema-instance">
<IVItemMasterType>
<eConnectProcessInfo xsi:nil="true" />
<taRequesterTrxDisabler_Items xsi:nil="true" />
<taUpdateCreateItemRcd>
<ITEMNMBR>abctest2-testing2</ITEMNMBR>
<ITEMDESC>abc test item2</ITEMDESC>
<ITMCLSCD>main</ITMCLSCD>
<UOMSCHDL>EACH</UOMSCHDL>
<UpdateIfExists>0</UpdateIfExists>
</taUpdateCreateItemRcd>
<taUpdateCreateItemCurrencyRcd_Items xsi:nil="true" />
<taIVCreateItemPriceListLine_Items xsi:nil="true" />
<taIVCreateItemPriceListHeader xsi:nil="true" />
<taItemSite_Items xsi:nil="true" />
<taCreateItemVendors_Items xsi:nil="true" />
<taCreateKitItemRcd_Items xsi:nil="true" />
<taCreateInternetAddresses_Items xsi:nil="true" />
</IVItemMasterType>
</eConnect>

Creating Price Level XML:

<?xml version="1.0" encoding="UTF-8"?>
<eConnect xmlns:xsd="www.w3.org/.../XMLSchema" xmlns:xsi="www.w3.org/.../XMLSchema-instance">
<IVCreateItemPriceListType>
<eConnectProcessInfo xsi:nil="true" />
<taRequesterTrxDisabler_Items xsi:nil="true" />
<taIVCreateItemPriceListLine_Items>
<taIVCreateItemPriceListLine>
<ITEMNMBR>abctest2-testing2</ITEMNMBR>
<CURNCYID>Z-US$</CURNCYID>
<PRCLEVEL>retail</PRCLEVEL>
<UOFM>EACH</UOFM>
</taIVCreateItemPriceListLine>
</taIVCreateItemPriceListLine_Items>
<taIVCreateItemPriceListHeader>
<ITEMNMBR>abctest2-testing2</ITEMNMBR>
<UOFM>EACH</UOFM>
<PRCLEVEL>retail</PRCLEVEL>
<CURNCYID>Z-US$</CURNCYID>
</taIVCreateItemPriceListHeader>
</IVCreateItemPriceListType>
</eConnect>


After this happens, I get Error Number = 7098 Stored Procedure= taUpdateCreateItemRcd Error Description = Item number already exists and the updateifexists flag is set to not allow updates. Even after receiving this error, both the item and price levels are still successfully created. Any idea why I'm getting this error? The error also contains the XML for the item creation (taUpdateCreateItemRcd) which is coming from the price level creation call.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    sandipdjadhav Profile Picture
    18,335 on at

    Do you pass separately each node to eConnect? I mean first, you integrate Item Master and then Pricelist? 

    If you wish to pass all together why you generating two xml in one xml you can pass Item Master as well as PriceList.

    Thanks much

    Sandip

  • Verified answer
    Community Member Profile Picture
    on at

    Thanks Sandip

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

#2
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans