Archives / 2020 / February
  • When to use PXConnectionScope, and when to avoid it

    Hello everybody,

    today I want to leave a very short note-reminder. Mainly for myself, but maybe someone else may benefit from it also. 

    In Acumatica there is wonderful scope: PXConnectionScope. It is needed for the following situation: if you need to raw data from database eliminating cache. For this purposes is also fine PXSelectReadOnly, but if you want to open a new connection, and read from db raw data, then it's better to read them through PXConnectionScope. 

    Also want to mention few rakes, which stolen from me enormous amount of time.

    If you want to read some data during RowSelecting or FieldSelecting, potentially it may be a good idea to use PXConnectionScope

    If you want to … more

  • Getting Combo-box values set for REST API

    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 versions of Acumatica. For such a purpose I'd suggest to create Graph, which via reflection will read values from dlls. Quite similar to what Acumatica team does. 

    Below goes source code of graph, which via reflection loads data:

    using PX.Data;

    using System;

    using System.Collections;

    using System.Reflection;

    namespace LA


        public class ListAttributesInq : PXGraph<ListAttributesInq>

         … more

  • Create payment proc

    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(SOOrder order, out PXGraph target, string paymentType = ARPaymentType.Payment)


    as you see, it accepts as a parameter PXGraph. Inside of open part of Acumatica source code there is only one more file, which has similar staff: ServiceOrderCore. Take a look on it:

    public static void CreatePrepayment(FSServiceOrder fsServiceOrderRow, FSAppointment fsAppointmentRow, out PXGraph target, string paymentType =  … more

  • Acumatica Application Architecuture

    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 something from UI on the page, it will be also hidden from Mobile app.

    But want to say about few exceptions as well.

    Suppose following scenario. You make a graph, and you know for sure, that from UI standpoint, it's logicall to load some visualization data, but from API call there is no reason to call some piece of code. How to inform Acumatica about it?

    For this purpose you can use … more

  • Acumatica summit 2020

    Hello everybody,

    today I want to write a few words or kind of summary of Acumatica summit 2020. 

    First of all want to say that for me it was very interesting to see people which have big or even huge desire to make Acumatica grow. 

    And also want to post some photos. 


    When I thought about Hackathon, I didn't thought that I'll be part of a winning team. I thought that I will have some fun. Make some customization for Acumatica, congratulate the winner and will go home. But to my surprise, here is what I've got:

    well, not only myself, but other teammates with me in team Theta. Harsha, Dhiren, Yuriy and Spencer. Guys, it was a huge pleasure to play with you on the one team! … more

  • How to display Green image status

    Hello everybody,

    I want to leave a short note regarding showing successful validation of some operation. Background is the following. Imagine, that you need somehow validate value entered in some checkbox. And in case if validation is successful, you'd like to show green sign near your text entry. I mean something like this:

    How to achieve it?

    1. Create field in DAC or DAC extension similar to shown below:

    public abstract class creditGreenStatus : BqlBool.Field<creditGreenStatus> { }

    [PXUIField(DisplayName = "", Visible = false)]


    [PXDefault(false, PersistingCheck = PXPersistingCheck.Nothing)]

    public bool? CreditGreenStatus { get; set; }

    2. Create markup on the page like … more