Hi Lorne, Going through old posts here. You probably figured this out already, but here's a way to get what you're looking for with a Generic Inquir...

@bmorgan @nscyoc I'll throw another idea out there and that is to use a SQL View to do the calculation. Then you could use the SQL View in your Generi...

I haven't heard any updates on this from an Acumatica perspective. I suspect that it was a curiosity thing that didn't go anywhere. I did though hav...

This is now possible with AugSQL (click here). With AugSQL, you can trigger a SQL script with a Business Event in Acumatica.

@tpayne You can post ideas here in this AugSQL Forum. I'll tag posts that are ideas with either Idea - Planned or Idea - Gathering Feedback. You can u...

@miirsystems Excellent, glad to hear it!

@charles-craig very interesting. I will confer with @AugSQL developer

@charles-craig Great points, thank you! I was subconsciously discriminating against Mac users. Thank you for reminding me that not everyone uses Win...

It would also be interesting if pressing Ctrl-V in an AugSQL window could do the following: 1. Populate the SQL Command field with whatever is on th...

On Podcast Episode #111 that we just recorded today, Kandy reminded me that you can move User-Defined Fields to wherever you want them. 1. Go to...

@lweinstein It's been A LONG time since I looked at this personally, but here's an article on configuring the Universal Search in Acumatica:

@mgarner Welcome Michael. Make sure that you add Velixo to your discovery process since you're interested in financial planning/reporting.

@charles-craig Ya, IIS is a big bottleneck right now, but the current move to .Net Core is a major rewrite of the application and will speed things up...

Thank you everyone for all of your feedback on this Discussion Topic. I've closed it for comments because I figured out how to enable the comments sec...

@astra-mathis Agreed. There are a lot of improvements that could be made to formatting in both Generic Inquiries and Pivot Tables.

@mcraig I'm glad that you updated this old post. It reminds me that I now have a workaround for this. You can set Export Top to 1 which essentially pr...

I'm not sure if that's possible, but that's definitely an interesting idea.

In my experience, there are a lot of "hidden surprises" when working with Acumatica Dashboards. They surprise you when you're trying to do something t...

This is a brilliant idea! I've never tried using a Generic Inquiry to "daisy chain" Import Scenarios together, but that would be really cool if someon...

@michaeltriffon Thank you for the script! I hadn't heard of Pulover's Macro Creator before. It looks like it's based on AutoHotkey.

Ya, the slowness is due to IIS, not SQL. I wish it was faster too 😀 AugSQL is a project that I'm working on. More info here:

Thank you so much for the explanation. I totally agree that Business Events with Trigger by Action are the way to go. Mass Actions is a legacy feature...

We tested and determined that you can't use AugSQL in an unlicensed Tenant on an Instance that has a licensed Tenant in it. That was the only loophole...

We're thinking of removing the SELECT button and having the EXEC button do what the SELECT button currently does. Actually, we might want to call the ...

As I was creating the Passing Parameters to SQL Queries idea (click here), I thought about a different way to handle this Scheduled Queries idea. ...

@timsql I was also thinking that there could be issues with the URL length for long queries. You'd also probably lose spacing and indents which ...

This could be a way to achieve this using out-of-the-box Acumatica functionality:

I just updated this to Idea - Planned (click here) Our current goal is to only allow you to run SELECT statements when you have Access Rights of Vie...

@robertsternberg We could take a conservative approach and only enable EXEC for users with Delete Access Rights. All other Access Rights would only ge...

@robertsternberg Good point about TRUNCATE, DROP, and Stored Procedures. It does indeed get very difficult when you get into the details. For securi...

@amassey I like your "2 type" suggestion. That's a lot simpler than my complicated idea. By "license type", are you suggesting a way to restrict wha...

@amassey glad to hear that it was easy and straightforward. Looking forward to hearing how your testing goes.

An idea that @AugSQL had on this was to somehow use the regular Acumatica security permissions of Insert, Delete, Edit, etc. Since there are more SQ...

@robertsternberg an audit log is a good idea. I just moved your post into a new Idea so we can track it separately.

Great point Henry. I was trying something that would illustrate an error message, but you showed a great example of how creative you can get with SQL....

@robertsternberg Roger that. This has been the most frequently requested feature so far.

We went with AugSQL 1.0.0 for the first beta launch version so I'm marking this idea as completed:

Currently this is what happens when you try to do BEGIN TRAN, then COMMIT TRAN:

I wonder if the clock entries might be marked as deleted, but still present in the database.