Search Again:

Re: Feature Request

From: Shawn Hogan
Date: Wednesday, August 1, 2001
Time: 12:07:43 am

Ben wrote:

> Right. A good question that I thought of also, but didnt know how to
> answer.
>
> Here is the problem I have. If we do work for a customer and his Exp. Date
> is 7/1/01 we bill him and he pays and his expiration date stays the same
> because the invoice and his account have no billing cycle items with time
> credit. So when 7/2/01 rolls around it says he is 1 day past due and it
> keeps counting up with every day. So when I go to put customers on hold
> that account shows up. When in reality he owes nothing.
>
> So how about this....if his billing cycle items is blank disregard Exp. Date
> so they dont show up in the Hold que. This is ok because if they dont have
> a billing cycle then they arent generating invoices automatically.
>
> That could solve one problem i think. Then if you could possibly make it to
> where if you are searching for Past Due Accounts it would search the
> invoices of accounts that dont have billing cycle items. Or something like
> that. I am not exactly sure how to go about this one, but you understand
> what I am getting at right?

Well ultimately it comes down to an issue of speed... it's of course
possible, but then what you are finding customers due for a past due notice
or whatever, you not only need to search on expiration date and everything
else that it bases it on already, but then you would have to search on due
date for every invoice in the system... through an unindexable relationship
at that. Which throws the search time from 2 seconds to 5-10 minutes if you
have a lot of invoices... and it would only get slower the more invoices you
have...

That right there is the *real* core of the problem. It's not that I have
not given (a lot of) thought to it... :-)

- Shawn

-------------------------------
Shawn D. Hogan
President, Digital Point Solutions
http://www.digitalpoint.com
(858) 452-3696


---------------------------------------------------
To subscribe, unsubscribe or to search list archive
please visit http://www.optigold.com/lists/isp.html
---------------------------------------------------


Messages In This Thread:


Return to Digital Point Solutions' Home Page

home
products
services
support
email lists
optigold isp
optigold isp news
home inspection
inspectrix
java companion
oracle
quickdns pro
search engine
veterinary
tips
employees
free tools
portfolio
jobs
contact

Sales:
888/4-DPOINT

Support:
858/452-3696


Search:
Add this to your site