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...
Hello everybody,
today I want to leave short note on issue with CROpportunity DAC class.
For quite a few times I've noticed that someone adds field to CROpportunity, but later notices that field is lost either on moment of loading from database, or lost during persisting record to data...
Hello everybody,
as you probably noticed, I didn't have many blog posts recently during months of November and December. Reason for such idling from my side was issues with hosting provider. For some weird reason hosting provided behaved not very decently, and for me it become necessary
to...