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...
Hello everybody,
today I want to write about new additions for SQL Server T-SQL language, which are there starting from 2016. It is create or alter syntax.
In the past, if you've made some custom SQL view, it was needed to have constructions like this ( pseudo code ):
if view ( stored procedure,...
Hello everybody,
today I want to share interesting use case which raised recently when dealt with syncrhonization of records between Magento and Acumatica.
I had following declaration:
#region LastModifiedDateTime
[PXDBDateAndTime()]
[PXUIField(DisplayName = "Last Modified&nbs...
Hello everybody,
I want to leave a short note on how to use SelectFrom for legacy code, and pass it in View.Select for Acumatica newer versions.
var cmd = new SelectFrom<PartsCatalog>.
InnerJoin<INSiteStatus>.On<Use<PartsCatalog....
Hello everybody,
as it was mentioned in one of my previous blog posts, regarding overriding base actions of Acumatica graphs, family of graph extensions grows and grows.
Today I want to share one more code snippet which you can use for extending modification of Acumatica actions...
Hello everybody,
today I want to leave a short post on how to override Shop rates Action in Acumatica.
I mean this button:
Below goes C# code, with which you can achieve it:
public class SOOrderEntryExt : PXGraphExtension<SOOrderEntry.CarrierRates, SOOrderEntry&...
Hello everybody,
today I want to write a few words about interesting behavior of PXLongOperation.StartOperation in Acumatica.
On the glance that looks pretty simple and straightforward. You have something processing of which will take a long time? Use PXLongOperation.StartOperation. So imagi...
Hello everybody,
today I want to share with you a piece of code, with help of which you can get list of all activer order types in Acumatica and also you'll get a chance to select those types with checkbox. Take a look on a screenshot below:
how to achieve this?
Code below without description of...
Hello everybody,
sometime it is needed to insert some binary information in one or another table inside of Acumatica. Quite often developers just modify existing record in table UploadFile or UploadFileRevision.
But I don't like such approach, as it is prone to errors and potentially can harm som...
Hello everybody,
today I want to leave one more note, which you can use for boosting your productivity.
Imagine following scenario. On the meeting with customer you've got some list of to do points. You have them on your email. You've made some research, and found that you need to make changes to...