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.

Stored Procedures to be linked in Acumatica

Does Acumatica have any feature that enables stored procedures to be used within the current framework for reporting purposes?

stored procedures allow us to set a lot more complex and dynamic approaches to manipulating data in the way we require it to be shown.

For a quick example, my client wishes to have a quick view of all inventory information on a single table:

Inventory ID, Inventory warehouse location, current on hand quantity, current order quantity, current committed quantities, historical sales quantities (by year), historical purchase quantities (by year), and current cost. 

without the usage of stored procedures, at the current moment i cant seem to be able to appropriately pull our such information into a single report or query for the user to extract on his own as such reports will definitely use temp tables in stored procedure functions/ 

 

Please assist to look into this if there is such functionality or a proposition to have such a functionality added

  • Guest
  • Jan 13 2015
  • Attach files