Currency Conversion Cuts off at 10 decimal places

[Former Member]

Hello all,

When doing currency conversions the database cuts off the data two the 10th decimal place. I need to be at 12 decimal places. In the database the setting is set at decimal(25,10). Is there a way to change it so the database will go out to more decimal places?

Thanks for your help

Steve

[Former Member · Accepted solution]

It is possible to change the format to accept larger values, however this change will only impact any newly created Applications.

To change the default, open Administrator and select "Set Application Parameters"

Add the KeyID "SIGNED_DATA_FORMAT" and for the Value enter the total number of digits and the number of decimals, ex: "20,15" would indicate 20 digits to the left of the decimal and 15 to the right.

Click on Update.

Any new Application created will now use this new value for the Signed data column.

I hope this helps in answering your question.

[Former Member · Accepted solution]

Hi

I have a question, if i copy an Aplication, the new Aplication copied is used this new value for the Signed data column ??

Or only its work if I created a new Aplication.....

Thanks!

[Former Member · Accepted solution]

Hello,

If you copy an application where the signed_data_format value has been changed, that new value will be carried over to the new copied version of the original application.

I hope this answers your question. Thanks

[Former Member · Accepted solution]

Craig,

Do you think if we Change the values in the current app and modified app, That would do the trick?

Also you can modified the sigend data field in the fact table to acoount for 12 dicimal.

This will save the copy process and do not have to go thru all of the cary things!.

Sam

[Former Member · Accepted solution]

Oh the only thing you will have to do is import tthe data again with the correct decimal.