Monday, 25 April 2016

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.
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.

Tuesday, 19 April 2016

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:

Big thanks to Acumatica support team for the provided example.
Have a nice development.

Monday, 11 April 2016

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.

Clearing lost files and old revisions in Acumatica
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:
  1. Delete all files what is not assigned to any entity. You may know that files in Acumatica does not have separate access rights. Rights to files should be evaluated by linked entity. If there is not linked entity this file is unassigned and not visible for everyone. So we need to delete this file to save database space.
  2. Delete all reversions except last one. This may help you save database size, but you will lose all history of the files
  3. Delete all files records without revisions. Sometimes you have file with no data - this is garbage that should be deleted.
This script should be applied only on test/extra environment. Do not do it for production database, you may loose some important information.
Do and validate backup before clearing data.
Think and check everything twice.

If you still want to clear files and you need a script, lets go inside this article.

Friday, 8 April 2016

Call Acumatica SupportMan!

Hi All!

If you have problem or question, just call Acumatica Support.
Support is not only for issues, do not hesitate to ask Questions!

Acumatica SupportMan

Good Luck!

Thursday, 7 April 2016

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.
Acumatica Excel Embeded

If you interesting in this, welcome in this article.

Tuesday, 5 April 2016

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.
Acumatica 5.3
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 import!

Monday, 4 April 2016

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.
Acumatica Sales Order Number Width

Let do it with several simple steps. But here we need to include customization.

Friday, 1 April 2016

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.
Amazon C3 Instance Specifications
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, 12 GB Ram 
  • Large - 8 Cores, 24 GB Ram
Also plan your test instances in advance as well. If you want to have some test demo copies of Acumatica on production server, you need to make sure that there is enough memory for production and test instance.
It is good practice to put test instance in separate application pool and limit available memory on it.

Have a nice deployment.