Ideas for Acumatica

Feedback processing: 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. Ideas and comments may not appear immediately. Some legitimate ideas are flagged as spam and will be added when we review the spam folders.
Content: This portal is for product ideas and feedback only. If you need customer service assistance, contact your Acumatica Support Partner, submit a support case, or 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.

Expanded functions in Report Designer

It would be a huge improvement to include new functions to the expression editor or the ability to add custom functions to this editor. Specifically:

  1. a function to count distinct items in a field
  2. a date constructor ( so a custom date could be constructed using the day() month() year() items ie. date(month(today()),day(today(),year()) so that we could use dateadd() to generate very specific date ranges. 
  3. Days in year (returns the number of days in the current year)
  4. A running sum aggregate
  5. Concatenate for combining strings and results
  6. Financial Functions (Depreciation, NPV, standard excel and report finance functions. 
  7. Database and data type functions... Another large list of useful functions for data qualifying and filtering etc. 
  8. More text functions like extract from str, money, contains etc

Being able to add C# functions or something in a similar language would expand reporting functionality immensely

  • Allen Craig
  • Apr 27 2015
  • Future consideration
  • Attach files
  • Vladimir Panchenko commented
    January 31, 2019 18:22

    Sorry for the late answer.

    As Nayan and Gabriel said, it is possible to add your custom functions. But we'll think about adding more functions to the core product (reports + GI).

  • Gabriel Michaud commented
    August 03, 2015 17:46

    Hi Claudio - here's the file

  • Claudio LoCascio commented
    August 03, 2015 17:41

    Hi Gabriel - Just came across this thread and would love to get a copy of that article as well. I am currently attempting to get functionality to count unique values within a report, but would very much like to see information on customer function building in general. 

    Thanks!

  • Gabriel Michaud commented
    April 29, 2015 16:47

    Hi Craig - I just sent you an e-mail address with the full article. Let me know if you don't receive it!

  • Allen Craig commented
    April 29, 2015 16:31

    I have also used the KB link on the portal and cannot locate the article in question. 

  • Allen Craig commented
    April 29, 2015 16:30

    Thank you sorry to be a pain but that redirects to the partner portal home page... I am logged in and have tried copy/paste directly to address bar as well. I had this same issue trying to access a KB article monday...  

  • Gabriel Michaud commented
    April 29, 2015 16:28

    There's an error in the URL - just use this: http://bit.ly/1dt50Iw

  • Allen Craig commented
    April 29, 2015 16:16

     That link redirects to internal.acumatica.com I cannot access it

  • Nayan Mansinha commented
    April 27, 2015 21:23

    Acumatica report engine supports custom functions.  We have KB on this and can be accessed here: https://partners.acumatica.com/?CompanyID=USA&ScreenId=ShowWiki&pageid=0f2899f0-cb3f-4038-98f9-e20879f37a4f