Renumber Accounts Dialog

Method

Choose the method required to renumber accounts. The following methods are available:

Find/Replace

Select to renumber account numbers by finding and replacing a specific sequence. For example, to modify the format of accounts from xxx.xxx to xxx-xxx, enter "." in the Find What field and enter "-" in the Replace With field.

Insert Prefix

Select to renumber account numbers by adding a prefix. For example, to add "A" before account numbers, enter "A" in the Prefix field.

Insert Suffix

Select to renumber account numbers by adding a suffix. For example, to add "Z" after account numbers, enter "Z" in the Suffix field.

Reincrement

Select to renumber account numbers by defining a starting point and incrementing by a set number. For example, to set account numbering to start at 100 with an increment amount of 1, enter "100" in the Starting Account No field and "1" in the Increment By field.

Constant Shift

Select to renumber account numbers by a specific number. For example, to increase account numbers by 5, enter "5" in the Amount field.

Regular Expression

Select to renumber account numbers using regular expressions. For more information about regular expressions, see Introduction to Regular Expressions.

Entity (only in consolidated files)

Specify the entity from which accounts should be renumbered.

Only (only in consolidated files)

Select if only the accounts in the entity specified should be renumbered.

From Account/To Account

Specify the range of accounts that should be renumbered.

Include splitups

Select to renumber all split-up accounts associated with accounts in the From Account/To Account range. This option is selected by default.

Include performance measures

Select to renumber all performance measures accounts associated with accounts in the From Account/To Account range.

Include cash flow

Select to renumber all cash flows accounts associated with accounts in the From Account/To Account range.

Tip: To include all entities and accounts in the data range, leave the fields blank.

Displays renumbering results based on the options selected. Renumbering has not actually yet occurred. Columns displayed include Entity (if applicable), Old Account No and New Account No.

If renumbering should result in a conflict, a message displays beside the applicable account numbers. All errors must be resolved before renumbering can occur.

Click to renumber account numbers as displayed in the Results area.

Click to close the dialog without renumbering.