AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

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

Forums
AUG Forums
Acumatica Generic I...
Highlighting of Gen...
 
Notifications
Clear all

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

 
Page 2 / 2 Prev
Acumatica Generic Inquiries & Pivot Tables
Last Post by Michael Shirk 3 years ago
28 Posts
7 Users
2 Reactions
8,456 Views
RSS
Lorne W.
Posts: 25
 Lorne W.
June 10, 2022 11:48 am
(@lweinstein)
Eminent Member
Joined: 4 years ago

That was a great tip and it worked.  Thank you.  I have a related question.

I now want to do conditional formatting for the Customers GI using credit verification rules such as remaining balance.  How do I figure out how to add the correct table to the generic inquiry to use the following rules in my GI?

 

image

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

Famed Member
Posts: 3204
December 15, 2022 6:30 pm
Reply toLorne W.Lorne W.

@lweinstein Not in front of a computer right now so I'm replying from my phone and from memory, but those fields might be in the CR.Location table which I think you can join to on AR.Customer.DefLocation = CR.Location.LocationID


Reply
Lorne W.
 Lorne W.
(@lweinstein)
Joined: 4 years ago

Eminent Member
Posts: 25
December 16, 2022 12:35 pm
Reply toTim RodmanTim Rodman
Lorne W.

@timrodman I am looking in the DAC browser but am not able to find these tables.  How do you suggest I look them up?


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

Famed Member
Posts: 3204
December 16, 2022 1:26 pm
Reply toLorne W.Lorne W.
Tim Rodman
Lorne W.

@lweinstein Try this:

https://help.acumatica.com/dacBrowser/PX.Objects.AR/Customer

https://help.acumatica.com/dacBrowser/PX.Objects.CR/Location


Reply
Page 2 / 2 Prev
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,531 Topics
  • 11 K Posts
  • 16 Online
  • 2,418 Members
Our newest member: Chad Treadwell
Latest Post: Upgrade to 2025.2 Custom Report Run Report is missing
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

  • Dianne A Ed Dolan
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×