Receiving BAQ Blank Title 81050

for each RcvDtl no-lock , each PartTran where (RcvDtl.Company = PartTran.Company and RcvDtl.VendorNum = PartTran.VendorNum and RcvDtl.PurPoint = PartTran.PurPoint and RcvDtl.PackSlip = PartTran.PackSlip and RcvDtl.PackLine = PartTran.PackLine) no-lock .










--- In vantage@yahoogroups.com, "Brian W. Spolarich " <bspolarich@...> wrote:
>
> Lacking psychic powers, perhaps you could provide the BAQ 4GL query statement? :-) I'm guessing you need to do an outer join but since I don't know what your query looks like, how would I know? If you want folks to help you, it is good to give them something specific to start with.
>
> -brian
>
> --
> Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
> Â Â Â Â bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of ziimeone
> Sent: Friday, July 31, 2009 2:24 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Receiving BAQ
>
> Ok I've been working all day on a simple BAQ, so I thought. I wanted to see everything the receiving department receives for the day. I began the BAQ with RcvDtl. For some reason it only shows part numbers that are received via Po. I can't get the query to show Job receipt to Inventory. Now I'm stuck playing with PartTran and the same thing happens. Any ideas?
>
>
>
> ------------------------------------
>
> 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/linksYahoo! Groups Links
>
Ok I've been working all day on a simple BAQ, so I thought. I wanted to see everything the receiving department receives for the day. I began the BAQ with RcvDtl. For some reason it only shows part numbers that are received via Po. I can't get the query to show Job receipt to Inventory. Now I'm stuck playing with PartTran and the same thing happens. Any ideas?
Lacking psychic powers, perhaps you could provide the BAQ 4GL query statement? :-) I'm guessing you need to do an outer join but since I don't know what your query looks like, how would I know? If you want folks to help you, it is good to give them something specific to start with.

-brian

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of ziimeone
Sent: Friday, July 31, 2009 2:24 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Receiving BAQ

Ok I've been working all day on a simple BAQ, so I thought. I wanted to see everything the receiving department receives for the day. I began the BAQ with RcvDtl. For some reason it only shows part numbers that are received via Po. I can't get the query to show Job receipt to Inventory. Now I'm stuck playing with PartTran and the same thing happens. Any ideas?



------------------------------------

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/linksYahoo! Groups Links