Archives

Archives / 2015 / February
  • Merged and read-only modes in Acumatica

    Hello everybody,

    today another notice. Acumatica can provide values in two modes: merged and read-only.

    So, what is merged? Imagine that user worked about the form, and made some changes at grid. Will changes apper in DB? Untill will be executed Persist, not. Data will be only in cache. Some time it is useful to compare data in cache with data in db. In order to get merged data you can use PXSelectReadOnly type or PXSelectGroupBy. For merged results you can use PXSelect or PXSelectJoin. more

  • Redirection types in Acumatica

    Hello everybody,

    today I want to notice what kind of redirections are available in Acumatica:

    PXRedirectRequiredException opens the specified application page in the same window or a new one. By default, the user is redirected in the same window.

    PXPopupRedirectException opens the specified application page in a pop-up window.

    PXReportRequiredException opens the specified report in the same window or a new one. By default, the report opens in the same window.

    PXRedirectWithReportException opens two pages: the specified report in a new window, and the specified application page in the same window.

    PXRedirectToUrlExceptionopens the webpage with the specified external URL in a new … more

  • Order of views in Graph in Acumatica

    Hello everybody,

    note of today is value of orders. In the word of C# if you work with your class, you as usually don't care what you declare in your code. But in Acumatica graph order of data viewes is important, because they define order of saving data to the database. If you think that surprises are completed then here it is another one: order of viewes doesn't define order of data viewes execution. And the third one, view that is binded to PrimaryView should be defined first in the graph.  more

  • Enabling Reusable Grid Filters

    Hello everybody,

    today I want to note reusable grid filters. Acumatica has interesting dialog window, wich is named Filter Settings in which user can define and save custom fitlers and then use them every time this user opens the page. They are recommended for usage at inquiry and processing pages, so users can customize these pages to show specific data that is most relevant to their needes and responsibilities. If you wonder how to convert ordinary view to filterable view here is the way: PXFilterable attribute.

    [PXFilterable]

    public PXSelectReadonly<AnticipatedPayrollDetail> AnticipatedPayrollDetails;

    I applied it to my page, and here is example of what I got:

    So, in case if … more

  • Order columns in Grid in Acumatica

    Hello everybody,

    Today I want to share with you interesting trick of how to order data in grid by default. The simplest way is to organize IsKey = true value. If you do this, then Acumatica will add Order by clause for each key field of the DAC. more

  • Restore original condition of Acumatica

    I want to note how to restore original condition of Acumatica if Unpublish project failed:

    1. Restore the content of the App_Data\RollbackFilesfolder to the root folder of the website.

    2. Clear the content of the CstPublishedfolder.

    3. Delete the files placed in the Cachessubfolder of the App_Codewebsite folder.

    4. Remove all external files deployed on the website more

  • Acumatica can have two views with main DAC

    Hello everybody,

    today I want to share option, which was shocking for me. I discovered that graph can have more then one dataview for the same main DAC. Here is sample of code form T200 manual:

    public PXSelect<Product> Products;

    public PXSelect<Product, 

    Where<Product.productID, Equal<Current<Product.productID>>>>

    ProductDetails;

    Here also continaution of the manual why on Earth you can need this:

    These two data views can only be used as data members for UI containers that display the same data record at a time. In such definition of data views, the first one is used to display brief information of a product on a form, and the second one is used to display the detail information of … more