Need Help with IF Statement in GI

Hello,

On the last formula I provided above,  another color may be needed, after ‘red40’, for the “else” - name the color for lines that are not late.

For example, ‘red40’, ‘yellow,).

Laura 

Hello ​@Laura02 ,

Thank you so much for correcting the IF statement. I used the statement for style, and I got this error message:

Here is my formulla:

Hello,

Mine works fine like this:

=IIF( [ARInvoice.DocType]='INV' AND [ARInvoice.Status]='N' AND [ARInvoice.DueDate]<Today(), 'red40','default')

This doesn’t work for me:

=IIF( [ARInvoice.DocType]='INV' AND [ARInvoice.Status]='N' AND [ARInvoice.DueDate]<(Today()-5), 'red40','default')

In this previous post answered by Daryl Bowman, I found the following suggestion:

=IIf([SOOrder.CustomerRefNbr]='PRO FORMA' And [SOOrder.Status]='R' And [SOOrder.OrderDate] < DateAdd(Today(),'d',-7),'red20', 'default')

Laura

Hello ​@Laura02 ,

Thanks for sending this, and I will look at Daryl Bowman's answer later. Where you see the invoice type is “INV” and the invoice status is “N.” In my screen the invoice type is either “Invoice,” or “Credit Memo,” etc. same thing with the status is either “Open,” or “Closed,” etc. 

Because I wonder what the invoice type would be for a credit memo or the status for closed. 

Hello ​@Dawood ,

Please open a new post if you have additional questions.  I am the only person receiving notifications when you continue posting on an answered thread. This is the last question I will answer here. 🤐

To see the possible values for a field, click Customization → Inspect Element, and then click the field. In this example I have clicked on Document Type:

Laura