Ideas for Acumatica

Important! Please note that we do not reply to all messages, but we do read them, analyze them, and work to improve Acumatica based on the feedback we receive.
This portal is for product ideas and feedback only. If you need customer service assistance, please contact your Acumatica Support Partner or submit a support case.  You can also get assistance from community resources:  LinkedIn Group or StackOverflow
No Reliance: Information is maintained on a best-efforts basis and may be changed without notice. Acumatica cannot guarantee the accuracy of the information provided or guarantee completion of features/ideas described on this portal. 

Be able to create Generic Inquries from sql statement, view or stored Procedure

Be able to create Generic Inquries from sql statement, view or stored Procedure. Have a window that you can insert a sql query, view, or stored proc call as an option which would then exclude tables and relations. The other tabs would still be available, then you build your summary data anyway you want.
  • Guest
  • Nov 3 2014
  • Gathering Feedback
  • Attach files
  • Delmer Johnson commented
    August 03, 2015 16:21

     I cannot support this idea as currently written for several reasons. First, I do not understand the request. What does it mean to "insert a sql query, view or stored proc call... which would then exclude tables and relations." I honestly have no idea what that means.

    Second, and more important, many security experts would include SQL Injection attacks among the top security vulnerabilities on the internet. When you write SQL for a web site you had better know what you are doing, and people who think they do still make mistakes. There's a reason why this remains in top ten lists year after year (see OWASP.org).

    In addition, Acumatica can run on different databases engines (SQL Server or MySQL) and SQL syntax differs between them. That's one reason why Acumatica developed Business Query Language (BQL), which represents a safer, supported alternative.

    Finally, there is no way, as far as I know, to get the current CompanyID from Acumatica, making it difficult to properly filter SQL statements in a multi-company environment. Having such a call is a necessary first step to writing a parameterized stored procedure (and stored procedures, as I understand it, are not supported by Acumatica).

  • Tim Rodman commented
    June 10, 2018 04:09

    You can already bulld a Generic Inquiry on top of a SQL View ike this: https://www.acumatica.com/blog/technical-tuesday-report-from-sql-view/

  • Vladimir Panchenko commented
    June 22, 2018 11:16

    Could you please explain this idea in more details?

    Do you want to take a SQL select / SQL view and convert it to Generic Inquiry settings (tables, relations, sorts, etc.)?

  • David Eichner commented
    August 15, 2018 20:20

    I'd also like to be able to copy complex SQL into a screen and have it show the equivalent BQL.