gijeet 1/14/2010 4:42:27 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

 

 

 

Version: Unknown or N/A
Section: eConnect


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3