Hello everybody,

today I want to leave a quick note on how to make coloring in Acumatica Generic inquiries. Recently I wanted to modify "AR-Invoices and Memos", and I wanted to highlight in red those invoices, which expiration date is greater then 120 days. Something like image below:

How to achieve that? 

with help of DATEDIFF and IIF function. 

Putting of this formula in the style column:

=iif(DATEDIFF('d', [ARInvoice.DocDate], Today()) > 120, 'red', 'green')

gave me needed result.