Does anyone know how to use Styles to show color for invoices that are past due? I have the below formula.
=CDec( DateDiff( 'd', [ARInvoice.DueDate], Today()) )
Thank you.
Answer
Using Styles in AR Report for Past Due
Best answer by meganfriesen37
Your issue might be that you don’t have an alternate format when the condition is false. So if you add a ,’default’ at the end that might solve your problem, but I think you could probably simplify it if it’s just a 2 condition format (either it’s overdue or not) to something like this (just swap opportunity field with ARInvoice.DueDate.
=iif([CROpportunity.CloseDate]<Today(),'orange0','default')
+12The only way that I’ve been able to do it (in report designer) is to have multiple fields that are overlapping, each with different Visible criteria that do no conflict and then each field has separate formatting. I’ve done it to change branding colours if there’s multiple companies in a system or do do similar items to highlight overdue items or budgets > x% etc.
It’s easier to do in the Generic Inquiries.
Megan Friesen, Contego Software Solutions, Canada
Hi Megan,
It is a generic inquiry. This is what I have but it’s not working.
=IIf(DateDiff('d', Today(), [ARInvoice.DueDate]) < 0, 'orange0')
+12Your issue might be that you don’t have an alternate format when the condition is false. So if you add a ,’default’ at the end that might solve your problem, but I think you could probably simplify it if it’s just a 2 condition format (either it’s overdue or not) to something like this (just swap opportunity field with ARInvoice.DueDate.
=iif([CROpportunity.CloseDate]<Today(),'orange0','default')
Megan Friesen, Contego Software Solutions, Canada
That did it………...thank you Megan!!!
Here is the final formula:
=IIf(DateDiff('d', Today(), [ARInvoice.DueDate]) > 0, 'bad','good')
TamiLynn
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.