OpportunityLineItem has an IsActive field? Or are you talking about the pricebookentry IsActive field? I checked that and all my pricebookentry id's I'm adding with come from active pricebookentrys. This is getting quite confusing.

WhiZa;

I created a line item and then dumped all the fields and tried to reimport it as a new item.  After about 10 permitations I found one that did not produce an error.  See the mapping on the screen shot below:

When you do your insert map just the fields:

• Line Description
• OpportinityId
• ProductId
• Quantity
• Sales Price (Unit Price)

This worked for me and inserted the product as planned.

Cheers;
GlennW glenn.wilson@demandtools.com

 

 

Thanks Glenn,

I tried the fields you gave me, and now it's telling me: Error 1218 inserting record: Bad field name 'UnitPrice' in insert call. But when I do a describe on the OpportunityLineItem, UnitPrice is right there. Any ideas?

WhiZa;  If you like you can download my tools and I'll set you up with a trial account.  You can then pull down your meta data and try loading data from a CSV file.  (that's how I figured how to add it to my demo account).  Just make sure you turn the error file verbosity up to "High" and the error log will tell you the fields and values that you are updating.

The files are on the download page of www.demandtools.com

Cheers
GlennW

Here's an example of a record I pass to SFDC:

   <sObjects xmlns:ns3="urn:sobject.partner.soap.sforce.com">
    <ns3:type>OpportunityLineItem</ns3:type>
    <OpportunityId xsi:type="xsd:string">006300000016REuAAM</OpportunityId>
    <ProductId xsi:type="xsd:string">00j30000000c6zVAAQ</ProductId>
    <Quantity xsi:type="xsd:double">1.0</Quantity>
    <UnitPrice xsi:type="xsd:double">0.0</UnitPrice>
   </sObjects>

and it returns the error:   

<result>
    <errors>
     <fields xsi:nil="true"/>
     <message>field integrity exception</message>
     <statusCode>FIELD_INTEGRITY_EXCEPTION</statusCode>
    </errors>
    <id xsi:nil="true"/>
    <success>false</success>
   </result>

Could it be that I should not be passing a double into a type currency?

FIELD_INTEGRITY_EXCEPTION

Check the IDs that you are using to ensure they are valid and you have access to them, and make sure that you aren't missing a required ID.

I know the OpportunityID is valid and the ProductID is valid and active. The PricebookEntryID is null because I'm using a ProductID. CreatedByID and LastModifiedById are both auto generated.

[EDIT]

I finally got it to append line items. I really don't know how   Basically our company's product list is discombobulated and made it difficult to find the correct pricebookentry/product ID to use. I need to research more about the new relationships between entities and hopefully will never have this issue again. Thanks for the help

[/EDIT]

Message Edited by WhiZa on 05-03-2004 02:09 PM