x Want to participate? Join the group to interact
Options
  • State Not Answered
  • Replies 7 replies
  • Subscribers 58 subscribers
  • Views 2505 views
  • Users 0 members are here
Browse Forums
Sage Timeslips Anywhere Announcements
6
topics
1
replies
Sage Timeslips Anywhere General Discussion
13
topics
13
replies
Sage Timeslips Premium Announcements
57
topics
17
replies
Sage Timeslips Premium General Discussion
2k
topics
8k
replies
sgmtoigo

Prebill filters for clients with balances but no activity

Posted By

Our monthly prebill has grown to almost 800 pages, and I've been asked to separate it into clients with current billable slips and clients with balances but no activity and everything but current slips.  I've created a new prebill report for clients with current slips, but can't figure out how to filter for only clients with balances but no activity.  Outside of manually selecting these clients, which would take forever, is there a simpler way to do this?  I've tried filtering every which way to Sunday, but still don't get the report I need. 

We are using Timeslips 2015.  Thanks in advance for any help!

Parents
  • 0
    Why do you need prebills on those clients at all? Are they going to be reviewed or marked up in any way? Sounds like you are good with the bills that have new time as that needs to be reviewed, but the ones who just owe you money can have their bills run as is.

    Or am I missing something?
  • 0 in reply to Nancy Duhon
    For now, they still want to review them. I'm hoping this will change once they see how nice it is to only review current time, but until then I still need to give them the old info. Any advice on how to do this is appreciated. Thanks!
  • 0 in reply to sgmtoigo
    I don't know of a way to have the program do only the previous balances by themselves. I suppose I would just print all 800 pages and then sort them into the two stacks by hand. Hopefully you will only need to do it a few times before they don't want to look at the previous balance ones.
  • 0 in reply to Nancy Duhon
    One possibility is to run the bills and use the options to filter out the clients with balances only. Then put all the bills you just ran in proof stage. Generate the bills again but this time use the option for clients with balances only. Then print those bills. That will give you two separate piles.
    Another possibility is to use the Billing Assistant. When you view the list of clients you might be able to make use of the filters or at least see the clients with $0 value and separate the bill run. You might have to experiment with the filters to get what you want.
Reply
  • 0 in reply to Nancy Duhon
    One possibility is to run the bills and use the options to filter out the clients with balances only. Then put all the bills you just ran in proof stage. Generate the bills again but this time use the option for clients with balances only. Then print those bills. That will give you two separate piles.
    Another possibility is to use the Billing Assistant. When you view the list of clients you might be able to make use of the filters or at least see the clients with $0 value and separate the bill run. You might have to experiment with the filters to get what you want.
Children

*Community Hub is the new name for Sage City