Skip to main content
Answer

How to determine which Out-of-the-box Generic Inquiries have been Modified

  • September 19, 2023
  • 3 replies
  • 84 views

Forum|alt.badge.img+2

There are several Generic Inquiries provided out-of-the-box when a new tenant is set up.  If these Generic Inquiries get modified by a user, they can stop working correctly after an upgrade.

Does anyone know if there is a way to determine which if any out-of-the-box Generic Inquiries have been modified without having direct SQL access?  Hoping to avoid having to build something like a customization or SQL View.

Best answer by Laura03

Help, npace29 provided a GI for the same period in a previous post: 

Laura

3 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+17
  • Captain II
  • September 19, 2023

HI @stephenbologna39 

You can enable Audit History and see who edited the GI. On the top right corner go to Tools > Audit History

It will then show you the user modifications

 

Here is also a help article to get you started:

https://help.acumatica.com/(W(8))/Help?ScreenId=ShowWiki&pageid=28476e3a-7a5a-43a9-b76a-7a93b5ba758a


Forum|alt.badge.img+2

Thanks Kandy

The Row Level Auditing shows some of what I’m looking for, but I’m hoping to find a way to see if a given Generic Inquiry was provided out-of-the-box (as opposed to user created), and if so, if it has been modified by a user.  Ideally it would be great if it could be turned into a report or GI as well.

I know this can be done with direct SQL access, but I’m wondering if there some other way to tell without having to go to the database.


Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • Answer
  • September 20, 2023

Help, npace29 provided a GI for the same period in a previous post: 

Laura