Changing GL account numbers

[DannyC]

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?

[Scott.Pearce]

I think it is just the GL_Ledger table. Specifically:

AccountNo
Seg1
Seg2
Seg3
Seg4
Seg5
Seg6
ShortCut
ParentAccNo

I did a quick SQL query as a rough double check:

Code: Select all

select sys.columns.name, sys.tables.name from sys.columns
join sys.tables on sys.columns.object_id = sys.tables.object_id
where sys.columns .name like '%accountno%'