Page 1 of 1

Way to filter finance reports?

Posted: Sun Jul 01, 2012 10:15 am
by aclawson
How can I apply filters to the finance reports?

Posted: Sun Jul 01, 2012 6:12 pm
by aebrown
aclawson wrote:How can I apply filters to the finance reports?
What kind of filters are you talking about? Many finance reports already let you filter by specific or custom date ranges, or to select specific subcategories.

Posted: Sun Jul 08, 2012 11:17 am
by aclawson
I'm looking for a quick and easy way to see the list of outstanding checks on the register screen.

Posted: Sun Jul 08, 2012 1:04 pm
by jdlessley
In View/Update Expenses click the title box "Status". This will sort the expenses by status. Outstanding checks would have a status of Not Sent, Sent, and Issued. A check that has cleared the bank will have the status of Cleared. The table of definitions for check status as listed in MLS is found HERE.

Posted: Sun Jul 08, 2012 1:06 pm
by aebrown
aclawson wrote:I'm looking for a quick and easy way to see the list of outstanding checks on the register screen.
By "register screen" I assume you mean "View/Update Expenses." One easy way to see the outstanding checks is to click on the "Status" heading, which will sort all the entries by status. Then you can scroll down to the section of expenses with an "Issued" status -- those are your outstanding checks.

Posted: Sun Jul 08, 2012 2:02 pm
by aclawson
Yes, you can sort them, but that isn't the same as filtering and isn't as fast or efficient. MLS needs some better search functions to make it more user friendly.

And yes, the register screen is the view expenses screen - it has the form and function of a checkbook register.

Posted: Sun Jul 08, 2012 3:16 pm
by aebrown
aclawson wrote:Yes, you can sort them, but that isn't the same as filtering and isn't as fast or efficient.

It's true that sorting is not the same as filtering, but you seemed to be asking what can be done now, and I think that what JD and I described is the best solution currently available. And although I admire your search for efficiency, I can see the list of outstanding checks in well under 10 seconds right now. Any improvement in speed over that would be insignificant.
aclawson wrote:MLS needs some better search functions to make it more user friendly.

That I'll definitely agree with. The technique of clicking on a column header to sort is easy and quick, but by no means obvious to many people. A means for filtering that is clearly labeled in the UI would be much more user-friendly.