Solved

Can't delete sub account

  • 3 February 2022
  • 1 reply
  • 189 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
 

icon

Best answer by apanchamia 6 February 2022, 01:06

View original

1 reply

Userlevel 1

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

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved