API to update CUSTOMERID in Sage

[Jay Muthukumarasamy]

Hello there, 
Is there a way to update the CUSTOMERID of a Customer in Sage Intacct using the REST API? When I try to update with something like the following in the payload, I get a failure message saying Customer ABC123 does not exist. It appears that the CUSTOMERID I am passing is being used in the WHERE clause instead of the SET clause under the covers.
..
..
        <update>
            <CUSTOMER>
                <RECORDNO>3399</RECORDNO>
                <CUSTOMERID>ABC123</CUSTOMERID>
            </CUSTOMER>
        </update>
..
..
Can someone confirm if the CUSTOMERID is updateable or not. Thanks

- Jay

[Daniel Keig]

It is not.

On the Sage Community, one of the longest and most popular ideas is to be able to merge records like vendors / customers. Hopefully, if that ever rolls out, there will be the ability to adjust the ID, either directly or via a workaround or merging two records...

[Jay Muthukumarasamy]

Thank you