Jump to content

List credit clients


DiegoM

Recommended Posts

create user groups, call one CC or Credit etc. select a color like light green, then when you view your customers all that you have that you changed to the CC group will be highlited with the light green, you can make other groups for other reasons, have not tried but you may be able to do a customer search on the group name ... hope this works for you

Link to comment
Share on other sites

create user groups, call one CC or Credit etc. select a color like light green, then when you view your customers all that you have that you changed to the CC group will be highlited with the light green, you can make other groups for other reasons, have not tried but you may be able to do a customer search on the group name ... hope this works for you

that wouldn't really work - ignoring the fact that you'd have to go through all the clients assigning some to the "credit" client group!... and just because they were in credit today, wouldn't necessarily mean they would be in credit tomorrow.

 

now if you could automate it, that might be a different matter - there is a "Set Client Groups" addon, but I don't think you can use it based on credit balance - http://www.whmcs.com/appstore/450/WHMCS-Set-Client-Groups.html

 

in any event, if you can use phpmyadmin or similar sql query tools, just use the following and you'll get a list of those with credit.

 

SELECT * from tblclients where credit > 0

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated