By using this website, you agree to our Terms of Use (click here)
I am making an "Open Purchase Order Lines" report. Really not sure what to title/call it. Basically any line on the purchase order that is still open. This was easy using the =[POLine.BaseOpenQty] Value. I wanted to highlight (change background color) of the BaseOpenQty only if it is greater than 1. Is that easy to do without coding? see my picture for what I am trying to accomplish.
Ahh, Should have searched more thoroughly. So visible expressions are the answer
I received an answer over at community.acumatica.com
Here is what worked:
- As you said, we need to have two fields. One for Color one and other one is default field.
- For the Colored one, you can provide the Background color
- Yes, we need to provide the Visible expression for the 2 fields like below
Visible Expression for Backgroud Colored Field =[POLine.BaseOpenQty] > 1
Visible Expression for Non - Backgroud Colored Field =[POLine.BaseOpenQty] <= 1
Attached screenshots for your reference.
Thanks for sharing. Also note that you can do this in a Generic Inquiry without overlapping fields.