Acumatica Cloud ERP starting to use .NetCore and its modern User Interface (UI) Tim Rodman has some more details on this. TIm Rodman, (CPA-Inactive) posted in Acumatica User Group by AUGForums.com ❤ My favorite session at Acumatica Summit 2023 was the developer session on the New Acumatica UI and .NET Core. Moving to the New UI and .NET Core is a massive undertaking that will probably take years to complete. Although it's a technical topic, it's important for "regular people" to understand because, in my opinion, it will make Acumatica an entirely different application. 🏃‍♀️ The main takeaway for "regular people", in my opinion, is that it will make screens in Acumatica A LOT FASTER. 🤔 Why will it be faster? Because more work will be done by your local browser and less work will be done by the web server. Currently, the IIS web server is a bottleneck that is overworked and slows down the Acumatica application. 🤣 The hilarious part about this is that the philosophy on this changes every decade or so. In the 1970s you had mainframe computers where all of the processing was done on the Server. In the 1980s and 1990s you had the PC revolution where processing moved to the Client. Then the internet took off in the 2000s and the processing moved back to the Server ("the Cloud"). Acumatica was born in the 2000s and so far has been all about processing on the Server. With the New UI, the processing now shifts back to the Client which is your web browser. You could say that we're now back in the 1980s 🕹 👍 That's fine with me though because I think it will make things faster overall. And it's not really the 1980s because we won't have to do local Windows client installs. Acumatica will still get deployed centrally in the cloud. 📄 You can checkout my notes from this session on the move to the New UI and .NET Core in this blog post: https://lnkd.in/gyvmGc_m 💡 Also note on the top of that blog post that there are links to my notes from the other sessions that I attended at Acumatica Summit 2023. Acumatica Summit 2023 – The New Acumatica UI, .NET Core, and xRP Framework Migration (Las Vegas, NV)

Tim Rodman presents: Tim Rodman, (CPA-Inactive)View Tim Rodman, (CPA-Inactive)’s profile • 1st Acumatica MVP, focused on reporting with Acumatica Reporting Tools, SQL, Excel, and Power BI 2w • This Acumatica Inventory Aging Report is part of my GI Library which you can browse here: https://lnkd.in/g8ike7Rp #Acumatica #ERP #CloudERP #GILibrary

Tim Rodman (augforums.com) is presenting AcuSQl https://www.linkedin.com/feed/update/urn:li:activity:7056803412771827712?updateEntityUrn=urn%3Ali%3Afs_feedUpdate%3A%28V2%2Curn%3Ali%3Aactivity%3A7056803412771827712%29 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. Omar Lieves, MBA, CSMView Omar Lieves, MBA, CSM’s profile (He/Him) • 1stManager at TriVista. We help business leaders transform their operations and financial performance. We advise clients on operations, supply chain, technology, and mergers and acquisitions. 10h That's what I am talking about! It would be really cool if one can then take the SQL to create a GI Tim Rodman, (CPA-Inactive)View Tim Rodman, (CPA-Inactive)’s profileAuthorAcumatica MVP, focused on reporting with Acumatica Reporting Tools, SQL, Excel, and Power BI 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. Christopher Eng, CAView Christopher Eng, CA’s profile • 2ndManager at CLA Digital | Acumatica MVP | Chartered Accountant 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 Tim Rodman, (CPA-Inactive)View Tim Rodman, (CPA-Inactive)’s profileAuthorAcumatica MVP, focused on reporting with Acumatica Reporting Tools, SQL, Excel, and Power BI 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