AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • 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...
Generic Inquiry to ...
 
Notifications
Clear all

Questions Generic Inquiry to Show Where GI's are Used in Dashboards

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by Tim Rodman 2 years ago
4 Posts
3 Users
5 Reactions
1,331 Views
RSS
Brett Clark
Posts: 10
 Brett Clark
Topic starter
October 27, 2023 10:34 am
(@bclark)
Eminent Member
Joined: 3 years ago

Hello! 

Is it possible to track where a GI is being used elsewhere in Acumatica? For example, can we see any dashboard/widget where a GI is behind it? 

I've been tasked with cleaning up our GI list, but I don't want to remove anything that may be powering a widget on a dashboard somewhere. 

Thanks in advance!


Topic Tags
Generic Inquiry widgets
3 Replies
cwomack
Posts: 8
 cwomack
October 27, 2023 3:04 pm
(@cwomack)
Active Member
Joined: 5 years ago

This should get you started.  Create a GI with the table PX.Dashboards.DAC.Widget.  it is messy but it works.

We added the following formula to pull out the GI numbers. 

=Substring([Widget.Settings],InStr([Widget.Settings], '<InquiryScreenID>')+17,8)

If I was to give this to a customer I would clean it up a lot more but for internal usage it's ok. 


Reply
Dianne A and Brett Clark reacted
Brett Clark
 Brett Clark
(@bclark)
Joined: 3 years ago

Eminent Member
Posts: 10
October 27, 2023 4:21 pm
Reply tocwomackcwomack

@cwomack Thank you!


Reply
cwomack reacted
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
October 28, 2023 9:42 pm
(@timrodman)
Famed Member
Joined: 10 years ago

Great formula @cwomack !

Also note that Acumatica 2023 R2 has a new WIDGETS tab on the Dashboards (SM208600) screen which is kind of the opposite of what you're looking for here, but it's related:

image

 

 


Reply
cwomack and Brett Clark reacted
Forum Jump:
  Previous Topic
Next Topic  
Related Topics
  • Unable to Add Field "Unapplied Balance" to Generic Inquiry "Payments and Applications"
    6 months ago
  • Equivalent to Excel Post-Special, "transpose"
    1 year ago
  • Generic Inquiry - Last Modified On Date Change
    1 year ago
  • Generic Inquiry, pulling data from two unrelated sources
    1 year ago
  • Adding Override Contact Info to GI Results
    1 year ago
Topic Tags:  Generic Inquiry (41) , widgets (4) ,
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 39 Online
  • 2,338 Members
Our newest member: Shoaib Shafquat
Latest Post: Pick List report suddenly not splitting on Shipment
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

  • Julian Schrenzel David Edmonson Michael Ricke
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×