Skip to main content
Solved

Help: GI Cell formating PO vs Avg Cost

joshmcgrew
Jr Varsity III
Forum|alt.badge.img

Hello, 

Brand new to Acumatica, I am creating a GI for PO vs Avg cost comparison and would like for the field that contains the PO cost to highlight red if its greater than the AVG cost field. I have the entire GI built but am having some trouble getting the format of the formula for this to happen. I was hoping maybe some one here could help me with this ?

 

Best answer by joshmcgrew

@lauraj46 Thank you that helped get me on the right path for sure and I appreciate it. It was still giving me a bit of a problem but we were able to get it to work with the following formula that I thought I would share incase others ran into this:


=Iif([POLINE.UnitCost] > [INITEMCOST.AvgCost],'red20','default')

 

 

View original
Did this topic help you find an answer to your question?

3 replies

lauraj46
Captain II
Forum|alt.badge.img+8
  • lauraj46
  • Captain II
  • 574 replies
  • February 16, 2024

Hi @joshmcgrew ,

To highlight on cell you would use a formula like this in the Style column of the result field that should be highlighted.  Or to highlight the entire row, you would enter the formula in the Row Style field on the Results Grid tab.

=IIf( IIf( [POLine.UnitCost] < [INItemCost.AvgCost.., 'red40', 'default')

 

​​​​​Hope this helps!

Laura 

Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Chris Hackett
joshmcgrew
2 people like this
  • Chris Hackett
    Chris Hackett
  • joshmcgrew
    joshmcgrew
joshmcgrew
Jr Varsity III
Forum|alt.badge.img
  • joshmcgrew
  • Author
  • Jr Varsity III
  • 18 replies
  • Answer
  • February 16, 2024

@lauraj46 Thank you that helped get me on the right path for sure and I appreciate it. It was still giving me a bit of a problem but we were able to get it to work with the following formula that I thought I would share incase others ran into this:


=Iif([POLINE.UnitCost] > [INITEMCOST.AvgCost],'red20','default')

 

 

Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett
Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • 2751 replies
  • February 16, 2024

Thank you for sharing your solution with the community @joshmcgrew!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
joshmcgrew
1 person likes this
  • joshmcgrew
    joshmcgrew

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved