Archives / 2015 / April
  • How to get top 1 record from db in Acumatica

    Hello everybody,

    today I want to share with you one trick that sometime can be useful. Imagine, that you constructed some BQL query and want to get only one record from db with ommiting others or in other words if you need TOP 1. For this purpose you can use SelectSingle method that generates SQL statement with TOP 1 records to return and executes faster. more

  • Unit test abbreviations

    Hello everybody,

    some abbreaviations:

    SUT - system under test. AKA as AUT, MUT, CUT.

    DUT - device under test

    DOC - depend on component more

  • What makes a good Unit test

    Hello everybody,

    today some notices of what is considered to be a good unit test.

    1. Tests should be independent and isolated.  

    For example if you have functions a, b, c tested, then sequence of test shouldn't affect the result. 

    2. Each test should test single behaviour or logical staff. 

    If to speak about phone example, calling and sending sms shouldn't be in one functoin

    3. Clear purpose understood.

    4. Don't test the compiler ( like writing/reading to db )

    5. Reliable and repetable ( give the same result ).

    6. Quality the same as other parts of solution.

    7. Valuable for developers more

  • What are Asserts in NUnit

    Hello everybody,

    just short notice of NUnit function Assert.That


    public void CheckAddition()


    Assert.That(CalculatorClass.Minus (5, 2), Is.EqualTo(3));


    public void CheckAddition()


    //old styel Assert.AreEqual(3, CalculatorClass.Minus (5, 2));



  • Email control in Acumatica

    Hello everybody,

    just short glimpse of how to make mail control in Acumatica. It's very simple task. Make dac class with string and bind it to page in the following way:

    <px:PXMailEdit ID="edUsrPersonalMail" runat="server" DataField="UsrPersonalMail" CommitChanges="True" ></px:PXMailEdit>

    That's it, you'll get email control more

  • Encog propogation training algorithms

    Hello everybody,

    today I want to describe in simple words some training algos of Encog.

    Before I'll continue, I want to show general block schema of training algorithms:

    Init NN can look like this:

    public BasicNetwork CreateNetwork()


    var network = new BasicNetwork();

    network.AddLayer(new BasicLayer(WindowSize));

    network.AddLayer(new BasicLayer(10));

    network.AddLayer(new BasicLayer(1));



    return network;


    Steps "NN error < acceptable error" -> "Update weights according to learning algorithim" can look like this:

    public void Train(BasicNetwork network, IMLDataSet training)


    ITrain train = … more

  • Transfer to new Acumatica version


    today I had task of switching to new version of Acumatica. From 4.2 to 5.1. 

    The first surprise which I faced was lack of .Net framework 4.5.1. This shocked me especially from viewpoint that I had Visual Studio 2012 installed with service pack 4. Then I found that I need "Microsoft .NET Framework 4.5.1 Developer Pack for Windows Vista SP2, Windows 7 SP1, Windows 8, Windows 8.1, Windows Server 2008 SP2 Windows Server 2008 R2 SP1, Windows Server 2012 and Windows Server 2012 R2" . more

  • T200 Acumatica certificate

    Hello everybody,

    I want to boast that I finally received T200 Acumatica certificate!!!!!! And now I can proudly say that I'm certified Acumatica developer,

    which gained





    T900 certificates.


  • How to get tstamp in Acumatica

    Hello everybody,

    today I want to shre small note of how to generate timestamp for Acumatica objects ( in case if you use for some reason PXDataBase.Insert or  PXDataBase.Update)

    PXDataBase has public method SelectTimeStamp.

    public static byte[] SelectTimeStamp()


    return Provider.SelectTimeStamp();


    So, in case if you need to put in variable t TimeStamp you can do the following:

    var t = PXDatabase.SelectTimeStamp();

    And variable t will have timestamp more

  • Indiegogo

    I want to start campaign for making machine for my neural networks investigations. 

    Here is the link if you want to participate more