I’m trying to convert the Generic Inquiry - Customer Summary to a MySQL statement. It seems GI only display MS SQL syntax even though I’m using MySQL as the tenant DB. I have everything pretty much working but I’m seeing more customer rows using a MySQL statement than what GI is returning with Preview. Any suggestions would be appreciated.
Customer Summary - MySQL ScriptBasic
Best answer by JSpikowski
I was able to get ASP.NET to run under Linux (Ubuntu) using Apache. My tests so far have worked and are responsive. I'm doing this on my 🍊 Pi Zero portable Linux server. This server is base on an ARM CPU.
I'll start a new thread on this topic if I can get Acumatica to run.
I have found that using the REQUEST--> SQL View produces cleaner SQL statements that I can pretty much use as is.
The top level SQL list looks like they were done with generic inquiry.
I heard that 90% of Acumatica users rum on the Acumatica SaaS offering. If a SaaS user needed greater access to their data, can they elect to host their DB remotely?
I was able to get ASP.NET to run under Linux (Ubuntu) using Apache. My tests so far have worked and are responsive. I'm doing this on my 🍊 Pi Zero portable Linux server. This server is base on an ARM CPU.
I'll start a new thread on this topic if I can get Acumatica to run.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
