Hello everybody,
today I want to document one useful sql query that can be beneficial for cases if you need to dig in Acumatica tables, and need quickly to find type of some particular column.
Here it is:
select * from information_schema.columns where table_name = 'SOLine' and COLUMN_NAME...
Hello everybody,
today I want to make another description of how to cover with Unit Tests Graphs in Acumatica.
First of all I want to say that Acumatica controllers or as Acumatica names them graphs do not have any way to inject any dependency from interface. In such case it can be useful i...
Hello everybody,
today I want to describe with some screenshots kind of controls that you can get from Acumatica developer like me or any other Acumatica programmer.
Main purpose of this blog post is the following. Imagine, that you want to write super detailed instructions for Acumatica develope...
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 "...
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, an...
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]
...
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 t...
Hello everybody,
today I want to present one more example of selectors, but the one, that has multiple fields in it.
Consider following code:
using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using...
Hello everybody,
recently I was asked by one friends of mine, how pageSource in Acumatica works, i.e. how to code/decode pagesource contents.
After different methods of trial and error I've created following C# code in order to code/decode pageSource:
Snippet
private static string...
Hello everybody,
today I want to write a few words on how to add links to some entites in Acumatica.
So, recently I've had an assignment to add redirect into existing grid, so intead of showing some text show nice link which will lead to Purchase order.
Here is what I've done in order to achieve...