Debug Acumatica Code

Hi All, Today I want share with you one great way to make you development on Acumatica Platform better and faster – debug Acumatica source code. This can give you unlimited ability to: Investigate existing logic Planing and develop customization Understanding what code can be reused Analyzing issues Do performance tests Important Note: This approach works only on latest version of Acumatica ERP 5.3 Update 5 (Version number 5.30.1583) Welcome into the article, if you interesting in details. Installation First of all you need to install Acumatica with debugger tools: In general, these debugger tools are just additional PDB files that will be copied to bin folder of Acumatica web… Read more

Running Automaton Button from code

Hi All, Here I want to share one example of customization. We want to trigger a button that is defined as Automation action from code. The problem here is that the button is not defined in the code, so we need to trigger it the same way how UI does it. To do this we have do several tricks: Define a new custom PXView that will return record that we want to process Create an adapter, that will provide data for button handler. Adapter will get data from custom PXview. Create a separate instance of graph, that will handle action. Code example with comments: View the code on Gist. Big… Read more

Clearing lost files and old revisions

Hi All, When you use any database for long time, it become big, heavy and full of different garbage and test data. And Acumatica is not exception here. So every time when you want to back up it and restore on different server for testing/investigation, you have to wait for long time. In this article I want to share with you one script that can help you free some extra space in your database. This will minimize database size, backups size and backup/restoration speed. To free some space we want to clear some unused, extra or unnecessary files in the database. This script will: Delete all files what is not… Read more

Embed Excel Online File to Acumatica User Interface

Hi All Have you ever use Google docs or Office 365? It is new way of working, when all your documents are somewhere in the cloud. Many employees can view and edit documents simultaneously. Today I want to share with you one trick how you can include Excel file  (and other office documents as well) right to Acumatica user interface. If you interesting in this, welcome in this article. Configurations Steps: First of all you need to create excel file. I will use InvoicedItems,xlsx file that is attached to InvoicedItems generic inquiry page in Sales Demo data. Login to your Office 365 aтв open One Drive Upload your excel file to one… Read more

AP Bills Import Performance Measurement

Hi All, Want to share with you some good news. Acumatica constantly improve quality and functionality, but we also spend a lot of time on performance optimization. And we 5.3 update 3 we get to new height. 5.3 version gets 25% faster in importing of Accounts Payble bills and now Acumatica can import, validate and save 2 Bills per second per CPU Core. So with adding more cores this chart will grow nearly linearly. But here we have one limitation. Due to performance optimizations, functionality for automatically loading payment documents to bill was disabled. As a side effect this will make Auto-Apply button non-functional when importing bills. Have a nice… Read more

Extend/Change Field Size

Hi Everyone, Today I want to show you how easy to change the size of control in Acumatica. Let assume that we have some field with big value. It is not very convenient for us to scroll value every time, so we want to change it. Let do it with several simple steps. But here we need to include customization. Create a new customization project using customization menu. Inspect element using customization menu. >On the popup window use customization button. In the customization browser find required field and specify size. In my case size should be bigger, so I set “SM” value. Save changes and publish customization project. Check and… Read more

Recommendations for Application Server Memory

Hi All, Some times ago we had these recommendations for hardware resources: Small – 2 Cores, 4 GB Ram Medium – 4 Cores, 8 GB Ram Large – 8 Cores, 16 GB Ram These numbers was mapped to Amazon EC2, C3 Instance type. But after latest performance investigation we have found that 4 GB is too small for normal run of Acumatica. 8 gigabytes should be minimum requirements for any Acumatica deployment. So I recommend you increase server memory if you have less than 8 GB. This is important especially for small instances and Amazon deployments. New recommendations are: Small – 2 Cores, 8 GB Ram Medium – 4 Cores,… Read more