Hello everybody,
today I want to share with you few words about debugging of Acumatica. There are plenty of wonderful posts for doing this with help of already provided PDB files of existing graphs and first of all I definetely recommend to use them.
But there are scenarios when default pdb provi...
Hello everybody,
today I want to leave a post about the following case: you need to index rows in your database by some unique value, which can be null. And you don't want index to include those values which are null.
How to achieve it? Following T-SQL can do this:
CREATE UNIQUE INDEX idx_s...
Hello everybody,
today I want to leave a notice with proposal on how to program reaction on clicking of Abort button in processing screen.
Recently it become needed for me to program some functionality to happen after user clicks on button Abort of processing screen.
In my case I needed so...
Hello everybody,
today I want to leave a short post on how to create some custom view in Acumatica Customization if that view doesn't exist:
if not exists (select * from sysobjects where name='CustomerSelector' and xtype='V')
begin
exec (
&nb...
Hello everybody,
here I want to leave a short notice on how to avoid hearing yourself if you are connected over TeamViewer to somebodies computer. By defualt TeamViewer duplicates sound that goes through sound system of computer to which you've connected.
Not many people know, that such functiona...
Hello everybody,
today I want to leave short note on how to override and call CreatePaymentProc method of Acumatica which I discovered today with Naveen from Kensium.
My favorite way of overriding methods in Acuamtica with usage of Action and passing there parameters doesn't work. That is because...
Hello everybody,
today I want to leave another portion of SQL Server optimization for Acumatica database. In case if your db become huge, and you want to make it smaller, you can try following SQL code:
DECLARE @Table NVARCHAR(128)
DECLARE @Database NVARCHAR(128)
D...
Certainly! Below is an example of how you can override the ExecuteSelect method in a custom graph in Acumatica using C#. This example demonstrates how to customize the data retrieval process in a graph by overriding the ExecuteSelect method.
Example: Overriding ExecuteSelect in Acumatica Graph
.b...
Hey there! So, as a software developer who's spent most of my time writing code and debugging issues, I recently stumbled upon some terms while exploring Acumatica that left me scratching my head: Min Markup, Markup, and MSRP. These terms popped up while I was trying to configure pricing for a cl...