Search Again:

Re: Feature Request

From: Ben Brancato
Date: Wednesday, August 1, 2001
Time: 9:35:34 am

Yeah, thats cool. I can see how that would seriously be a headache.

I wish there was a way that you could make it to where the oldest invoice
set the Expiration date and then when the account got paid the Expiration
Date wouldnt roll to show past due. So if no Billing Cycle item then
Expiration Date is not rolling unless it is moved up by an invoice. If
there is already an outstanding invoice then Expiration Date does not move
up. It is only on the first one.

That way you wouldnt have to worry about searching a million invoices. It
would still go by Exp. Date.

Ben


----- Original Message -----
From: "Shawn Hogan" <shawn@digitalpoint.com>
To: "Optigold ISP List" <isp-list@optigold.com>
Sent: Wednesday, August 01, 2001 2:06 AM
Subject: Re: [Optigold ISP] Feature Request


> 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
> ---------------------------------------------------


---------------------------------------------------
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