Hello everybody,
Today I want to share with you another area. I had small order for MQL4 indicator for round numbers for Metatrader4 or as it is named MT4. The task was to draw lines at screen with some step at any currency pair. In order to implement it I started first of all Googling. Then I fo...
Few days ago I faced following challenge. SQL profiler gave me ugly SQL, which was unreadable for my eyes.
For example like this:
exec sp_executesql N'SELECT APAddress.AddressID, APAddress.VendorID, APAddress.VendorAddressID, APAddress.IsDefaultAddress, APAddress.RevisionID, APAddress.AddressLine...
Hello.
Today I want to share some information about Acumatica customization.
Suppose, you want to change your pages not via Acumatica UI, but via Visual Studio. Reasons why you can have such desire can be the following:
1. Visual Studio is faster then Acumatica UI
2. You can put your changes unde...
Today I needed to get all columns of specifict table.
SQL which you can use for this purpose is the following:
SELECT COLUMN_NAME 'All_Columns' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='Specific table'
Ready to take your Acumatica experience to the next level? Just like uncovering a...
Hello everybody.
Today I want in short share screen numering in Acumatica.
Let's say we have screen number like this: xx.yy.zz.tt
in that case
yy is screen sequential number
zz is screen type: 10 - setup, 20 - Maintenance, 30 - data entry, 40 - inquiry, 50 - processing, 60 - reports.
tt is sub sc...
Hello readers of mine blog.
Today I want to share with everybody who wants to make unit test of Acumatica how I achieved it.
For unit testing I use NUnit. In order to start my work with Acumatica Unit testing I wrote the following class:
[TestFixture]
public class CATranEntryExtTest
{...
In one of my previous posts I described how to add autonumbering to acumatica. Described method will work pretty well, if you don't have any pop-ups which also need to have autonumbering. In case if you have such pop-ups, then it is different story.
My next assignment on the job was to add a...
Hello,
this post is dedicated to understanding how security in Acumatica works. If to be precisive security of accounts.
Let's say you need in some way filter accounts for some user according to configuration at row level security screen ( GL104000 ).
In my case I had following records...
Today I want to share how to copy Entty Types items in acumaticca from one instance into another instance.
The first step was to create import export settings in both instances of acumatica as described in acumatica manual similar to this screenshot:
The second step was to create project, which...
Today I want to share with you how I implemented autonumbering feature in acumatica for page CA304000.
My task originally was the following: add autonumbering feature to the "Document Ref" field with following rules:
a. step of incrementing is 1
b. length of field should be six char...