Optimizing Large Import

Hi All Want to share with you some good approaches to Import a large amount of data. If you ever tried to import some large set of data from Excel you actually know that it is not as fast as importing data into the SQL table. There are plenty of reasons why it is like this: Data validation Defaulting empty field Running of business logic Data integrity Updating of referenced data Security tracking Audit Of course all these rules have different effects in different modules. It is obvious that GL is much faster than SO Orders. At the same time, AR is faster than SO, but slower than GL. Also… Read more

Acumatica and Microsoft Flow

Hi Everyone, Recently Microsoft has added a new tool to their Office 365- Microsoft Flow With help of my college – Tim Rodman, we have done some investigations on how it can be used with Acumatica. I think that in modern internet of services and things services like Microsoft Flow, Azuqua and Zappier might be very useful. Microsoft flow is most modern here so it does not looks like very mature and stable now. But i belive it is quite promising as Microsoft has enough resources to integrate it with most of Office 365 services. Looking forward to see that progress. However even now it has some nice things, like… Read more

Enabling Upload from Excel for the Grid

Hi All, Today I want to share with you a way how to enable upload form excel for custom grid. Actually this is quite simple – Step 1 – define PXImportAttribute on data the data view under the grid. public class CSCalendarMaint : PXGraph<CSCalendarMaint, CSCalendar> { …        [PXImport]        public PXSelect<CSCalendarExceptions> CSCalendarExceptions; … } Step 2 – enable appropriate Grid Mode (Allow Upload) on the grid properties. This will enable upload button on the grid action bar with standard functionality. In some cases, you may want to have more control on the import process. In this case you also may implement optional interface: IPXPrepareItems. This interface should be implemented on… Read more

Using Colors in Acumatica

Hi All, Today I want to share with one way how you can highlight some Acumatica rows or data with colors or other text styles. Disclaimer: Please note that this way does not follows the standard customization way, so any changes may be not supported in future versions of Acumatica. Also it might be very complex to support this customization during Acumatica upgrades. Before we can change colors, first of all we need to do understand how Acumatica applies styles. Acumatica uses Cascade Style Sheets (CSS). All elements (Forms, Grids, Row, Fields, Buttons, …) are associated with one or many styles. All styles are defined in Acumatica folder itself You… Read more

Custom Formula for ACH/GIRO Providers

Hi All, In the previous article about custom payment providers i have mentioned that Schema file supports several build-in formulas, like: Count – Count of details or nested groups in group TotalCount –  Total lines in all nested groups BlockCount – Count of internal blocks including adjustments for fixed structure CountOneBased –  CountField  + 1. Required if you need calculate header or footer with details TotalCountOneBased – TotalCountField +1. Required if you need calculate header or footer with details You also can add more formulas there. For example if you want to have Count that will calculate header and footer together with details you may need TotalCountTwoBased formula. Please check this code… Read more

Client Events using JavaScript

Hi All, Today I want to share with you one way how you can add some client validations/calculation using JavaScript right in the browser with no accessing server data. In general i would suggest you to not do any complex calculations on client side and always use server for all data manipulations. However in some specific situations this approach may save a lot of processing time because client events may do calculations right in the browser. Also note that client logic will be available only for browser users and will not be triggered from web services API and Mobile application. The scenario that i want to do is quite simple… Read more