Set the account code property

  • Release version: Australia
  • Updated March 12, 2026
  • 1 minute to read

    • After importing customer account information, update the com.snc.cs_base.last.generated.code.tree.path property with the correct account code value.

    Before you begin

    Role required: import_admin and sn_crm_foundation_admin

    About this task

    The com.snc.cs_base.last.generated.code.tree.path system property stores the Account Code value for the most recently created customer account in the Account (customer_account) table.

    When you create a customer account record, the system uses this property to generate a unique account code. The property is then updated with the latest value, confirming the next account record receives a new unique code.

    The value of the com.snc.cs_base.last.generated.code.tree.path property must match the value of the Account Code field for the last inserted customer account record. When you create customer account records by importing data from other sources or instances, these values can get out of synchronization. If these values don’t match, the system generates an error on the creation of the next new record in the Account table:

    java.sql.BatchUpdateException: Duplicate entry for key account_path

    Use the following steps to fix this error.

    Procedure

    1. Determine the highest or last used account code value from the account (customer_account) table.
    2. Navigate to the System Property [sys_properties] table.
    3. Set the com.snc.cs_base.last.generated.code.tree.path property to the value determined in step 1.