Skip to main content
Solved

Using SQL View in Report Designer

  • Apr 8, 2022 2:14 PM UTC
  • 1 reply
  • 181 views
  • Translate All
Freshman I

Hi,

Is it ok to use SQL view in report designer. Whether Acumatica is planning to remove that option is near future ? 

Is there any other option other than SQL view, if I want to aggregate transaction quantity in released status for YTD and last year.

Thanks,

Shyam.

Best answer by BenjaminCrisman

Hi @snath ! There are no plans that I know of to reduce functionality around SQL views.

A couple other options may be to make a custom table instead of a view or use variables within the report to total the amounts (unless you are wanting to bring in the already summed amounts).

View original

1 reply

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • BenjaminCrisman
  • Acumatica Support Team
  • Answer
  • Apr 8, 2022 3:12 PM UTC

Hi @snath ! There are no plans that I know of to reduce functionality around SQL views.

A couple other options may be to make a custom table instead of a view or use variables within the report to total the amounts (unless you are wanting to bring in the already summed amounts).

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