finally I found out how to catch all queries to MySQL server, generated by Acumatica. Well, in context of My SQL as usually people work more with MYOB, but under the hood MYOB is Acumatica.
Typical schema of Acumatica <-> MySQL connection looks like this:
In order to get generated MySQL qu...
Hello everybody,
today I want to describe how to point to non standard port in My SQL for Acumatica.
Below goes fragment from my Web.config
<remove name="ProjectX" />
<add name="ProjectX" providerName="System.Data.SqlCli...
Hello everybody,
quick post on how to install MySQL proxy. You may be puzzled why it is needed? Because MySQL proxy allows you to track all generated SQL by MySQL. As of now, you can catch generated SQL for SQL server with SQL Server Request Profiler. But in order to achieve it for MySQL, you'll...
Hello everybody,
Recnetly I had a need to create PXProjection and wanted to use in declaration of it not SelectJoin, but FBQL SelectFrom with combination of InnerJoin. Finally I've got something like this:
[PXProjection(typeof(SelectFrom<SOOrder>.InnerJoin<SOLine>.On<SOOrder.orderT...
Hello everybody,
today I want to write a few words about how to use PXDBscalar in connection with PXProjection and is it possible at all.
First of all want to say that it's defientely a possiblity. Take a look on this sample of implementation:
[Serializable]
[PXProjection(typeof(Select2<FABoo...
Hello everybody,
today I want to write a newer post about how to give an opportunity to user go to some link from Acumatica. As I've mentioned in https://blog.zaletskyy.com/types-of-redirects-in-acumatica, redirections are implemented as exception. Let consider next simple code, by which you can...
Hello everybody,
today I want to share idea on how to get getting Combo-box values set for REST API.
As usually values of comboboxes values are just hardcoded in web api calls, but sometimes it may be necessary to load them from Rest API, for example for cases if you want to target multiplve...
Hello everybody,
today I want to write a few words about method CreatePaymentProc in graph SOOrderEntry.
Among different features of this method, want to describe that it have for some reason out parameter! Take a look on it's declaration:
public virtual void CreatePaymentProc(SOOr...
Hello everybody,
today I want to leave a short note about Acumatica Architecture. Take a look on this picture:
As you can see from the schema business logic controllers is kind of single source of truth. Acumatica doesn't have dependencies between UI and Web services. Also it means, if you hide...
As a seasoned Acumatica developer with over 11 years of hands-on experience, I've seen how performance improvements in your ERP system can make a significant difference. One effective strategy I've come across is implementing RAID 10 (Redundant Array of Independent Disks) for Acumatica’s infrastr...