Thursday, 26 May 2016

Reusing of Browser Features in your ERP

Hi All,

Acumatica is true cloud based ERP and works in the browser as fish in the water.
This give us some good ways to reuse browser features for our own benefits.

For example:

  1. Online translations with Google Translate - 
    browser features in Acumatica
  2. Online spell checker together with browser - 
    browser features in Acumatica
  3. Easy browser search thought data and reports - 
    browser features in Acumatica
  4. Multiple tabs - 
    Multiple tabs  Acumatica
  5. Zoom-In and Zoom-Out - 
    zoom in zoom out Acumatica
  6. Embedded online tools like Excel, YouTube or Maps - 
    online tools Acumatica
  7. Single Sing On - 
    sing on acumatica

And this is not the end on list and web technologies! You can have much more!
browser feautures Acumatica

Have a nice work!

Monday, 23 May 2016

ScalarCount BQL Operator

Hi All,

Today want to share with you one example of how you can extend Acumatica BQL operators.
As an example I will take a sub-select that will calculate count of linked entities.
Acumatica BQL operators

Lets assume that we have a list of customers. Each of ours customers has some contracts. All contracts can be for different types of services.
And we want to have an inquiry screen where we can show total count of each type of contract for each customer separately.
SaaS Contracts
Perpetual Contracts

Monday, 16 May 2016

Acumatica is PCMag's Editor Choise

Hi All,

Today we have a great news. Acumatica won the prestigious PC Magazine Editors Choice Award!

Acumatica is PCMag's Editor Choise

Really great milestone!

Friday, 13 May 2016

Renaming Currency

Hi All,

Today want to share with you one way, how you can prepare Acumatica database for more personal demo.

If you use demo data, you may find that your base currency is in USD. But sometime you want to change it and show all transactions in local currency of your country. But there is no way to do it from the user interface.
But Currency code in Acumatica is just a string value that can be renamed on database level. But the tricky this is that it should be renamed in all tables at once, otherwise you will have a data inconsistency.
Renaming Currency in Acumatica
In this article will provide you the SQL script that does all renaming automatically. But note that it just renames currency code - all transactions amounts will be unchanged.

I have prepared stored procedure that you need to create on your database and then execute. Stored procedure contains several parameters:

  • @companyID int - company (tenant) identifier in the database where you want to rename currency
  • @oldCury NVARCHAR(10) - old currency code
  • @newCury NVARCHAR(10) - new currency code
  • @description NVARCHAR(255) - new currency user friendly description
  • @symbol NVARCHAR(10) - new currency symbol
This script must be used only for demo purpose. All changes on live database may damage the data.

Tuesday, 10 May 2016

Install Customized Package on Acumatica

Hi All,

Acumatica is growing rapidly over the past several years. We are opening new offices in new countries and going to new markets. But some countries requires some specific adaptation. In general can be - language localization, government required reports, country specific taxes and so on.

But as you may see, these functionality is required only for the specific markets, other users do not want to see not related reports and features. So we have decided to add it as a official customization to the standard product. Everyone who requires it can download and install package from Acumatica or request it from your contact person in Acumatica. I'm pretty sure that in the near future we will design some sort of marketplace or storage to share with you such types of localization.
Install Customized Package on Acumatica
Today I want to share with you the basic flow of how yo apply customization package to Acumatica.
I will do it on Example of GAF file export for Malaysian government.

From Acumatica I get 2 files:
  • Export_GAF.pdf - that is documentation about customization. Actually it includes steps for applying customization as well.
  • - this is Acumatica customization project, that should be applied for standard Acumatica.

Steps to install customization:
  1. You should use the Customization Projects (SM.20.45.05) form to upload and publish the customization project to Acumatica ERP.
  2. On the form toolbar, click Import and then click Import New Project in the menu.
  3. In the Open Package dialog box that appears, select the deployment package (a .zip file -, and then click Upload. 
     install customization in Acumatica
  4. Once the file is uploaded to Acumatica ERP, it appears in the table on the current form.
  5. Select the unlabeled check box in the row for this customization project in the table. If there are other published customization projects in your system, then you also need to select the unlabeled check boxes in the rows for these customization projects in the table before you start publishing the new project. Otherwise, these other published projects will be unpublished in the system.
  6. Click Publish on the form toolbar to initiate the publication. The Compilation window appears on the form. Wait until the publication process finishes.
  7. If everything is correct, validation process will show you a Publish button that you need to click to complete the process.
     install customization in Acumatica
  8. When the process finishes, close the window. The customization project is published.

That's all. Now you can use customization.

Have a fast publishing!

Friday, 6 May 2016

Sub Select For XML Attribute

Hi All,

Today want to share with you one complex requirement that can be archived with Acumatica Cloud xRP platform.
Let me describe scenario first. Lets assume we have customers certification system and we want to track their achievements. For each customer we have several persons (contacts) that want to do certification. Each person can choose one or several courses, depend on his knowledge, position and interest. Depend on each course person needs to complete one or more exams. For some coerces you may choose which of available exams do you want to complete (group 1 or group 2 of exams). And some of these groups are required and some are not.

Here I will provide diagram that illustrate this: Acumatica Cloud xRP platform

So the problem here that you have multiple dimensions - multiple Contacts, multiple Courses, multiple groups. If you want to get information about how many guys was certified in each company you should do several selects for each contact, course and group. This may significantly degrees performance of any report or inquiry screen.

To keep performance great, it is better to get all data in one select. Luckily Microsoft SQL Server supports very nice feature - Select for XML. This can help us to selects all dimensions and analyze it on server side.
Select for XML

Tuesday, 3 May 2016

Hiding the tab from the user interface

Hi Everyone

Today I want to discuss with you ways how you can control visibility of tab items in Acumatica User interfaces.
Hiding the tab from the user interface Acumatica
You can do it in one of the following two ways:
  • By setting a VisibleExp property on PXTabItem in ASPX page
  • By enabling/disabling AllowSelect property of the view that serves as a DataMember of the grid that is displayed on that tab
Welcome in this article if you want to see details.

Dynamically changing an attribute property for a given data record

Hi Everyone,

Suppose you need to change a particular property of a PXSomeAttribute residing on a Field of your data record.

Way 1
A straightforward way of doing it:
foreach (PXEventSubscriberAttribute attribute in cache.GetAttributes<Field>(dataRecord))
    PXSomeAttribute someAttribute = attribute as PXSomeAttribute;
    if (someAttribute != null
        someAttribute.Property = someValue;

Way 2
A less verbose / arguably more readable way of achieving the same goal with linq:

    .ForEach(attribute => attribute.Property = someValue);