Skip to main content
Solved

Can't delete sub account

  • February 3, 2022
  • 1 reply
  • 245 views

Can’t delete a sub account. Can’t figure out where to find the rest of them so i can delete them.

 

 

2/3/2022 6:54:58 PM Warning at ParentDeletingHandler.cs:159:RaiseConstaintViolationException():
Subaccount (00  -   -) cannot be deleted because it is referenced in multiple tables.
 1: Currency (USD) - Foreign key Currency(aRProvSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute
 2: Currency (USD) - Foreign key Currency(aPProvSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute
 3: Location (118, MAIN) - Foreign key Location(cSalesSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute
 4: Location (118, MAIN) - Foreign key Location(cDiscountSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute
 5: Location (118, MAIN) - Foreign key Location(cRetainageSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute
 6: Location (118, MAIN) - Foreign key Location(cFreightSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute
 7: Location (118, MAIN) - Foreign key Location(cARSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute
 8: Location (118, MAIN) - Foreign key Location(vExpenseSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute
 9: Location (118, MAIN) - Foreign key Location(vRetainageSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute
 10: Location (118, MAIN) - Foreign key Location(vDiscountSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute
 11: Location (118, MAIN) - Foreign key Location(vAPSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute
 12: Location GL Accounts (118, 116) - Foreign key LocationARAccountSub(cARSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute
 13: Location GL Accounts (118, 116) - Foreign key LocationARAccountSub(cRetainageSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute
 14: Location GL Accounts (118, 116) - Foreign key LocationAPAccountSub(vAPSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute
 15: Location GL Accounts (118, 116) - Foreign key LocationAPAccountSub(vRetainageSubID) references Sub(subID), with Restrict-behavior, achieved by DeclareReferenceAttribute
 

Best answer by apanchamia

Sub accounts once used in a released transaction cannot be deleted. Consider renaming them.

View original
Did this topic help you find an answer to your question?

1 reply

apanchamia
Acumatica Employee
  • Acumatica Services Team
  • 8 replies
  • Answer
  • February 6, 2022

Sub accounts once used in a released transaction cannot be deleted. Consider renaming them.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings