By using this website, you agree to our Terms of Use (click here)
Can someone point me to where I can find some documentation of the colors available or how to select a color?
I am not sure if they have documentation anywhere, but these are the options:
bad, good, neutral, red, red60, red40, red20, red0, orange, orange60, orange40, orange20, orange0, green, green60, green40, green20, green0, blue, blue60, blue40, blue20, blue0, yellow, yellow60, yellow40, yellow20, yellow0, purple, purple60, purple40, purple20, purple0
If you check out .\*YourSiteFolder*\App_Themes\Default\00_Controls.css and look for anything that is .GridRow.[Style] you can find the css code. I ended up creating a custom theme. You can add extra css files and create your own custom GI styles by adding the files 01_Controls.css, 02_Controls.css, etc. If, for example you wanted to add Bold or Italic, you can create an 01_Controls.css file and add the following:
.GridRow.bold {
font-weight: bold;
}
.GridRow.italic {
font-style: italic;
}
.GridRow.red20bold {
background-color: rgba(255, 0, 0, 0.2) !important;
border-bottom-color: rgba(255, 0, 0, 0.2) !important;
font-weight: bold;
}
.GridRow.red20italic {
background-color: rgba(255, 0, 0, 0.2) !important;
border-bottom-color: rgba(255, 0, 0, 0.2) !important;
font-style: italic;
}
.GridAltRow.italic, .GridAltRow.bold
, .GridAltRow.red20italic, .GridAltRow.red20bold {
filter: brightness(98%);
}
You’re welcome. I learned about them initially from Acumatica’s summit last year. Once I had a version of 2019 R1 to test with, I added the purple20 style to a GI result. I used browser F12 tools to inspect the HTML and saw it added the purple20 style as a class on the element, and saw the css class for it on the side. I used windows search to look through the website files to find files with “purple20” in their contents. The other stuff about controls I picked up from either trial and error, Googleing articles about custom themes, or investigating their Indigo theme.
As for Dashboards, I don’t know if the styles carry over from GI into the Dashboard grid. If you use the browser F12 tools you should be able to investigate the element to see! It might just need a different css class to activate it besides “.GridRow.”. I have a feeling if it’s not there, it would be coming in a future release.
I can see a list of colors by clicking the Pencil Icon in the Row Style field on the RESULTS GRID tab of the Generic Inquiry (SM208000) screen, then click the Styles category:
Does conditional formatting in GI allow to use nested formulas?
I tried to apply color to only open bills that are past due, and it didn't work:
=IIf( [APInvoice.Status]='open', Switch([APInvoice.DueDate]<Today(), 'red'), 'default')
I am not sure if you already found a solution, but if the switch doesn't work, I know nested if's work. You could do:
=IIf( [APInvoice.Status]='open', IIf([APInvoice.DueDate]<Today(), 'red', 'default'),'default')
Have you been able to get any color to show up? If you put something simple like ='red' into the row style, does it turn everything red? And then something else like =iif(1=1,'yellow','red') should turn everything yellow. You could then try nesting the if to be =iif(1=1,iif(2=2,'green','yellow'),'red'). That should turn everything green. If that works, then the problem is in the iif statement logic and not with nesting iif's.
If I put =IIf( [APInvoice.DueDate]<Today(), 'yellow60', 'default') - it turns due date that are less than today to yellow, including those are closed,
when i put =IIf( [APInvoice.Status]='open', IIf( [APInvoice.DueDate]<Today(), 'red','default'), 'default') - it doesn't' do anything.
I tried changing the order a little and then changing APInvoice to be CuryOrigDocAmy and got my new version to work change color as expected so the issue is not with the nested IIF. There is something wrong with APInvoice.Status. I tried several variations of the logic: ='Open',='O',=Open. All of the variations resulted in a false value. Maybe someone else has gotten the APInvoice.Status to work in a condition.
My working example
=IIf( [APInvoice.DueDate]<Today(), IIf( [APInvoice.CuryOrigDocAmt]>1000, 'red','yellow'), 'green')
Just had a random thought while poking around Acumatica and it worked. Use the style below and it should work. Change colors to whatever you want. Since Status was giving us problems, I found another field that gave the same results.
=IIf( [APInvoice.DueDate]<Today(), IIf( [APInvoice.OpenDoc]=0, 'red','yellow'), 'green')
So far This is how I got the closest to what I wanted:
=IIf( [APInvoice.DueDate]<Today(), IIf( [APInvoice.CuryDocBal]>0, 'red0','default'), 'green')
But, for some reason, the formula picked up the closed bill as green.
Thank you for your help Ryan - the APInvoice.CuryDocBal was a good workaround about APInvoice.Status not working properly.
Try using docbal. If not, then look over the data and see if there is any other combination of fields that would give you the same results as status='open'. I have also had luck creating cases with Acumatica. There may be an easy solution for how to compare Status.
=IIf( [APInvoice.DueDate]<Today(), IIf( [APInvoice.DocBal]>0, 'default','red'), 'default')
I am trying to set conditional formatting on GI by row for shipping status in shipments. My goal is to have the row highlighted green if the status is "On Hold". However, every combination that I try fails. Can anyone suggest a formula?
Don't you need the Status Code rather than the word "Open"? Does this work?
=IIf( [APInvoice.Status]='N', Switch([APInvoice.DueDate]<Today(), 'red'), 'default')
Ah, yes, this is the same issue that I mentioned above.
In your case, here are the codes for SOShipment.Status that you can see by using CUSTOMIZATION -> Inspect Element: