admin
Posts 122
|
it is an alphanumeric field of up to 10 characters, but remember that it is an *alphanumeric* field, not numeric. So, the sorting on this account number is *left justified*. hence, it is important to use the same number of characters for the *base* portion of the account number. For example, say you have four accounts, 101, 1, 11 and 110. These accounts will be sorted as 1, 101, 11, 110. Probably not what you would have intended. The numbering should have been as follows: 001, 011, 101, 110. If you want to have *sub accounts* then you can suffix a decimal notation on the account number. For example, say you have some expense accounts numbered 5010, 5020, 5030 and you want so add allow for some departmental breakdown in account 5020. You could create new accounts 5020-1, 5020-2, etc. Then your accounts would sort like: 5010, 5020, 5020-1, 5010-2, 5020-3, 5030.
|