Formatting price field on invoice with 2 decimals: convert string

Peter Vermeulen

We would need to format the price field on our sales invoices to have 2 decimals.

The field is r.l.price.iou and this is a string field.

So we convert it to a value with function val()

then we format it correctly with sprintf$

==> sprintf$( "%@ZZZZZZZZZ9VD99@", val( r.l.price.iou ) )

this works fine in most situations but if we have a price =  2,142.6785  USD  (where the comma is our thousand separator and poing the decimal point) the result is "0.00"

I assume the issue is caused by the thousand separator.

Appreciate your ideas to help us fix this.

agidwani

sprintf$( "%@ZZZZZZZZZ9VD99@", val( str.replace$(r.l.price.iou, ",", "") ) )