Tim Rodman (augforums.com) is presenting AcuSQl
If you miss having access to SQL in Acumatica SaaS environments, then you're going to like what I've been working on. I think the screenshot says it all 😀 I'll be reaching out to my email list for beta testers in the near future so make sure that you're subscribed here if you'd like to learn more: https://lnkd.in/gr5vRH9X #Acumatica #ERP #CloudERP #FreeTheData
"Upload to Custom Table from CSV" would be a cool feature to have. Would one of you mind creating that feature request here:https://www.augforums.com/forums/acusql
You can sort of accomplish this by creating a custom table (1st screenshot), then creating a big INSERT statement into that custom table (2nd screenshot). If you had the data in Excel, you could add a custom column to automatically generate the INSERT statement. Then you'd be able to query your custom table (3rd screenshot). It's not that practical though because currently you can only put up to 4,000 characters in the SQL Command field which can't handle much data. For example, the INSERT statement in my screenshot below is 213 characters so I'd hit the 4,000 character limit pretty quickly and I could probably only insert less than 100 rows or so at a time.
10h
That's what I am talking about! It would be really cool if one can then take the SQL to create a GI
9h
So true Omar Lieves, MBA, CSM. Checkout my reply to Christopher Eng, CA for a way to do that. Not super clean, but doable. A future feature request is to have the ability to schedule SQL Queries so you could essentially build a Data Warehouse within Acumatica using Custom Tables that get re-populated nightly on a schedule. Then have reports that draw from those Custom Tables.
16h
Looks cool! Is there any way to save the result as a DAC or in some other form that can be used in dashboards and reports?
Like1
Reply1 Reply1 Comment on Christopher Eng, CA’s comment
Tim Rodman, (CPA-Inactive)View Tim Rodman, (CPA-Inactive)’s profileAuthorAcumatica MVP, focused on reporting with Acumatica Reporting Tools, SQL, Excel, and Power BI
10h
Not directly, but feel free to request that feature in the AcuSQL forum here: https://www.augforums.com/forums/acusql
What you can do though is create a SQL View using AcuSQl (1st screenshot), then you'll be able to select from the SQL View (2nd screenshot), then you can use these instructions to connect the SQL View to a DAC and use it in Dashboards and Reports: https://www.augforums.com/acumatica-comma-separated-list-of-shipments-for-a-sales-order-using-a-generic-inquiry-and-sql-view
19h
Tucker Hoss Just Microsoft SQL Server to keep thing simple. Subqueries work (see screenshot), but I just tried a CTE and it didn't work. You can submit a feature request in the AcuSQL forum for CTE support here (just launched tonight): https://www.augforums.com/forums/acusql
