Archives

Archives / 2018 / December
  • Filters in Acumatica

    Hello everybody,

    in this article I want to describe how filtering in Acumatica work. When I say filtering, I mean following UI part:

    In manuals T100 - T300 there is almost nothing about how filters work, so I want to share few bits of development information.

    Storage

    All information about filters is stored in database in tables FilterRow and FilterHeader.

    Take a look on screenshot of FilterInformation for some custom applied filter:

     

    As you can see from screenshot Acumatica stores information about filters by FilterID, and has information like Condition, values, Close brackets, operators and so on.

    Also there are DAC classes FilterRow and FilterHeader, but you can find them only … more

  • Predefined Size Values in Acumatica

    Hello everybody,

    today I want to leave a post on Predefined size values for ColumnWidht, LabelsWidth, ControlSize properties of the PXLayoutRule component and LablesWidth and Size properties of a control:

    Value

    ColumnWidth in Pixels

    LabelsWidth and ControlSize of a Layout Rule; LabelsWidth and Size Properties of a Control in Pixels

    XXS

    100px

    40px

    XS

    150px

    70px

    S

    200px

    100px

    SM

    -

    150px

    M

    250px

    200px

    XM

    300px

    250px

    L

    350px

    300px

    XL

    400px

    350px

    XXL

    450px

    400px

    As you can see from presented table XL is not always the same XL, and it depends from the context more

  • How to have few Acumatica versions on single machine

    Hello everybody,

    today I want to leave a short comment about how to make few Acumatica instances of single developer machine. 

    As you already know or maybe know, Acumatica recommends to have one version of Acumatica. But what if you want more? Is Acumatica merciful enough to allow you this? The answer on this question is strong yes! 

    All that you need to do, is to install version that you need, and then preserver following folders in safe place:

    Data

    Database

    Files

    Portal

    And then you can uninstall them and install another version. 

    Then for installing specific instance of Acumatica you'll need to run AcumaticaConfig.exe file and you'll be ready to go.  more