Duplicate key error prevents mass creation in Capital Asset Accounts

Owned by Knowledge Assistant
Last updated: Oct 03, 2022
1 min read
Description of Issue

Error received when using Mass Create in Capital Asset Accounts:

Cannot insert duplicate key row in object 'CapitalAssets.CAPurchasingAccountDefaultCAAccounts' with unique index 'IX_CAPurchasingAccountDefaultCAAccounts_Unique'.

Context

Capital Assets

Cause


Resolution

Install the appropriate work ticket for your version once it's been released:

  • 2019.1.22.0 - MUN-412151
  • 2020.1.0.0 - MUN-413645
  • 2020.2.0.0 - MUN-413646
  • 2020.3.0.0 - MUN-413647
  • 2021.1.0.0 - MUN-413648

Workaround:  Manually create the records

Additional Information