Site Search:
Sign in | Join | Help

HELP! Error Number = 9177 Stored Procedure taSopLineIvcInsert

Last post 01-15-2010 3:32 PM by gijeet. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 01-14-2010 4:42 PM

    HELP! Error Number = 9177 Stored Procedure taSopLineIvcInsert

     Hello, I'm getting a 9177 error:

    Stored Procedure taSopLineIvcInsert

    Error Description = Currency/Price Level/UofM combination is not included in price list for this item

    Prior to bringing in the SOP document I create new items via IVItemMasterType.  I can create the item without error but the SOP doc thows the 9177 error.  So I believe I'm not setting something with I create the document.  I've enclosed the IVItemMasterType document here:

    <?xml version="1.0" encoding="utf-8"?>
    <eConnect xmlns="dt=urn:schemas-microsoft-com:datatypes">
      <IVItemMasterType xmlns="">
        <eConnectProcessInfo>
          <eConnectProcsRunFirst>TRUE</eConnectProcsRunFirst>
          <ConnectionString>Data Source=localhost;
             Initial Catalog=TWO;Integrated Security=SSPI</ConnectionString>
        </eConnectProcessInfo>
        <taUpdateCreateItemRcd>
          <ITEMNMBR>Green Widget 1</ITEMNMBR>
          <ITEMDESC>Green Widget 1</ITEMDESC>
          <ITMSHNAM></ITMSHNAM>
          <ITMGEDSC></ITMGEDSC>
          <ITMCLSCD>RETAIL</ITMCLSCD>
          <ITEMTYPE>1</ITEMTYPE>
          <VCTNMTHD>1</VCTNMTHD>
          <TAXOPTNS>3</TAXOPTNS>
          <STNDCOST>10.00000</STNDCOST>
          <CURRCOST>10.00000</CURRCOST>
          <LISTPRCE>15.00000</LISTPRCE>
          <LOCNCODE>WAREHOUSE</LOCNCODE>
          <PRICMTHD>3</PRICMTHD>
          <UOMSCHDL>EACH</UOMSCHDL>
          <PRCHSUOM>EACH</PRCHSUOM>
          <ITMTSHID></ITMTSHID>
          <UseItemClass>1</UseItemClass>
          <UpdateIfExists>1</UpdateIfExists>
        </taUpdateCreateItemRcd>
      </IVItemMasterType>
    </eConnect>

     I'm not sure what else I need to set to create the Currency/Price Level/UofM combination.

    Any help will be appreciated.

    Thanks in advance

    G

     

     

     

    • Post Points: 1
  • 01-14-2010 6:27 PM In reply to

    Re: HELP! Error Number = 9177 Stored Procedure taSopLineIvcInsert

    Update:  I've added the taUpdateCreateItemCurrencyRcd node and I'm still getting the same error.  I moved the LISTPRCE element from the taUpdateCreateItemRcd to the taUpdateCreateItemCurrencyRcd node.  When I did this the LISTPRCE column in IV00105 was now getting populated with the $15.00.  When LISTPRCE was in taUpdateCreateItemRcd node, the LISTPRCE field in IV00105 was zero.  So when I saw that it was now getting populated I thought I would have success importing the SOP document.  But still no joy.   Don't know what else to do.  If anyone has any experience with this I'd appreciate it.

    <?xml version="1.0" encoding="utf-8"?>
    <eConnect xmlns="dt=urn:schemas-microsoft-com:datatypes">
      <IVItemMasterType xmlns="">
        <eConnectProcessInfo>
          <eConnectProcsRunFirst>TRUE</eConnectProcsRunFirst>
          <ConnectionString>Data Source=localhost;
             Initial Catalog=TWO;Integrated Security=SSPI</ConnectionString>
        </eConnectProcessInfo>
        <taUpdateCreateItemRcd>
          <STATUS>0</STATUS>
          <ITEMNMBR>Green Widget 1</ITEMNMBR>
          <ITEMDESC>Green Widget 1</ITEMDESC>
          <ITMSHNAM></ITMSHNAM>
          <ITMGEDSC></ITMGEDSC>
          <ITMCLSCD>RETAIL</ITMCLSCD>
          <ITEMTYPE>1</ITEMTYPE>
          <VCTNMTHD>1</VCTNMTHD>
          <TAXOPTNS>3</TAXOPTNS>
          <STNDCOST>10.00000</STNDCOST>
          <CURRCOST>10.00000</CURRCOST>
          <LOCNCODE>WAREHOUSE</LOCNCODE>
          <PRICMTHD>3</PRICMTHD>
          <UOMSCHDL>EACH</UOMSCHDL>
          <PRCHSUOM>EACH</PRCHSUOM>
          <ITMTSHID></ITMTSHID>
          <UseItemClass>1</UseItemClass>
          <UpdateIfExists>1</UpdateIfExists>
        </taUpdateCreateItemRcd>
        <taUpdateCreateItemCurrencyRcd>
          <ITEMNMBR>Green Widget 1</ITEMNMBR>
          <CURNCYID>Z-US$</CURNCYID>
          <LISTPRCE>15.00000</LISTPRCE>
        </taUpdateCreateItemCurrencyRcd>
      </IVItemMasterType>
    </eConnect>

    • Post Points: 1
  • 01-15-2010 3:32 PM In reply to

    Re: HELP! Error Number = 9177 Stored Procedure taSopLineIvcInsert

    UPDATE:  I added the taIVCreateItemPriceListLine node and now it works.   Hope this helps someone with the same error.

    G

    • Post Points: 1
Page 1 of 1 (3 items)