- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-20-2023 12:30 AM - edited 02-20-2023 01:10 AM
Hi,
From the customer_account table
we are trying to create new account is giving error - Invalid Insert
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-20-2023 12:41 AM
Hi @Saib1
Cause
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.
Resolution
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.
I hope this will helps you to resolve your issue.
Please mark my answer correct and helpful if it helps you to resolve your issue.
Thank you
Rajesh.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-20-2023 01:17 AM
Hi @saib ,
hope @Rajesh Chopade1 has provided you solution ,
its was learning for me also
Thanks