No but if you are willing to share it would be greatly appreciated!
M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Vic Drecchio
Sent: Tuesday, October 06, 2009 11:11 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] rounding Issue on AR Invoice
Manasa,
I handled a similar issue a while back replacing the grand total value
with a formula that was an if/then and if "subttl" <> "grandttl" then
make grandttl = subttl or some logic like that.
Have you ventured down that path yet?
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Manasa Reddy
Sent: Tuesday, October 06, 2009 11:37 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] rounding Issue on AR Invoice
And it's Tuesday, maybe my brain will figure it out when I am not
obsessing!
Thanks for your enthusiasm...at least I'm having a better day today!
M. Manasa Reddy
manasa@... <mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001
________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Thomas Rose
Sent: Tuesday, October 06, 2009 10:15 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] rounding Issue on AR Invoice
It probably still can be handled in Crystal. However, you would have to
back into the number. In the Crystal report, you would know what the
invoice total is supposed to be (what Vantage is going to add to your
AR). You could also calculate what the rounded total of the invoice
should be, and find out if there is a difference, and the amount of the
difference. Then, you just need to set a rule for where to put the
rounding difference. The easiest is probably to put it in the last line
item of the invoice, but you could probably find the largest line of the
invoice and put it there. Some creative thinking could probably come up
with some other rule that could work. I'm just thinking out loud here,
and there is now a lot of work involved, but it should be doable. Of
course, a really detail oriented customer will still find a rounding
difference on one line of his invoice.
Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY
"The World Leader in Back-lit Mirrors & Mirror TV Technology"
T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com
<http://www.electricmirror.com>
<http://www.electricmirror.com <http://www.electricmirror.com> > >
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Manasa Reddy
Sent: Tuesday, October 06, 2009 7:36 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] rounding Issue on AR Invoice
At first that was what I wanted, but it still shorts or overs my
receivables.
M. Manasa Reddy
manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001
________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Thomas Rose
Sent: Tuesday, October 06, 2009 9:25 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] rounding Issue on AR Invoice
You should be able to edit the Crystal report that is the AR invoice
form. Use round functions to calculate new field values, and then use
the new fields. Considering how many fields there are on the AR invoice
form, that will be a lot of work, but if it solves your problem it may
be worth it.
Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY
"The World Leader in Back-lit Mirrors & Mirror TV Technology"
T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com
<http://www.electricmirror.com>
<http://www.electricmirror.com <http://www.electricmirror.com> >
<http://www.electricmirror.com <http://www.electricmirror.com>
<http://www.electricmirror.com <http://www.electricmirror.com> > > >
Note: The information contained in the e-mail, including any
attachments, is legally privileged and confidential. If you are not the
intended recipient you are hereby notified that any reading, use or
dissemination of this message is strictly prohibited. If you have
received this message in error, please immediately notify us by
telephone at 425-776-4946 and delete this message from your system. Even
though this e-mail and any attachments are believed to be free of any
virus or other defect that might affect any computer system into which
it is received and opened, it is the responsibility of the recipient to
ensure that it is virus free, and no responsibility is accepted by
Electric Mirror LLC for any loss or damage arising in any way from its
use
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of Elaine Dyett
Sent: Monday, October 05, 2009 9:01 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] rounding Issue on AR Invoice
I have put a help call in on behalf of our customer.
Our programmer looked at it and the information on the bottom of the
invoice is being picked up from different fields on the header record.
or programmer has fixed it for our client but I want it fixed in the
standard form.
Elaine
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
------------------------------------
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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo
<http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links
[Non-text portions of this message have been removed]
M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Vic Drecchio
Sent: Tuesday, October 06, 2009 11:11 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] rounding Issue on AR Invoice
Manasa,
I handled a similar issue a while back replacing the grand total value
with a formula that was an if/then and if "subttl" <> "grandttl" then
make grandttl = subttl or some logic like that.
Have you ventured down that path yet?
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Manasa Reddy
Sent: Tuesday, October 06, 2009 11:37 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] rounding Issue on AR Invoice
And it's Tuesday, maybe my brain will figure it out when I am not
obsessing!
Thanks for your enthusiasm...at least I'm having a better day today!
M. Manasa Reddy
manasa@... <mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001
________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Thomas Rose
Sent: Tuesday, October 06, 2009 10:15 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] rounding Issue on AR Invoice
It probably still can be handled in Crystal. However, you would have to
back into the number. In the Crystal report, you would know what the
invoice total is supposed to be (what Vantage is going to add to your
AR). You could also calculate what the rounded total of the invoice
should be, and find out if there is a difference, and the amount of the
difference. Then, you just need to set a rule for where to put the
rounding difference. The easiest is probably to put it in the last line
item of the invoice, but you could probably find the largest line of the
invoice and put it there. Some creative thinking could probably come up
with some other rule that could work. I'm just thinking out loud here,
and there is now a lot of work involved, but it should be doable. Of
course, a really detail oriented customer will still find a rounding
difference on one line of his invoice.
Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY
"The World Leader in Back-lit Mirrors & Mirror TV Technology"
T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com
<http://www.electricmirror.com>
<http://www.electricmirror.com <http://www.electricmirror.com> > >
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Manasa Reddy
Sent: Tuesday, October 06, 2009 7:36 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] rounding Issue on AR Invoice
At first that was what I wanted, but it still shorts or overs my
receivables.
M. Manasa Reddy
manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001
________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Thomas Rose
Sent: Tuesday, October 06, 2009 9:25 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] rounding Issue on AR Invoice
You should be able to edit the Crystal report that is the AR invoice
form. Use round functions to calculate new field values, and then use
the new fields. Considering how many fields there are on the AR invoice
form, that will be a lot of work, but if it solves your problem it may
be worth it.
Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY
"The World Leader in Back-lit Mirrors & Mirror TV Technology"
T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com
<http://www.electricmirror.com>
<http://www.electricmirror.com <http://www.electricmirror.com> >
<http://www.electricmirror.com <http://www.electricmirror.com>
<http://www.electricmirror.com <http://www.electricmirror.com> > > >
Note: The information contained in the e-mail, including any
attachments, is legally privileged and confidential. If you are not the
intended recipient you are hereby notified that any reading, use or
dissemination of this message is strictly prohibited. If you have
received this message in error, please immediately notify us by
telephone at 425-776-4946 and delete this message from your system. Even
though this e-mail and any attachments are believed to be free of any
virus or other defect that might affect any computer system into which
it is received and opened, it is the responsibility of the recipient to
ensure that it is virus free, and no responsibility is accepted by
Electric Mirror LLC for any loss or damage arising in any way from its
use
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of Elaine Dyett
Sent: Monday, October 05, 2009 9:01 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] rounding Issue on AR Invoice
I have put a help call in on behalf of our customer.
Our programmer looked at it and the information on the bottom of the
invoice is being picked up from different fields on the header record.
or programmer has fixed it for our client but I want it fixed in the
standard form.
Elaine
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
------------------------------------
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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo
<http://groups.yahoo.com/group/vantage/linksYahoo> ! Groups Links
[Non-text portions of this message have been removed]