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

— The Forums are now read-only —

— All new activity now takes place here: —

AugForums.com Discord Server
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
9,723 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,533 Topics
  • 11 K Posts
  • 29 Online
  • 2,439 Members
Our newest member: Ralph Torres
Latest Post: Nested SubReport Issue
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

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

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×