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 Report De...
Conditional Backgro...
 
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 Conditional Background color highlight

Acumatica Report Designer
Last Post by Tim Rodman 1 year ago
4 Posts
2 Users
2 Likes
668 Views
RSS
Richard
Posts: 43
 Richard
Topic starter
December 30, 2021 3:36 pm
(@richard)
Member
Joined: 3 years ago

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.

Purchase Order Open QTY

 

3 Replies
Richard
Posts: 43
 Richard
Topic starter
December 30, 2021 3:46 pm
(@richard)
Member
Joined: 3 years ago

Ahh, Should have searched more thoroughly. So visible expressions are the answer

visexp

 

Reply
Richard
Posts: 43
 Richard
Topic starter
December 31, 2021 9:44 am
(@richard)
Member
Joined: 3 years ago

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.

2a19f53a f154 464a 9f92 6d6d0ce0d73a
9ad832ef f683 4287 b2b2 3a7d508e46c3
Reply
Dianne A and Paul Gilfoy reacted
Tim Rodman
Posts: 2957
 Tim Rodman
Admin
December 31, 2021 8:40 pm
(@timrodman)
Member
Joined: 7 years ago

Thanks for sharing. Also note that you can do this in a Generic Inquiry without overlapping fields.

Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 11 Forums
  • 2,236 Topics
  • 9,868 Posts
  • 5 Online
  • 1,812 Members
Our newest member: Heather Jones
Latest Post: Sales Order Comment Lines / Memo / Note Lines
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.

‹›×

    ‹›×