Solved

Using SQL View in Report Designer

  • 8 April 2022
  • 1 reply
  • 127 views
S
Rank

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.

icon

Best answer by BenjaminCrisman 8 April 2022, 17:12

View original

1 reply

BenjaminCrisman
Rank
Userlevel 7
Badge +4

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).

Reply


Terms & ConditionsCookie settings
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