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.

Add NetDateDiff function to Report Designer and Generic Inquiry

It would be useful to add a new function to Report Designer and Generic Inquiry that will calculate the difference between 2 days excluding weekends and bank holidays.

For example, date 1 is 02/07/2018 and date 2 is 17/07/2018.
If a datediff function is used, then the result will be 16.
04/07/2018 is public holiday.
06/07/2018, 07/07/2018, 13/07/2018, 14/07/2018 are weekends.
If public holidays and weekends are excluded, the result will be 11 (16-5).

The list of public holidays can be used from Work Calendars screen.

  • Ihor Patko
  • Jul 24 2018
  • Rejected
  • Attach files
  • Vladimir Panchenko commented
    11 Oct, 2018 02:19pm

    Thank you for your idea.

    Unfortunately, such calculations in Generic Inquiry are performed on the SQL server for performance sake, and it is not possible to perform it there because SQL server has no access to the public calendar.