TRS-900
Mostly chart of accounts is categorized by account type and account description. If we need to distinguish accounts from account number we can use formula text when searching accounts.
If asset accounts number were starting with the character ‘1’ and liability accounts were starting with ‘2’ we can use the following formula to distinguish these accounts from the account name
CASE WHEN INSTR({number},’1′) = 1 THEN ‘ASSET’ ELSE (CASE WHEN INSTR({number},’2′) = 1 THEN ‘LIABILITY’ ELSE ‘OTHER’ END ) END