Formatting decimal depending on currency code

janpieter

Hello all,

We have a problem, a customer wants to format a decimal (Amount) depending on the currency code.

We know that you can do formatting with the AutoFormatType and AutoFormatExpr property of a decimal field but we can't figure out how to do the following formatting:

Little example

Amount in currency code EUR:
10.376,10

If currency code is USD then format like:
10,376.10

We know how we can change the format at point of displaying on forms/report but this requires lots of changes, we want to be able to set this behavior in tables.

Has anyone experience with this?

Thanks in advantage
regards, Jan-Pieter

Marco_Ferrari

I think you can try changing the AutoFormatTranslate function in codeunit 1. Add a case that format the output as you want....

Just an idea.

Marco