Bug in PO when creating


I get a strange bug in the PO that only pops-up in normale users (managers) but not as SuperUser.

I click on Create Purchase Order as Manager and I fill in like below:

And then I click on Next, i get this error:

java.lang.IllegalArgumentException: Multiple decimal separators in pattern “###.###.##0,00”

at java.text.DecimalFormat.applyPattern(DecimalFormat.java:2581)

at java.text.DecimalFormat.<init>(DecimalFormat.java:466)

at gsp_openboxes_purchaseOrder_showOrderItems_gsp$_run_closure2_closure7.doCall(gsp_openboxes_purchaseOrder_showOrderItems_gsp.groovy:133)

at gsp_openboxes_purchaseOrder_showOrderItems_gsp$_run_closure2_closure7.doCall(gsp_openboxes_purchaseOrder_showOrderItems_gsp.groovy)

at gsp_openboxes_purchaseOrder_showOrderItems_gsp$_run_closure2.doCall(gsp_openboxes_purchaseOrder_showOrderItems_gsp.groovy:138)

at gsp_openboxes_purchaseOrder_showOrderItems_gsp$_run_closure2.doCall(gsp_openboxes_purchaseOrder_showOrderItems_gsp.groovy)

at gsp_openboxes_purchaseOrder_showOrderItems_gsp.run(gsp_openboxes_purchaseOrder_showOrderItems_gsp.groovy:352)

at org.pih.warehouse.order.PurchaseOrderController$_closure6.doCall(PurchaseOrderController.groovy:99)

at org.pih.warehouse.order.PurchaseOrderController$_closure6.doCall(PurchaseOrderController.groovy)

at grails.plugin.springcache.web.GrailsFragmentCachingFilter.doFilter(GrailsFragmentCachingFilter.groovy:66)

at net.sf.ehcache.constructs.web.filter.Filter.doFilter(Filter.java:86)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622)

at java.lang.Thread.run(Thread.java:748)


Interesting. Did you change the default.number.format in any of your supported locales?

By default, it’s defined in messages.properties as


And from what I understand, the default number format pattern should not change. At least, that’s what I’m reading now.

Instead, I guess when you change the locale on any given page, the Grail formatNumber taglib will know that you expect to see the number formatted properly for that locale. :person_shrugging:

However, I’ll be honest, I don’t actually understand how number formats and locales should work together. For now, reset the default number format (assuming you’ve changed it) and we’ll try to investigate a solution that gives the system a way to parse numbers in a consistent manner while allowing you to display numbers in the format you want.

cc @Artur We should probably create an OBPIH ticket to investigate this. Thoughts?


I did not change anything. Where can I check it?

I can think of two places where we could potentially change the default.number.format.

  1. messages.properties (or the locale-specific messages_YY.properties where YY is the locale code)
  2. The localization table (as a superuser you can access this data from Configuration > Localization)

After digging a little more, it looks like the default number format for the Dutch locale uses an “invalid” decimal number format.

Ignoring the escape characters, the number format matches what’s included in your initial post.


This is a bug.

For now, we should set this to match the default number format in messages.properties. But we also need to investigate why this happens and how we’re supposed to get around this for all the countries (besides the US and UK) that use this number format pattern.

As a workaround, you should be able to edit the Dutch translations (message_nl.properties under the exploded WAR file within the Tomcat webapps directory) and override the default number format in that file.

For Tomcat 7, that file will likely be found here


So then change the line




Save the file and restart your application.

NOTE: Any new deployments will likely overwrite this file, so you’ll need to keep updating this until we provide a bug fix in an upcoming release.

I can reproduce this error. Here is steps to reproduce this error.

  1. Add supportedLocales ‘nl’ in your application.yml file.

  2. Restart your app

  3. Login with Manager role

  4. Change your locale to Dutch.

  5. Create purchase order.

  6. Once you will save PO, It will redirect to addItems page and there you will see this error.

@Chetan_Maharishi Can you create an OBPIH ticket with this information and mention (@) Manon and me?

sure @jmiranda. Creating ticket.

Bumping, what I dont’t understand is:

If I login as a testuser with only Manager and Financial rights I get the error.
If I login as superuser I don’t get the error.

I also do not understand that. It should be included in our bug report so we can investigate further. The only thing that makes sense to me is that you’re using different default locales for each user (testuser uses NL and superuser uses EN). But I assume you’re using NL as well.

So I closed down the error:

If I select English it works when I set the language to Dutch I get the error.
What file could be wrong?

So I closed down the error: If I select English it works when I set the language to Dutch I get the error.

Thank you for the confirmation.

What file could be wrong?

The issue is described in detail in a reply above.

I think the issue was that the original messages_nl.properties file that you sent me contained the default number format that you were hoping to be able to use.

We’ve determined that we cannot use a comma as the decimal separator for the default number format for any locale. And we are still investigating how to allow implementation to use their own number format for displaying numeric values. That probably isn’t going to happen any time soon.

But we have a pull request that we’re hoping to get into the next release (v0.9.1) that fixes the immediate issue that you described in your original post.

In the above reply, I also describe a workaround for fixing the issue locally until we release this (which requires a non-trivial migration process to 0.9.x, which is still being documented).

@Artur For this reason, maybe we should consider this fix for a 0.8.x hotfix as well.