NetSuite FreeMarker Currency Formatting in Advance PDF Layout

What is FreeMarker?

Apache FreeMarker is a valuable template engine that NetSuite uses in its Advanced PDF Layout feature. It allows users to further customize basic templates for NetSuite records or email templates. The most common use for FreeMarker is, its use of conditional statements and loops within templates which can be very helpful when creating heavily customized templates.

A very common question we are asked when customizing Transaction templates is:

“What are the best practices for number formatting in FreeMarker?”

One of the best features of FreeMarker is its ability to perform calculations within the PDF/HTML based on the record. However, when manipulating data from NetSuite’s currency fields, the currency format is lost.

For example, here is a PDF where the formatting is not touched, but for the Total we used a custom calculation within the FreeMarker code, so the format is lost. Also note that the Rate is seen as a large Decimal number, which most Customers do not want to see, this can also be manipulated using FreeMarker.

Calculated Total value in FreeMarker with no formatting

Calculated Total value in FreeMarker with no formatting

Here is an example of the code used to calculate the Total:

How do we fix this to show it as a Currency?

The most basic way to format a number as Currency is to add ?string.currency onto the end of the variable that is being used. This will bring any numbers to 2 decimal places and will also put a $ next to the number. Also, negative numbers will no longer have a – in front of them and will instead be surrounded by parentheses. All of this is very helpful for USD PDFs.

Here is the code adjustment made:

And here is the PDF for the USD customer:

String.Currency Formatting View

String.Currency Formatting View

What about for Non-USD Customers?

Unfortunately, this feature does not take into account of the transaction currency, as we can see with this example of the same code used on a Customer that uses GBP as their currency.

Non-USD Formatting

Non-USD Formatting

An easy way we can get around this is to use ?string(“,##0.00”) instead of ?string.currency to get the number to 2 decimal places.
Then we also need to get the currency from the record we are using. Once we have the currency, we can have conditionals inside of the FreeMarker to assign the current Currency Symbol to the record’s currency.

NetSuite has a native field called currencysymbol that we can use to assign the needed currency symbol:

Then our code will look like this when calculating whatever totals we need to for the template:

Now our PDF will look like this:

Foreign Currency Formatted Version

Foreign Currency Formatted Version

We hope you found this trick useful!

If you have any NetSuite customization needs,  PLEASE FEEL FREE TO CONTACT US!

About ABACI:

ABACI is a premier NetSuite Solution Provider.  That provides deep knowledge; in both business process and technology architecture. Our team is passionate about NetSuite and has an exclusive commitment to NetSuite. We pride ourselves on providing the highest level of system expertise on its full suite of cloud-based business management applications.