Great :)
Brian
--- In vantage@yahoogroups.com, "Marty Kuphall" <marty.kuphall@u...>
wrote:
Brian
--- In vantage@yahoogroups.com, "Marty Kuphall" <marty.kuphall@u...>
wrote:
> Brian,
>
> You nailed it. Adding the APInvDet table did the trick. Thank you
> so much.
>
> Marty Kuphall
> Chief Financial Officer
> Ultra Tool & Manufacturing, Inc.
> W169 N5954 Ridgewood Drive
> Menomonee Falls, WI 53051
>
> Phone: 262-703-0455
> Fax: 262-703-0468
> Toll Free: 800-779-3566
> marty.kuphall@u...
> www.ultratoolmfg.com
>
> The information contained in this electronic message (email) and
> any
> attachment(s) to it is/are intended for the exclusive use of the
> intended addressee(s) and may contain information that is
> confidential and/or privileged and exempt from disclosure under
> applicable law. If you are not the intended recipient(s) and have
> received this communication in error, please do not distribute
> it. Instead, please notify Ultra Tool & Manufacturing, Inc. at
> 1-800-779-3566 or by email at general@u... and
> destroy all copies of this message and any attachments. Thank
> you.
>
>
>
>
>
>
> -----Original Message-----
> From: Brian Stenglein [mailto:bstenglein@c...]
> Sent: Friday, August 06, 2004 8:05 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Crystal Report Link
>
>
> Marty,
>
> The reason you are seeing each invoice with every PO is because
> you
> are only linking the Invoice Table to the PO Table by Vendor #.
> You
> need to link it by PO #. Since the PO # is not in the Invoice
> Header
> Table you must add the Invoice Detail Table, link that to the PO
> Rel
> table, by PO, Line, Rel. If the only field you are using in the
> PO
> Header is PO Number, I think you can omit this table. Link PO
> Rel to
> APInvDtl, Link APInvDtl to APInvHead, and APInvHead to Vendor.
>
> HTH,
>
> Brian Stenglein
> Clow Stamping Co.
>
>
> --- In vantage@yahoogroups.com, "Marty Kuphall"
> <marty.kuphall@u...>
> wrote:
> > I do not see PORel or POLine as available linked fields under
> > POHed. Are they called something else? I'm using Crystal 8.0
> with
> > Vantage 5.1. Does that make any difference?
> >
> >
> > Marty Kuphall
> > Chief Financial Officer
> > Ultra Tool & Manufacturing, Inc.
> > W169 N5954 Ridgewood Drive
> > Menomonee Falls, WI 53051
> >
> > Phone: 262-703-0455
> > Fax: 262-703-0468
> > Toll Free: 800-779-3566
> > marty.kuphall@u...
> > www.ultratoolmfg.com
> >
> > The information contained in this electronic message (email)
> and
> > any
> > attachment(s) to it is/are intended for the exclusive use of
> the
> > intended addressee(s) and may contain information that is
> > confidential and/or privileged and exempt from disclosure under
> > applicable law. If you are not the intended recipient(s) and
> have
> > received this communication in error, please do not distribute
> > it. Instead, please notify Ultra Tool & Manufacturing, Inc. at
> > 1-800-779-3566 or by email at general@u... and
> > destroy all copies of this message and any attachments. Thank
> > you.
> >
> >
> >
> >
> >
> >
> > -----Original Message-----
> > From: Frank Zeigafuse [mailto:fzeigafuse@l...]
> > Sent: Thursday, August 05, 2004 10:44 AM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Crystal Report Link
> >
> >
> > on the porel --> po hed
> >
> > you need
> > ponum
> > porel
> > po line
> >
> >
> >
> >
> > Frank Zeigafuse
> >
> > Innovative Office Products
> >
> > General Manager
> >
> > Direct Phone: 610-559-6369
> >
> > Email: fzeigafuse@L...
> >
> >
> >
> > -----Original Message-----
> > From: Marty Kuphall [mailto:marty.kuphall@u...]
> > Sent: Thursday, August 05, 2004 11:09 AM
> > To: vantage@yahoogroups. com (E-mail)
> > Subject: [Vantage] Crystal Report Link
> >
> >
> > I need the help of you Crystal gurus with linking or grouping
> > trouble I'm having on what (I think) should be an easy report.
> >
> > Fields: PO Rel: JobNum
> > ExpChart
> > Vendor: VendorID
> > Name
> > APInvHed: InvNum
> > InvoiceDate
> > POHed: PONum
> >
> > Links: PORel---POHed: Company & PONum
> > POHed---APInvHed: Company & VendorNum
> > APInvHed---Vendor: Company & VendorNum
> >
> > Group by JobNum
> >
> > Each invoice is being shown with every PO when it should only
> go
> > with one po. Why am I getting those duplicate entries? I'm
> > guessing I'm missing an additional link or group but I've tried
> a
> > bunch of different combinations and now have officially given
> up!
> >
> > Thanks,
> >
> >
> > Marty Kuphall
> > Chief Financial Officer
> > Ultra Tool & Manufacturing, Inc.
> > W169 N5954 Ridgewood Drive
> > Menomonee Falls, WI 53051
> >
> > Phone: 262-703-0455
> > Fax: 262-703-0468
> > Toll Free: 800-779-3566
> > marty.kuphall@u...
> > www.ultratoolmfg.com
> >
> > The information contained in this electronic message (email)
> and
> > any
> > attachment(s) to it is/are intended for the exclusive use of
> the
> > intended addressee(s) and may contain information that is
> > confidential and/or privileged and exempt from disclosure under
> > applicable law. If you are not the intended recipient(s) and
> have
> > received this communication in error, please do not distribute
> > it. Instead, please notify Ultra Tool & Manufacturing, Inc. at
> > 1-800-779-3566 or by email at general@u... and
> > destroy all copies of this message and any attachments. Thank
> > you.
> >
> >
> >
> >
> >
> >
> >
> > 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=129kce7rt/M=295196.4901138.6071305.3
> > 001176/D=gr
> >
> oups/S=1705007183:HM/EXP=1091804940/A=2128215/R=0/SIG=10se96mf6/*
> > http://comp
> > anion.yahoo.com> click here
> >
> >
> <http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/
> > D=groups/S=
> > :HM/A=2128215/rand=330823463>
> >
> >
> > _____
> >
> > 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@L... 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]
> >
> >
> >
> > ------------------------ Yahoo! Groups
> > Sponsor --------------------~-->
> > Yahoo! Domains - Claim yours for only $14.70
> > http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/PhFolB/TM
> > ---------------------------------------------------------------
> --
> > ---~->
> >
> > 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
>
>
>
> ------------------------ Yahoo! Groups
> Sponsor --------------------~-->
> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
> Now with Pop-Up Blocker. Get it for free!
> http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/PhFolB/TM
> -----------------------------------------------------------------
> ---~->
>
> 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