Wednesday, September 13, 2017

Amount to Words conversion at Acumatica Reports

Hi Everyone,

As we do not yet have Amount to Words function inside our top notch Report Designer, let me share one created to print cheques from AR module.

Same logic applies and can be reused anywhere inside Acumatica Report Designer. I did it for up to 10,000 amount, but you can easily extend it upwards.

1. First of all lets create few Variables on top of the Reporting Group where we are going to use A2W conversion.

a) AmountCents - that will be total amount converted to Cents. I used ARPayment.CuryOrigDocAmt but you can use ANY other numeric field as a SOURCE
b) AmtThousands - that will be just how many thousands we have
c) AmtHundreds - displays number of hundreds only
d) AmtOnes - Ones only
c) AmtCents - Cents only

Below are all the formulae:







2. Secondly add quite long formula into the field itself, here it is:

Your Field: =Iif($AmtThousands<>0,Switch($AmtThousands=10,'Ten',$AmtThousands=9,'Nine',$AmtThousands=8,'Eight',$AmtThousands=7,'Seven',$AmtThousands=6,'Six',$AmtThousands=5,'Five',$AmtThousands=4,'Four',$AmtThousands=3,'Three',$AmtThousands=2,'Two',$AmtThousands=1,'One') + ' Thousand ','') + Iif($AmtHundreds<>0,Switch($AmtHundreds=9,'Nine',$AmtHundreds=8,'Eight',$AmtHundreds=7,'Seven',$AmtHundreds=6,'Six',$AmtHundreds=5,'Five',$AmtHundreds=4,'Four',$AmtHundreds=3,'Three',$AmtHundreds=2,'Two',$AmtHundreds=1,'One') + ' Hundred ','') + Iif($AmtTens<>0,Switch($AmtTens=9,'Ninety',$AmtTens=8,'Eighty',$AmtTens=7,'Seventy',$AmtTens=6,'Sixty',$AmtTens=5,'Fifty',$AmtTens=4,'Forty',$AmtTens=3,'Thirty',$AmtTens=2,'Twenty',$AmtTens=1,'') + ' ','') + Iif($AmtTens=1,Switch($AmtOnes=9,'Nineteen',$AmtOnes=8,'Eighteen',$AmtOnes=7,'Seventeen',$AmtOnes=6,'Sixteen',$AmtOnes=5,'Fifteen',$AmtOnes=4,'Fourteen',$AmtOnes=3,'Thirteen',$AmtOnes=2,'Twelve',$AmtOnes=1,'Eleven',$AmtOnes=0,'Ten') + ' ','') + Iif($AmtTens<>1,Switch($AmtOnes=9,'Nine',$AmtOnes=8,'Eight',$AmtOnes=7,'Seven',$AmtOnes=6,'Six',$AmtOnes=5,'Five',$AmtOnes=4,'Four',$AmtOnes=3,'Three',$AmtOnes=2,'Two',$AmtOnes=1,'One',$AmtOnes=0,''),'') + Iif($AmountCents=$AmtCents,'Zero','') + Iif($AmtCents=0,' Only',' and ' + CStr($AmtCents) + '¢ Only')

3. Let see what we got:

It works only up to 10k, but if you wish, you can add in front of the formula further parsing.

All the Best,

Thursday, July 27, 2017

Acumatica is on Gartner Magic Quadrant

Congratulations Everyone!

We have finally made it, now Acumatica is on Gartner.
You request for a copy here:   Request Gartner Report

At the same time, PC Magazine made us top brands. I can not believe it :)

Full article here:

PC Magazine 2017

All the best,

Wednesday, November 11, 2015

Reporting - Excel simple format support.

Hi Guys,

As you aware, Export in Excel Simple format is deprecated.
It is not available from version 5 onwards.

What you are not aware, probably.
For those who were using it in earlier versions, please take note.

If you are going to open and edit your old version report with the new version Report Designer.
It is going to kill your Excel Simple Export settings irreversibly.

Therefore, please make sure using Old Report designer to correct/edit Older versions reports.

Other words, there is no compatibility in the future versions of report designer with the older versions of the software. You can not edit and save reports of version 3.00 by report designer from version 5.00
It will spoil the report.

All the best,

Wednesday, November 4, 2015

Login Page Customization.

Hi Guys,

Some time ago, there was a post on how to change the login pictures if you have access to Acumatica web site folder. But nowadays we all go cloud, heh, so no more access to IIS folders directly.

Well, so THIS POST is about How To Change the Login Pictures for your customer, without directly changing the files in the folder.

We can accomplish it by using simple customization technique. It proven on version 5.1 onwards, but should work on earlier as well.

What we are going to do is - by using a customization we will replace the files, located at the web site folder :)

Let's make it very simple, sorry, experienced C# developers, I will go step by step, so everyone can follow.

1. Make sure you can connect to Acumatica as a Customizer.

2. Place your picture files, resolution 1500 x 1000 pixels, in jpg format in a local folder on your working PC or laptop.
There should be max 6 pictures.

3. Login to Acumatica. Say goodbye to this guy. You are seeing him the last time...

4. Navigate to: Configuration->Common Settings->Site Preference

5. Upload here all your 6 files. Just Press Files->Then drag and drop all the files into upload screen.

6. Close the Files upload screen. Refresh the Site Preference screen. Click on FILES menu again. Now let's see all those files one by one in the browser. We need it to get ReferenceID for each file.
Just click on each file link, it will open you a tab in the browser.

Please note the number you need to record is highlighted. Please pull all 6 numbers for all 6 files into your notepad for future reference.

7. Now we are ready to hack Acumatica and insert our files directly into WEB site folder :) by customization. Go to System->Customization->Customization Projects. If you have one, select it, if you do not have existing customization, just create a new project. Then click on it. It will open a screen. There choose File->Edit Project XML

8. Now manually add the following records right after first line:

<File AppRelativePath="Icons\login_bg1.jpg" FileID="42acd25f-b952-46a2-aae8-35a802d1d47a" />
<File AppRelativePath="Icons\login_bg2.jpg" FileID="ac45d04a-7c4a-4cf1-bf42-3cdb517eecc6" />
<File AppRelativePath="Icons\login_bg3.jpg" FileID="28ee3171-e330-4de4-83bf-750e31eb2168" />
<File AppRelativePath="Icons\login_bg4.jpg" FileID="8d6876f9-5721-45e1-b481-9ca36e5eff49" />
<File AppRelativePath="Icons\login_bg5.jpg" FileID="809703c6-a689-4218-8347-a6d78f563ae0" />
<File AppRelativePath="Icons\login_bg6.jpg" FileID="b11ad862-1ef2-47d4-8c8b-f398383552b1" />

Please note last part is the reference from out Notepad.

9. Press button Save to database. Screen will refresh and your records will be moved somewhere down to the file body, you can find them by scrolling down, no worries, they are NOT gone.

10. Now from the menu on top choose Publish->Publish Current Project. Validation will start and prompt you a message:

Ignore it :). Press Publish.

11. Enjoy your brand new Acumatica system

All the best,


Friday, August 7, 2015

Urgently Require Acumatica Consultant and Support Engineer in Singapore

Hi Guys,

Please let me know if anyone from Singapore is keen to work as a consultant and support engineer.

Location: Singapore

I am really shorthanded and looking for a bright candidate. Please drop me an e-mail if interested.



P.S. Agents/Hiring Agencies please do not bother, I am looking for direct candidates.