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.