Loading ...

How to turn find out duration of SQL Query execution time

Hi everybody, Want to share two important commands for MS SQL: SET STATISTICS IO ON SET STATISTICS TIME ON After you turn it on, you may see following in the output window: with this ouptut window you may see how long it took actually to execute some query, and if added indexes improved or didn'...

Find the custom fields in Acumatica using ScreenUtils class

We'll guide you on how to show all custom fields on a screen, even if they are not associated with your package. You can use the PX.Api.ScreenUtils class to locate any field. This class contains a method called GetScreenInfo() that returns a Content. Inside the Content object, there's a field nam...

Localized reports in Acumatica

One of the recent additions to the new Acumatica 24R1 version is the ability to retrieve localized reports through REST API. This article provides a manual how specifically one can achieve it.   We start of creating an endpoint for reports. For this we navigate to the Web Service Endpoints (...

OData Version 4.0 Changes in Acumatica 24R1

Hello everybody, Today, I want to share with you a few differences between the previous version of OData and the new version, ODataV4. But before we dive in, let's set up our Postman environment to test it together. The first step is to create environment variables in Postman. After creating the...

How to setup goDaddy in Acumatica

Today I want to tell you how to set up OutLook GoDaddy mail.First of all, log in to Microsoft Azure using link below.https://portal.azure.com/Then click App Registration →New registration Print application's name, select Web app and click "Register" button.    Then in your appliation go...

How to send email in Acumatica

Hi, today want to share quick code snippet on how to send email from Acumatica. For this purpose, good usage is for NotificationGenerator. See the code below: public virtual void SendEmailNotification(string email, string subject, string emailBody) {  ...

Screen templates in Acumatica

Let's take a look at the screen’s templates. There are 6 of them in Acumatica: Form, Grid, Tab, FormTab, FormGrid, TabGrid. Each template is designed to be used for different purposes. Let's look at each of them: Form A Form template is used to display and edit a single record or entity at a t...