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...
Row Style Help
 
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 Row Style Help

Acumatica Generic Inquiries & Pivot Tables
Last Post by Tim Rodman 1 month ago
4 Posts
3 Users
5 Likes
475 Views
RSS
danielbyrum
Posts: 26
 danielbyrum
Topic starter
March 22, 2022 10:04 am
(@danielbyrum)
Member
Joined: 3 years ago

I am trying to highlight rows of a custom GI based on the comparison of values in two different 'cells'. The values are populated based on date parameters at the SOLine level. Basically the GI shows usage for stock items over the last few weeks. I would like to highlight one color when 'Last 7 Days' is greater than 'Last Week' and a different color when less than. The GI is just the SOLine DAC. I am using the date parameters at the top to bound the data for the given time period. There might be a different/better way to accomplish what I am after, so I am open to suggestions. Thanks!

 

image
image
Tim Rodman reacted
3 Replies
agupta
Posts: 15
 agupta
July 7, 2022 5:17 pm
(@agupta)
Member
Joined: 3 years ago

You can use a formula with nested if statements in the row styles entry box. Also, to simplify, you re-use the formulas in the results table for the row style logic - run your GI and then look at the most recent trace. Each of your active result formulas will have a label that looks something like:

image

Once you find the correct formula labels, you can use these labels in the row styles. I learned about it from this blog post, it was very helpful: https://www.acumatica.com/blog/how-to-use-acumatica-generic-inquiry-row-styles-with-aggregated-values/

 

Reply
Jwright, danielbyrum and Royce Lithgo reacted
danielbyrum
 danielbyrum
(@danielbyrum)
Joined: 3 years ago

Member
Posts: 26
July 11, 2022 5:23 pm
Reply toaguptaagupta

@agupta, this worked great! Thanks for sharing. It did take me a few minutes to find the formulas. I ended up deactivating all but one, and running the trace for each formula.

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

Member
Posts: 2957
December 27, 2022 11:32 pm
Reply toaguptaagupta

@agupta That's brilliant! Thank you for sharing that post!

Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 11 Forums
  • 2,236 Topics
  • 9,868 Posts
  • 4 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.

‹›×

    ‹›×