Creating new account resutls in Invalid Insert


When creating a new customer_account record, there is an "Invalid Insert" error and the record is not saved.

Release or Environment

All Releases


The customer_account table has three fields that require unique values, one is the account code. This field is creating with a default value that is determined by the last used value. The 'last used' value is stored in the com.snc.cs_base.last.generated.code.tree.path system property. If the property is reset to the original value, it will attempt to create new accounts with an account code that is already in use.


Identify the last used value for the account code field on the customer_account table and update the com.snc.cs_base.last.generated.code.tree.path system property with that value.