Unable to delete one purchasing account without modifying another

Owned by Knowledge Assistant
Last updated: Apr 17, 2023
1 min read
Description of Issue

Error received when posting a Transfer transaction:

Execute insert_CAAssetPurchasingAccounts failed -status: -391
Cannot insert the value NULL into column ‘CANumber’ table ‘munXXXX.CapitalAssets.CAPurchasingAccounts’; column does not allow nulls. INSERT fails

Context

Capital Assets

Cause

Error occurs when a purchasing account has been removed from the asset

Resolution

Install the appropriate work ticket for your version:

  • 2019.1.22.2694 - MUN-418173
  • 2021.4.0.1813 - MUN-457348
  • 2021.5.0.1399 - MUN-457349
  • 2021.6.0.1039 - MUN-457350
  • 2021.7.0.714 - MUN-457351
  • 2021.8.0.361 - MUN-457352

Workaround:  Transaction will post if an existing purchasing account is modified.  If that account should not be modified, a second Transfer transaction can be posted to change it back afterwards.

Additional Information