August 2, 200124 yr Newbies I am able to see what invoices are outstanding? fields: inv_date inv_datePaid invElsaped calculation > If(inv_datePaid="","", inv_datePaid - inv_date) My terms are net 30 days,so an invoice is not past due until 30 days have past. This is what I have tried so far: field: day_outstand calculation > Today- inv_date days_PastDue calculation > Today- inv_date + 30 I'm doing something wrong...please help
Create an account or sign in to comment