Archives / 2020 / March
  • How to unit test SOOrderEntry extension in Acumatica

    Hello everybody,

    today I want to show to unit test, and I mean really unit test SOOrderEntry graph extnesion in Acumatica with XUnit.

    In order to achieve it, you'll need following steps:

    Create .Net Class library

    Reference xUnit

    Create public class that inherits from TestBase class

    Add override ResisterServices 

    Create something like PrepareGraph with usage of TestBase.Setup class

    Write your mehtods.

    I will not describe how steps 1 - 4 may look, as it is pretty obvious, but step 5 and 6 at C# level may look like this:

    public class SOOrderEntrySDExtTests : TestBase


        protected IPXCurrencyService CurrencyService;

        protected IFinPeriodRepository FinPeriodService; … more

  • How to catch all MySQL queries generated by Acumatica

    Hello everybody,

    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 queries, you may need some proxy service, which will intercept queries. You can use MySQL proxy, but instead of MySQL proxy I suggest to use Neor Profile SQL as it has much more convenient UI:

    In order to achieve such catching of all My SQL queries, you'll need following steps:

    Install Neor Profile SQL.

    In your Acumatica web.config make following change:

      < … more

  • How to point MySQL to another port then 3306

    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.SqlClient" connectionString="Server=localhost;Port=4040;Database=PXProjectionMySql2;Uid

    you can use this knowledge for having multiple MySQL instances on the same machine and for catching generated SQL queries. more

  • How to install MySQL proxy

    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 need to use MySQL proxy.

    So, first step will be download MySQL proxy archive and unzip it to some folder on your drive. 

    Then in command prompt ( not in powershell ) execute something like this:

    sc create "Proxy" DisplayName="MySQL Proxy" start="auto" binPath="d:\Install\mysql-proxy-0.8.5-windows-x86-32bit\bin\mysql-proxy-svc.exe"

    And then this:

    net start proxy

    Those two commands will allow … more

  • How to use FBQL in PXProjection

    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:



    public class SalesOrderLines



    Nothing fancy, but during initial coding error messages were a bit confusing


  • How to use PXDBScalar with PXProjection

    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:



    LeftJoin<FABookHistory, On<FABookHistory.assetID, Equal<FABookBalance.assetID>,

    And<FABookHistory.bookID, Equal<FABookBalance.bookID>,

    And<FABookHistory.finPeriodID, Equal<IsNull<FABookBalance.currDeprPeriod, FABookBalance.lastPeriod>>>>>,

    InnerJoin<FABook, On<FABook.bookID, Equal<FABookBalance.bookID>>>>>), new Type[] { typeof(FABookBalance) })]

    [PXCacheName(Messages. … more

  • how to make redirects in Acumatica and popup warning

    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, redirections are implemented as exception. Let consider next simple code, by which you can implement it:

    In your page (in our example this is SO301000) a button will appear:

    If user will click to this button, then he'll immediately receive requested data right in main window:

    This approach has the disadvantage - the user will lose all unsaved data. So let's change our code to warn the user about it:

      Now, after the user clicks on the "Learn More" button, a popup window … more