Interesting question posed by a client recently - and has been asked previously by other clients too over the years.
They'd like to change the account numbering of the GL chart of accts, so basically just changing the GL_Ledger table, specifically the AccountNo, Segment1, Segment 2 etc.
Everything else stays the same, so each existing account will keep the sign, category, classification. And also keep any budgets, movements etc. It's just a "simple" change from one account number to another.
Aside from the GL_Ledger table, is there any other table I'm forgetting where the account numbers are stored?
And can you think of any bad consequences?