Blog

Here I document some issues for searching of which I spent more then 15 minutes

  • How to override action "Create " at form SO301000 or "Sales orders"

    Hello everybody,

    today I want to document one important piece of functionality in Acumatica. Sales order screen. This is very important screen and has many staff. One of the important screens in it is "Sales orders"  screen. From prospective of understanding Acumatica source code of method "Actions" has plenty of food for mind.

    Take a look at it's declaration:

    public PXAction<SOOrder> action;

    [PXUIField(DisplayName = "Actions", MapEnableRights = PXCacheRights.Select)]

    [PXButton]

    protected virtual IEnumerable Action(PXAdapter adapter,

    [PXInt]

    [PXIntList(new int[] { 1, 2, 3, 4, 5 }, new string[] { "Create Shipment", "Apply Assignment Rules",

                    … more

  • My thoughts after start of first Indiegogo campaign

    Here I want to describe how I felt before starting Indiegogo campaign during it's execution and few minutes after starting Indiegogo campaign.

    Initially I want to describe road map to this campaign. I was and still is a happy person whose main job is integration of different enterprise systems. I like such kind of activities because it helps to speed up life inside of company of any size. Imagine that with help of software inside of some small company ( 30 people ) can save around 5 minutes of time daily. Then in one month this company can save 22 * 5 * 30 = 3300 minutes or 55 working hours. It means faster delivery of product, or faster producing of product or faster salary receive or … more

  • AWS Product categories

    Hello everybody,

    today I want to document few main features of AWS. Below I want to mention AWS Product Categories:

    Compute services. Provide you with virtual machines

    Storage services. Raw block of content.

    Database services. Organized in some way data in organized chunks.

    Networking services. Provide with network assets.

    Messaging services. Communication between systems.

    Content delivery services - cached location for frequently accessed content. 

    Deployment and management - allows to pack, secure, monitor AWS apps.

    Next goes question, how developer can interact with AWS? As always in two ways: visual tools or through API.

    API in turn can be divided into two categories: SOAP/ … more

  • Acumatica DAC class generator

    Hello everyboydy,

    today I want to share with anybody mine implementation of DAC class generator.

    By default Acumatica provides you with DAC class generator which is pretty good.

    But time from the time I had a need to generate DAC class into text field, and then

    put it somewhere in my solution, and Acumatica DAC class generator didn't feet to

    mine needs. So I decided to create my own DAC class generator. 

    This form has simple interface. In the first line you enter Connection string, at second

    line you enter table name, press at generate, and receive DAC class.

    You can download source code here. 

    Below goes also some C# code which I've comment later:

        public  … more

  • How to add sitemap into your customization

    Hello everybody,

    today I want to describe some simple steps of how to add into your customizaiton sitemap. As you already know, sitemap of Acumatica is saved in database. And if you make customization of your sitemap you may need to add to your project.xml something like this:

    <Customization level="0" description="" product-version="5.30">

        <SiteMapNode>

            <data-set>

                <relations version="3" main-table="SiteMap" />

                <layout>

                    <table name="SiteMap" />

                </layout>

                <data>

                    <SiteMap>

    <row Position="72" Title="Warehouse"  Url="~/Frames/Default.aspx"  … more

  • How to make yourself as Administrator in Acumatica with SQL

    Hello everybody,

    today I want to share some piece of SQL code that can help you to add yourself to Administrators group in Acumatica:

    INSERT INTO [dbo].[UsersInRoles]

               ([CompanyID]

             ,[Username]

             ,[Rolename]

             ,[ApplicationName]

             ,[CompanyMask]

             ,[CreatedByID]

             ,[CreatedByScreenID]

             ,[CreatedDateTime]

             ,[LastModifiedByID]

             ,[LastModifiedByScreenID]

             ,[LastModifiedDateTime])

       VALUES

               (2

             ,'yourAccountName'

             ,'Administrator'

             ,'/'

             ,0xAA

             ,'B5344897-037E-4D58-B5C3-1BDFD0F47BF9'

             ,'00000000'

             ,'2010-07-27 17:25:00.000' … more

  • .Net core tag helpers

    Hello everybody,

    today I want to describe some .Net core tag helpers that you can use in order to create your web pages. There are plenty of already implemented tag helpers that can simplify your life as a developer.

    Here is the list of already made:

    Anchor

    Cache

    Distributed

    Environment

    Form

    FormAction

    Img

    Input

    Label

    Link

    Option

    Script

    Select

    TextArea

    ValidationMessage

    ValidationSummary

    It is not a complete list, but I suppose those 16 elements help you to grasp how wide it's functionality.

    Anchor Tag Helper

    Consider following declaration:

    <a asp-controller='Presenter' asp-action='Presentation' asp-route-id=@Model.PresenterID>Presenter ID: @Model.PresenterID</a> … more

  • How to validate input on Insert

    Hello everybody,

    today I want to document small feature in Acumatica which I can call validation of insert. 

    As usually if you need to validate some logic of insertion you can use something like RowXXXXd event. But for simple validations you can use PXUIVerify attribute. Below goes example take from Acumatica itself:

    [PXUIVerify(typeof (Where<LandedCostTran.curyLCAmount, NotEqual<decimal0>>), PXErrorLevel.Error, "The value must be greater than zero", new System.Type[] {}, CheckOnInserted = false)]

    What this command says to you is pretty obvious:

    Verify at ui level ( generate javascript verification code ) that value at LandedCostTran.CuryLCAmount is not equal to zero.  … more

  • Some Elastic search featues

    Hello everybody,

    For few days I've got assigned to work with Elastic search. As faithful to my principles before doing any activity I'd like to familiarize myself with instrument that I had to use. In ordre to use it more effectively.

    So, first of all I want to mention terminology. As a lot of developers I have expereince of working with databases, so I will use analogies from relational db world.

    First of all Kibana has indexes. It has nothing in common with indexes in relational db. Index in terms of relational db would be named database. 

    So each Kibana has one or more indexes ( databases ).

    Each index has one or more types. Types in terms of relational db would be named table.

    In … more

  • How to switch google developer platform to English

    Hello,

    recently I've went into google development platform and faced following issue: 

    all of it's user interface was in Russian. I prefer to see English interface because majority of manuals are written in English, not in Russian. How to switch that language to English? Very simply. Just add to page following line: &hl=en

    For example like this:

    and you'll all set. You'll see everything in english more

General information

Greetings to everybody stopping at my blog. Purpose of this web site is to be google of my brain. Everything I found useful, or of possible beneficial for usage in future I've save here at this blog

Contact information

If you want to contact me more on any subject printed at this web stie, you can email me: zaletskiy(at)gmail.com

Job information

If to speak in general, I'm developer. For now I work as team lead in company GlobalLogic.