[GAJ]

We have an issue where an errant single quote appears in the Discount total field, only when we Print in Customer’s Locale.

I’ve tried these combinations:

Code:
${record.discounttotal} yields -105,50’€ (the original problem)
${record.discounttotal?string?replace(“/'”, ” “)} yields -105,5 (a proposed workaround)
${record.discounttotal?string[“000.00”]} yields -105,50 (a proposed workaround)
${record.currencysymbol} yields EUR (hoping to get €)
${record.currencyname} yields Euro (hoping to get €)
${record.currency} yields Euro (hoping to get €)
Of course I could add if/then/else logic in the template, or in a custom transaction body field,

but is there a sales order or transaction level search column internal ID I can use at this level to get the “€” symbol dynamically?

“Currency Symbol on Line Items” is a Post from back in 2009 where Evan explained that this ID was not available.

Hoping this is no longer true.

Thank you,

Gary
This is a cached copy. Click here to see the original post.

[GAJ]

P.S. This is registered as: Defect 378795: Display of Discount on Invoice and Credit Memo-errant single quote

[Nelliott]

Maybe try:

Code:
${record.discounttotal}?keep_before_last(“‘”)${record.discounttotal}?keep_after_last(“‘”)

I haven’t tried this but according to the freemarker Built-Ins for strings that should in theory give you : -105,50€

I don’t think you need “?string”

You may find this useful:

http://freemarker.incubator.apache.o…ns_string.html

If you run in to trouble butting the left and right side of the string together you may need to assign each to a variable then concatenate them into one.

Not ideal I know, but if it works…

[Author]

Posts