Hi,

We are facing an issue in our production environment for one of the customer while sending data to Salesforce to upsert the custom object ‘Account_Balance_by_Entity’ which has Account__c as Lookup field.

For example, we are getting the error  “Attempting to update (as part of an upsert) parent field Account__c with new value 001E000000BsqzVIAR, current value is 001E000000BsqzvIAB”.

It is noticeable that two accounts have unique Id(from url) with same order of alphanumeric combinations, one ending with lower case and another upper case.
One account has ID like 001E000000BsqzV and another like 001E000000Bsqzv.
Everything are in same order, only one ends with upper case 'V' and another ends with lower case 'v'.

We send the ‘upsert’ request to SFDC which has 001E000000BsqzV and get error for another similar ID 001E000000Bsqzv. There are many such combination of accounts in our customer’s Salesforce company.
Could you please suggest us how to fix this issue?

Any account which does not have similar other account Id then posting works fine.

Few details about custom object:
Object Name:    Account_Balance_by_Entity
API Name:          Account_Balance_by_Entity__c

Standard Fields:
Label                                     Field Name         Data Type           
Created By                          CreatedBy           Lookup(User)    
Currency                              CurrencyIsoCode             Picklist 
Intacct Entity Name        Name                    Text(80)               
Last Modified By              LastModifiedBy Lookup(User)    
Owner                                  Owner                  Lookup(User,Queue)

Custom Fields & Relationships
Field Label           API Name            Data Type                           
Account               Account__c        Lookup(Account)
Balance                Balance__c         Currency(16, 2)
External Id          External_Id__c Text(80) (External ID) (Unique Case Insensitive)

Here is the XML request and response:
Request:

<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="urn:partner.soap.sforce.com" xmlns:ns2="urn:sobject.partner.soap.sforce.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <SOAP-ENV:Header>
      <ns1:SessionHeader>
         <ns1:sessionId>******SessionId here***** </ns1:sessionId>
      </ns1:SessionHeader>
      <ns1:CallOptions>
         <ns1:client>Intacct/1.0</ns1:client>
         <ns1:defaultNamespace xsi:nil="true" />
      </ns1:CallOptions>
   </SOAP-ENV:Header>
   <SOAP-ENV:Body>
      <ns1:upsert>
         <ns1:externalIDFieldName>External_Id__c</ns1:externalIDFieldName>
         <ns1:sObjects>
            <ns2:type>Account_Balance_by_Entity__c</ns2:type>
            <ns2:Id xsi:nil="true" />
            <Account__c>001E000000BsqzVIAR</Account__c>
            <Name>ACC-US--Accruent USA</Name>
            <CurrencyIsoCode>USD</CurrencyIsoCode>
            <Balance__c>10243</Balance__c>
            <External_Id__c>001E000000BsqzV--ACC-US</External_Id__c>
         </ns1:sObjects>
      </ns1:upsert>
   </SOAP-ENV:Body>
</SOAP-ENV:Envelope>


Response:

<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns="urn:partner.soap.sforce.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <soapenv:Body>
      <upsertResponse>
         <result>
            <created>false</created>
            <errors>
               <fields>Account__c</fields>
               <message>Attempting to update (as part of an upsert) parent field Account__c with new value 001E000000BsqzVIAR, current value is 001E000000BsqzvIAB</message>
               <statusCode>INVALID_FIELD_FOR_INSERT_UPDATE</statusCode>
            </errors>
            <id xsi:nil="true" />
            <success>false</success>
         </result>
      </upsertResponse>
   </soapenv:Body>
</soapenv:Envelope>



<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Hi,

We are facing an issue in our production environment for one of the customer while sending data to Salesforce to upsert the custom object ‘Account_Balance_by_Entity’ which has Account__c as Lookup field.

For example, we are getting the error  “Attempting to update (as part of an upsert) parent field Account__c with new value 001E000000BsqzVIAR, current value is 001E000000BsqzvIAB”.

It is noticeable that two accounts have unique Id(from url) with same order of alphanumeric combinations, one ending with lower case and another upper case.
One account has ID like 001E000000BsqzV and another like 001E000000Bsqzv.
Everything are in same order, only one ends with upper case 'V' and another ends with lower case 'v'.

We send the ‘upsert’ request to SFDC which has 001E000000BsqzV and get error for another similar ID 001E000000Bsqzv. There are many such combination of accounts in our customer’s Salesforce company.
Could you please suggest us how to fix this issue?

Any account which does not have similar other account Id then posting works fine.

Few details about custom object:
Object Name:    Account_Balance_by_Entity
API Name:          Account_Balance_by_Entity__c

Standard Fields:
Label                                     Field Name         Data Type           
Created By                          CreatedBy           Lookup(User)    
Currency                              CurrencyIsoCode             Picklist 
Intacct Entity Name        Name                    Text(80)               
Last Modified By              LastModifiedBy Lookup(User)    
Owner                                  Owner                  Lookup(User,Queue)

Custom Fields & Relationships
Field Label           API Name            Data Type                           
Account               Account__c        Lookup(Account)
Balance                Balance__c         Currency(16, 2)
External Id          External_Id__c Text(80) (External ID) (Unique Case Insensitive)

Here is the XML request and response:
Request:

<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns1="urn:partner.soap.sforce.com" xmlns:ns2="urn:sobject.partner.soap.sforce.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <SOAP-ENV:Header>
      <ns1:SessionHeader>
         <ns1:sessionId>******SessionId here***** </ns1:sessionId>
      </ns1:SessionHeader>
      <ns1:CallOptions>
         <ns1:client>Intacct/1.0</ns1:client>
         <ns1:defaultNamespace xsi:nil="true" />
      </ns1:CallOptions>
   </SOAP-ENV:Header>
   <SOAP-ENV:Body>
      <ns1:upsert>
         <ns1:externalIDFieldName>External_Id__c</ns1:externalIDFieldName>
         <ns1:sObjects>
            <ns2:type>Account_Balance_by_Entity__c</ns2:type>
            <ns2:Id xsi:nil="true" />
            <Account__c>001E000000BsqzVIAR</Account__c>
            <Name>ACC-US--Accruent USA</Name>
            <CurrencyIsoCode>USD</CurrencyIsoCode>
            <Balance__c>10243</Balance__c>
            <External_Id__c>001E000000BsqzV--ACC-US</External_Id__c>
         </ns1:sObjects>
      </ns1:upsert>
   </SOAP-ENV:Body>
</SOAP-ENV:Envelope>


Response:

<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns="urn:partner.soap.sforce.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <soapenv:Body>
      <upsertResponse>
         <result>
            <created>false</created>
            <errors>
               <fields>Account__c</fields>
               <message>Attempting to update (as part of an upsert) parent field Account__c with new value 001E000000BsqzVIAR, current value is 001E000000BsqzvIAB</message>
               <statusCode>INVALID_FIELD_FOR_INSERT_UPDATE</statusCode>
            </errors>
            <id xsi:nil="true" />
            <success>false</success>
         </result>
      </upsertResponse>
   </soapenv:Body>
</soapenv:Envelope>



<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<