(no text)

I have a problem with the conversion to the EURO:
The company works with milimeters and the unit cost sometimes is very small,
so when you pass the EURO conversion this field will be 0.
There is an example below that shows the situation:

Quantity in milimeters/ ESP Unit cost in milimeters/ ESP
Total cost/ ESP

1950 0,0060
11,7=12 ESP
if converted to the EURO:
1950 0,0000361 but with 4
decimals 12/166,386=0,07 EUROS
it will be 0.0000 EUROS


Ej:

100 0,0090
0,9=1 ESP
if converted to the EURO:
100 0,000054 but with 4 decimals
it will be 0.0000 EUROS 1/166,386=0,0060=0,00 EUROS


The problem is that after the conversion, when the unit cost and the total
cost are very small we will lost them.
I would like to know if someone else has had the same problem and what have
you done.
Thanks,
Oriol Raventós.
 

rguillenc

Member
Hi Oriol,

You should increase the numbers of decimals for the field/data item that you
have the problem.

----- Original Message -----
From: "Oriol Raventos" <[email protected]>
To: <[email protected]>
Sent: Monday, November 06, 2000 12:09 PM
Subject: (no text) ~~0:502


>
> I have a problem with the conversion to the EURO:
> The company works with milimeters and the unit cost sometimes is very
small,
> so when you pass the EURO conversion this field will be 0.
> There is an example below that shows the situation:
>
> Quantity in milimeters/ ESP Unit cost in milimeters/ ESP
> Total cost/ ESP
>
> 1950 0,0060
> 11,7=12 ESP
> if converted to the EURO:
> 1950 0,0000361 but with 4
> decimals 12/166,386=0,07 EUROS
> it will be 0.0000 EUROS
>
>
> Ej:
>
> 100 0,0090
> 0,9=1 ESP
> if converted to the EURO:
> 100 0,000054 but with 4 decimals
> it will be 0.0000 EUROS 1/166,386=0,0060=0,00 EUROS
>
>
> The problem is that after the conversion, when the unit cost and the
total
> cost are very small we will lost them.
> I would like to know if someone else has had the same problem and what
have
> you done.
> Thanks,
> Oriol Raventós.
>
>
>
>
> --------------------------
> To view this thread, visit the JDEList forum at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=5
02
> *************************************************************
> This is the JDEList World Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************
>
>
 

scott_parker

Reputable Poster
If increasing the number of decimals is what you plan on doing then make sure that you do a where used on that field. If it is stored in any files you will have to do a conversion.
 

Guest

Guest
To: [email protected]
Mon, 6 Nov 2000 04:54:28 -0800 (PST)
Date: Mon, 6 Nov 2000 04:54:28 -0800 (PST)
To: [email protected]
From: rguillenc <[email protected]>
Reply-to: [email protected]
Subject: [email protected]

Hi Oriol,

You should increase the numbers of decimals for the
field/data item that you
have the problem.

----- Original Message -----
From: "Oriol Raventos"
<[email protected]>
To: <[email protected]>
Sent: Monday, November 06, 2000 12:09 PM
Subject: (no text) ~~0:502


>
> I have a problem with the conversion to the EURO:
> The company works with milimeters and the unit cost
sometimes is very
small,
> so when you pass the EURO conversion this field will
be 0.
> There is an example below that shows the situation:
>
> Quantity in milimeters/ ESP Unit cost in milimeters/
ESP
> Total cost/ ESP
>
> 1950 0,0060
> 11,7=12 ESP
> if converted to the EURO:
> 1950 0,0000361 but with 4
> decimals 12/166,386=0,07 EUROS
> it will be 0.0000 EUROS
>
>
> Ej:
>
> 100 0,0090
> 0,9=1 ESP
> if converted to the EURO:
> 100 0,000054 but with 4 decimals
> it will be 0.0000 EUROS 1/166,386=0,0060=0,00 EUROS
>
>
> The problem is that after the conversion, when the
unit cost and the
total
> cost are very small we will lost them.
> I would like to know if someone else has had the same
problem and what
have
> you done.
> Thanks,
> Oriol Raventós.
>
>
>
>
> --------------------------
> To view this thread, visit the JDEList forum at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Ca
t=0&Board=W&Number=5
02
>
********************************************************
*****
> This is the JDEList World Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
>
********************************************************
*****
>
>




--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Ca
t=0&Board=W&Number=503

----- End forwarded message -----
 
Top