[Christina]

Another Question – While working on my Balance Sheet revision this morning, there is one COA # that is showing up in my Other Assets section rather than my Current Assets section, where it was previously. I have gone back to the COA list to change the designation on the report and it is listing correctly but I’ve also read that those fields effect the old financials only. HELP! I can’t find any clear answer to this in the Help section… any guidance would be much appreciated!
This is a cached copy. Click here to see the original post.

[AlexNS]

RE: Moving G/L # from One Report Section to Another

In the new financials, how accounts fall into sections is controlled entirely via layouts, specifically through section criteria. Go to the Edit Layout step of customizing the report, click on the section you want to modify, click Edit Criteria, and play with the different filters. You can add accounts by type, name, or number.

[Christina]

RE: Moving G/L # from One Report Section to Another

I am attempting in include the COA number in the existing list but am not being successful. The only options are “is, is empty, starts with, contains,is not,is not empty, does not start with, does not contain”. There is no way (that I can see) to add an additional number to an already existing list in the system the way we could previously. From what I gather, I am going to have to add each number in that section individually to acchieve what I need, is that correct?

[AlexNS]

RE: Moving G/L # from One Report Section to Another

Unless you can combine multiple numbers into a “starts with” or another dynamic filter, then yes, you would need to add a separate “is” filter for each account number. This would also require checking “Use Expressions”, wrapping the filters with parentheses and using “Or” between them.

It might be simpler in that case to use the Account Name filter. It allows you to select multiple accounts from the pop-up list in one filter.

For the future, note that a well-chosen account numbering scheme may make dynamic filters more useful (e.g., if all your Current Assets account numbers started with NNN, then you could use just one filter: Account Number starts with NNN).

[Author]

Posts