Client is currently revisiting their chart of accounts as it is making report writing impossible.  They are also moving to sage intelligence but I had a quick query.

They are trying to insert 

”3135~3135-46~48-"~399,3371-46,3420-46:3420-48,3545-46:3545-46-400,3660-46:3660-46-400,3660-47,3660-48,3662-46:3662-46-100,3663-48-010,3664-46,3665-48,3666-46,3665-46,3666-46-100,3700-46:3700-48,3679-46,3679-46-100,3679-48”

 but not include 3134-46-400 without also removing 3135-46 and 3135-48?

My answer was

If it was me I would be attaching an optional field to all the accounts that you want to pull out as wages and then the formulae would be as simple as

A.ACCTREPGRP = "Wages"  or creating an account group.

 But try this

“=3135-46,3135-47,3135-48,3135-46-001:3135-46-399, 3135-46-401:3135-48-999

3371-46,3420-46:3420-48,3545-46:3545-46-400,3660-46:3660-46-400,3660-47,3660-48,3662-46:3662-46-100,3663-48-010,3664-46,3665-48,3666-46,3665-46,3666-46-100,3700-46:3700-48,3679-46,3679-46-100,3679-48”

Is there a better way to exclude this

sorry its so confusing 

thanks

Stacey