Search Again: Re: a quickie.... From: Shawn Hogan Date: Wednesday, March 3, 1999 Time: 1:18:59 pm David Day wrote: >Hi Shawn - in the A/R report, is the field "Days Past Due" based on the >invoice date, or on the expiration date? It is (copy/paste): ---- If(Balance Due > 0, Status(CurrentDate) - If(Min(Open Invoices::Invoice Date) > Expiration Date, Min(Open Invoices::Invoice Date), Expiration Date), 0) ---- Which means it varies... It is Expiration Date, unless thier first open invoice was created AFTER thier Expiration Date, in that case, it's the lowest first Open Invoice Date. The reason is this... if they expire on 1/1/99, but never even had an invoice created until 2/1/99 (for whatever reason), they aren't 2 months past due because in January they never owed anything. - Shawn ------------------------------- Shawn D. Hogan President, Data Point Solutions http://www.data-point.com (619) 452-3696 ICQ: 8319647 ------------------------------------------- To subscribe, unsubscribe and list archive please visit http://www.data-point.com/lists -------------------------------------------

Messages In This Thread: Re: a quickie.... by Shawn Hogan on Mar 3, 1999 at 1:18:59 pm