Unit price decimal precision on quotes

Yahoo Archive
1
Thanks Wayne! You've just saved me a big weekly headache!

~Wendy
----- Original Message -----
From: Wayne Cox
To: vantage@yahoogroups.com
Sent: Tuesday, April 23, 2002 12:45 PM
Subject: Re: [Vantage] Unit price decimal precision on quotes


At 10:59 AM 4/23/2002 -0400, you wrote:
>I have to change the decimal place at least once a week. We're having a
>problem deciding whether it's best to keep the 4 digits place or have a 2
>digits place. Aaah!

You can mod the form to have it both ways. I tried to find the one I wrote
last year, but don't have it handy. The unit cost on the PO was tight on
space for big numbers, where you didn't care about pennies, but
occasionally we had 100,000/ea @ 0.00550, so I couldn't just truncate
it. I was able to get Crystal to display nn,nnn,nnn.nn for big numbers,
but drop back to nnn.nnnnn for ones that used all the decimals.

You can go into the number format section under rounding or decimal places,
and instead of a fixed number, click the button to attach a chunk of
code. This isn't exact Crystal syntax, but I used something like:

if (int(price * 100) / 100) - price < 0.00001 then 2 else 5

This tests if there are any decimals out in the lest significant digits,
and returns a 2 or 5 to tell Crystal how many decimals to use. You could also



Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]
2
The unit price prints on the quotes with 4 decimal places. Anybody know how
to change this short of dividing by 100?

Thanks.

Mitchell Kirby
V. P. Manufacturing
Riten Industries, Inc.

800-338-0027, ext 210
800-338-0717 FAX
3
At 10:46 AM 4/23/2002 -0400, you wrote:
>The unit price prints on the quotes with 4 decimal places. Anybody know how
>to change this short of dividing by 100?

You can modify the quote form with Crystal Reports. Changing the number
decimals or doing a little math is easy.

-Wayne Cox
Twenty Three -- Information Technology Consulting
828-685-2338
4
Mitchell,

You'll have to use Crystal Reports to alter the decimal place. It's called the "UnitPrice" field. You'll need to go into the formatting properties for the field.

I have to change the decimal place at least once a week. We're having a problem deciding whether it's best to keep the 4 digits place or have a 2 digits place. Aaah!

Wendy Bowen
Network Administrator
Schmald Tool & Die, Inc.
Burton, Michigan
----- Original Message -----
From: Mitchell Kirby
To: Vantage (E-mail)
Sent: Tuesday, April 23, 2002 10:46 AM
Subject: [Vantage] Unit price decimal precision on quotes


The unit price prints on the quotes with 4 decimal places. Anybody know how
to change this short of dividing by 100?

Thanks.

Mitchell Kirby
V. P. Manufacturing
Riten Industries, Inc.

800-338-0027, ext 210
800-338-0717 FAX


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]
5
At 10:59 AM 4/23/2002 -0400, you wrote:
>I have to change the decimal place at least once a week. We're having a
>problem deciding whether it's best to keep the 4 digits place or have a 2
>digits place. Aaah!

You can mod the form to have it both ways. I tried to find the one I wrote
last year, but don't have it handy. The unit cost on the PO was tight on
space for big numbers, where you didn't care about pennies, but
occasionally we had 100,000/ea @ 0.00550, so I couldn't just truncate
it. I was able to get Crystal to display nn,nnn,nnn.nn for big numbers,
but drop back to nnn.nnnnn for ones that used all the decimals.

You can go into the number format section under rounding or decimal places,
and instead of a fixed number, click the button to attach a chunk of
code. This isn't exact Crystal syntax, but I used something like:

if (int(price * 100) / 100) - price < 0.00001 then 2 else 5

This tests if there are any decimals out in the lest significant digits,
and returns a 2 or 5 to tell Crystal how many decimals to use. You could also