Search Again: Re: liability report From: Shawn Hogan Date: Friday, December 11, 1998 Time: 12:04:04 pm Teresa Walters wrote: >Doesn't change anything. I have gone back and double verified. I printed out >the report with various date combinations. They all run the same way. > >The one thing that I can identify is that all of the accounts that have >invalid amounts fall into three categories. They are slaves, comp or >suspended accounts. > >What is not set properly that is causing these to show up this way? Well, the liability report has to make certain assumptions when it's calculated. It will never be 100% accurate because it gets into a sort of grey area. It should be close, but prbably not 100% accurate. Some of the assumptions it makes are: - The customer has at least one invoice. - The customer's last invoice is worth time credit - The customer's expiration date is correct It basically does two things, it figures out the amount that the customer pays for service per day. Then it takes that number and multipies it by the number of days between now and their expiration date. For all the nerds out there, the formula looks like this: --------- TextToNum(NumToText((Invoices::dInvoice Total / (Date(Month(Status(CurrentDate)) + Last(Invoices::cMonths Credit), Day(Status(CurrentDate)) + Last(Invoices::cDays Credit), Year(Status(CurrentDate))) - Status(CurrentDate))) * (Expiration Date - Status(CurrentDate)))) --------- - Shawn ------------------------------- Shawn D. Hogan President, Data Point Solutions http://www.data-point.com (619) 452-3696 ICQ: 8319647

Messages In This Thread: liability report by Teresa Walters on Dec 10, 1998 at 4:31:55 pm Re: liability report by Shawn Hogan on Dec 11, 1998 at 10:13:47 am Re: liability report by Teresa Walters on Dec 11, 1998 at 11:45:50 am Re: liability report by Shawn Hogan on Dec 11, 1998 at 12:04:04 pm Liability Report by Teresa Walters on Dec 18, 1998 at 4:02:58 pm Re: Liability Report by Shawn Hogan on Dec 18, 1998 at 6:37:21 pm Liability Report by Teresa Walters on Dec 22, 1998 at 3:48:19 pm Re: Liability Report by Shawn Hogan on Dec 22, 1998 at 4:08:32 pm Re: Liability Report by Teresa Walters on Dec 22, 1998 at 5:00:03 pm Re: Liability Report by Shawn Hogan on Dec 22, 1998 at 6:53:37 pm liability report by James \"Bubba\" Carter on Feb 13, 2001 at 6:48:13 pm Re: liability report by Shawn Hogan on Feb 13, 2001 at 6:54:17 pm Re: liability report by James \"Bubba\" Carter on Feb 13, 2001 at 6:58:54 pm Re: liability report by Shawn Hogan on Feb 13, 2001 at 7:09:54 pm Liability Report by James \"Bubba\" Carter on Jun 6, 2001 at 12:24:02 pm Re: Liability Report by Shawn Hogan on Jun 6, 2001 at 1:09:34 pm Liability Report by Michael Baird on Oct 10, 2001 at 12:58:35 pm Re: Liability Report by Shawn Hogan on Oct 10, 2001 at 2:20:03 pm Liability report by Henry on Oct 20, 2001 at 7:29:02 pm Re: Liability report by Shawn Hogan on Oct 20, 2001 at 7:39:00 pm Re: Liability report by Henry on Oct 23, 2001 at 9:21:33 am Re: Liability report by Shawn Hogan on Oct 23, 2001 at 11:11:48 am