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
>