Skip to main content
Solved

Use SQL Store procedure or SQL Function in Report Designer

  • October 23, 2025
  • 1 reply
  • 63 views
  • Translate All

Hi, is it possible to use SQL stored procedures or SQL functions in Report Designer?

Best answer by BenjaminCrisman

​@nelsoncosme18 I’m not sure exactly what you’re trying to use, but you can make a SQL view which might have the functions you’re looking for and then upload it as a customization and add the table to the report. Otherwise, for me, I’d need more specific examples of what you’re trying to accomplish

View original

    1 reply

    BenjaminCrisman
    Acumatica Employee
    Forum|alt.badge.img+4

    ​@nelsoncosme18 I’m not sure exactly what you’re trying to use, but you can make a SQL view which might have the functions you’re looking for and then upload it as a customization and add the table to the report. Otherwise, for me, I’d need more specific examples of what you’re trying to accomplish

    Translate
      Terms & ConditionsAccessibility statement
      About Acumatica ERP system
      Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
      © 2008 — 2024  Acumatica, Inc. All rights reserved