AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Course
  • Consulting
  • Login
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica Generic I...
Highlighting of Gen...
 
Notifications
Clear all

In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Sincerely,
Tim Rodman

Questions Highlighting of Generic Inquiry Rows or Columns in Data Table Widgets

Page 1 / 2 Next
Acumatica Generic Inquiries & Pivot Tables
Last Post by Tim Rodman 2 months ago
26 Posts
6 Users
1 Likes
2,780 Views
RSS
paulsw
Posts: 12
 paulsw
Topic starter
January 21, 2020 11:13 pm
(@paulsw)
Member
Joined: 3 years ago

Can someone point me to where I can find some documentation of the colors available or how to select a color?

25 Replies
Wyatt.ERP
Posts: 128
 Wyatt.ERP
January 22, 2020 12:07 pm
(@wyatt-erp)
Member
Joined: 3 years ago

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%);
}

Reply
paulsw
 paulsw
(@paulsw)
Joined: 3 years ago

Member
Posts: 12
January 23, 2020 12:55 pm
Reply toWyatt.ERPWyatt.ERP

@wyatt-erp

Thank you!

How did you learn about these values in the Controls.css?

Do you know if this same ability to add colors is available for the dashboard tiles?

Reply
Wyatt.ERP
Posts: 128
 Wyatt.ERP
January 23, 2020 2:38 pm
(@wyatt-erp)
Member
Joined: 3 years ago

@paulsw

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. 

Reply
Tim Rodman
Posts: 2957
 Tim Rodman
Admin
February 19, 2020 11:43 pm
(@timrodman)
Member
Joined: 7 years ago

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:

Reply
Erzi Zairbekova reacted
Erzi Zairbekova
Posts: 6
 Erzi Zairbekova
April 15, 2020 1:06 pm
(@erzi-zairbekova)
Member
Joined: 3 years ago

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')

Reply
Ryan Brown
Posts: 82
 Ryan Brown
April 22, 2020 3:16 pm
(@ryanxbyte)
Member
Joined: 3 years ago

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')

 

Reply
Erzi Zairbekova
 Erzi Zairbekova
(@erzi-zairbekova)
Joined: 3 years ago

Member
Posts: 6
April 22, 2020 6:16 pm
Reply toRyan BrownRyan Brown

@ryanxbyte Thank you for your reply! 

I just tried your way - didn't work either, not sure why... 

Reply
Ryan Brown
Posts: 82
 Ryan Brown
April 22, 2020 10:59 pm
(@ryanxbyte)
Member
Joined: 3 years ago

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.  

Reply
Erzi Zairbekova
Posts: 6
 Erzi Zairbekova
April 23, 2020 9:45 am
(@erzi-zairbekova)
Member
Joined: 3 years ago

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.

Reply
Ryan Brown
Posts: 82
 Ryan Brown
April 23, 2020 11:27 am
(@ryanxbyte)
Member
Joined: 3 years ago

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')

Reply
Ryan Brown
Posts: 82
 Ryan Brown
April 23, 2020 3:42 pm
(@ryanxbyte)
Member
Joined: 3 years ago

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')

Reply
Erzi Zairbekova
 Erzi Zairbekova
(@erzi-zairbekova)
Joined: 3 years ago

Member
Posts: 6
April 23, 2020 4:36 pm
Reply toRyan BrownRyan Brown

@ryanxbyte

This is what the outcome 🙁 

image

 

 

Reply
Ryan Brown
 Ryan Brown
(@ryanxbyte)
Joined: 3 years ago

Member
Posts: 82
April 23, 2020 4:41 pm
Reply toErzi ZairbekovaErzi Zairbekova
Ryan Brown

@erzi-zairbekova You're going to have to change the colors back to what you wanted.  I did the multiple colors to better trace what was happening.

 

=IIf( [APInvoice.DueDate]<Today(), IIf( [APInvoice.OpenDoc]=0, 'default','red'), 'default')

Reply
Erzi Zairbekova
 Erzi Zairbekova
(@erzi-zairbekova)
Joined: 3 years ago

Member
Posts: 6
April 23, 2020 5:15 pm
Reply toRyan BrownRyan Brown
Erzi Zairbekova
Ryan Brown

@ryanxbyte I see, but I meant was, that it applies color even to those are closed:

=IIf( [APInvoice.DueDate]<Today(), IIf( [APInvoice.OpenDoc]=0, 'default','red'), 'default')

image

 

 

Reply
Erzi Zairbekova
Posts: 6
 Erzi Zairbekova
April 23, 2020 5:22 pm
(@erzi-zairbekova)
Member
Joined: 3 years ago

So far This is how I got the closest to what I wanted:

=IIf( [APInvoice.DueDate]<Today(), IIf( [APInvoice.CuryDocBal]>0, 'red0','default'), 'green')

image

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.

Reply
Ryan Brown
Posts: 82
 Ryan Brown
April 24, 2020 3:16 pm
(@ryanxbyte)
Member
Joined: 3 years ago

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')

Reply
Tim Rodman
Posts: 2957
 Tim Rodman
Admin
July 13, 2020 11:18 pm
(@timrodman)
Member
Joined: 7 years ago

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')

image

 

image
Reply
Lorne W.
Posts: 20
 Lorne W.
June 3, 2022 8:33 pm
(@lweinstein)
Member
Joined: 10 months ago

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?

Reply
Tim Rodman
 Tim Rodman
Admin
(@timrodman)
Joined: 7 years ago

Member
Posts: 2957
June 10, 2022 11:10 am
Reply toLorne W.Lorne W.

@lweinstein Can you screenshot the formula that you are using?

Reply
Lorne W.
 Lorne W.
(@lweinstein)
Joined: 10 months ago

Member
Posts: 20
June 10, 2022 11:22 am
Reply toTim RodmanTim Rodman
Lorne W.

@timrodman =IIf( [SOShipment.Status]='Open', 'green', 'default' )

Reply
Tim Rodman
Posts: 2957
 Tim Rodman
Admin
June 10, 2022 11:27 am
(@timrodman)
Member
Joined: 7 years ago
Posted by: @timrodman

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:

image
Reply
Page 1 / 2 Next
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 11 Forums
  • 2,239 Topics
  • 9,872 Posts
  • 6 Online
  • 1,813 Members
Our newest member: Marion Hooley
Latest Post: Export Scenario - Export same row twice (Conditionnal)
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2023 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×