yes in general the database consistency and forms are below average at best
I have no ideas why the don't have text as text and numbers as numbers !!
it makes linking very limited in potential power
Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Thursday, December 09, 2004 11:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Subreport help
The problem might be that on epicor's form (if I remember correctly) they
turn their numbers into text so you need to do a conversion to link the po#,
line and release fields so that the 2 fields you are linking are the same
type. I haven't touched this in quite a while, but I seem to remember that
being an issue.
-----Original Message-----
From: Julie Lehmann [mailto:jlehmann@...]
Sent: December 09, 2004 11:01 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Subreport help
Would anyone be willing to offer advice on this - I want to add a simple
field into the PO form (showing if a line/release has a partial shipment
against it), - POREL.receivedqty. Thanks to earlier help from folks on this
list, I know I have to add a subreport, andI think I have that part down
okay, but I guess I don't understand the linking piece of it. To me, it
makes sense that I should link to the PO number, PO line, PO Rel and then
grab the POREL.receivedqty, but
I don't get any data, plus when I use any of the xxxxx.PONum fields, I don't
have an appropriate field to select from to link to. I've tried umpteen
different links and finally found one "porel.duedate" that gives me data on
the specific PO I'm looking at, but also 4 others. That makes sense if it's
just looking for matching due dates, but then if I add PONum again, I get
nothing.
I must have a mental block or something, because it seems like it should be
simple enough (I watched Epicor's web video like 6 times), so I would
appreciate any help on this immensely!
Thanks guys & gals!
Julie Lehmann, MIS Director
MERCURY MINNESOTA INC.
507-332-1149
----------
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.289 / Virus Database: 265.4.8 - Release Date: 12/8/2004
[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/.
(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
Yahoo! Groups Links
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
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129oh960l/M=298184.5639630.6699735.3001176/D=gr
oups/S=1705007183:HM/EXP=1102694672/A=2434971/R=0/SIG=11eeoolb0/*http://www.
netflix.com/Default?mqso=60185400> click here
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=groups/S=
:HM/A=2434971/rand=267826870>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards
This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.
Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).
[Non-text portions of this message have been removed]
I have no ideas why the don't have text as text and numbers as numbers !!
it makes linking very limited in potential power
Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Thursday, December 09, 2004 11:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Subreport help
The problem might be that on epicor's form (if I remember correctly) they
turn their numbers into text so you need to do a conversion to link the po#,
line and release fields so that the 2 fields you are linking are the same
type. I haven't touched this in quite a while, but I seem to remember that
being an issue.
-----Original Message-----
From: Julie Lehmann [mailto:jlehmann@...]
Sent: December 09, 2004 11:01 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Subreport help
Would anyone be willing to offer advice on this - I want to add a simple
field into the PO form (showing if a line/release has a partial shipment
against it), - POREL.receivedqty. Thanks to earlier help from folks on this
list, I know I have to add a subreport, andI think I have that part down
okay, but I guess I don't understand the linking piece of it. To me, it
makes sense that I should link to the PO number, PO line, PO Rel and then
grab the POREL.receivedqty, but
I don't get any data, plus when I use any of the xxxxx.PONum fields, I don't
have an appropriate field to select from to link to. I've tried umpteen
different links and finally found one "porel.duedate" that gives me data on
the specific PO I'm looking at, but also 4 others. That makes sense if it's
just looking for matching due dates, but then if I add PONum again, I get
nothing.
I must have a mental block or something, because it seems like it should be
simple enough (I watched Epicor's web video like 6 times), so I would
appreciate any help on this immensely!
Thanks guys & gals!
Julie Lehmann, MIS Director
MERCURY MINNESOTA INC.
507-332-1149
----------
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.289 / Virus Database: 265.4.8 - Release Date: 12/8/2004
[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/.
(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
Yahoo! Groups Links
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
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129oh960l/M=298184.5639630.6699735.3001176/D=gr
oups/S=1705007183:HM/EXP=1102694672/A=2434971/R=0/SIG=11eeoolb0/*http://www.
netflix.com/Default?mqso=60185400> click here
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=groups/S=
:HM/A=2434971/rand=267826870>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and keyboards
This e-mail is from Innovative Office Products, Inc. but expresses the views of the sender and not necessarily the views of the company. The email and any files transmitted with it are confidential to the intended recipient at the e-mail address to which it has been addressed. It may not be disclosed or used by any other than that addressee, nor may it be copied in any way. If received in error, please delete and notify the sender via e-mail or sales@... quoting the name of the sender. Messages sent via this medium may be subject to delays, non-delivery and unauthorized alteration. This e-mail has been prepared using information believed by the author to be reliable and accurate. Unless expressly stated otherwise, this e-mail does not form part of a legally binding contract or agreement between recipient and Innovative Office Products, Inc.
Warning: Although Innovative Office Products, Inc. has taken reasonable precautions to ensure no viruses are present in this email, we cannot accept responsibility for any loss or damage arising from the use of this email or attachments. It is, therefore, your responsibility to scan attachments (if any).
[Non-text portions of this message have been removed]