BAQ for Miscelaneous Charges

Thanks Bill. I just made that field relation change and it works perfect!!!

--- In vantage@yahoogroups.com, Bill Jackson <fujijapman@...> wrote:
>
>  You may have a problem here, with this 'join' :
> ÂÂ
> (POHeader.Company = POMisc.Company and POHeader.PONum = integer(POMisc.DocMiscAmt))
> ÂÂ
> I'm guessing you want:
> ÂÂ
> (POHeader.Company = POMisc.Company and POHeader.PONum = POMisc.PONum)
>
>
> --- On Fri, 5/21/10, liss_c <lissette.contreras@...> wrote:
>
>
> From: liss_c <lissette.contreras@...>
> Subject: [Vantage] BAQ for Miscelaneous Charges
> To: vantage@yahoogroups.com
> Date: Friday, May 21, 2010, 12:21 PM
>
>
> ÂÂ
>
>
>
> I have created a BAQ that displays the PO NUmber,PO Lines, Part/Descrption and qunatities and the Cost of each line. However, we have been adding a lot of miscellaneous charges to our Purchase orders , so I am in the need to add them in the BAQ. I've been trying for a few days but still dont get to display the Misc Amount. This is my query:
>
> for each POHeader where ( POHeader.ApprovalStatus = 'A') no-lock , each Vendor where (POHeader.Company = Vendor.Company and POHeader.VendorNum = Vendor.VendorNum) no-lock , each PODetail where (POHeader.Company = PODetail.Company and POHeader.PONum = PODetail.PONUM) no-lock , each PORel where ( PORel.PORelNum = 1) and (PODetail.Company = PORel.Company and PODetail.PONUM = PORel.PONum and PODetail.POLine = PORel.POLine) no-lock , each POMisc outer-join where (POHeader.Company = POMisc.Company and POHeader.PONum = integer(POMisc.DocMiscAmt)) no-lock , each JobAsmbl where (PORel.JobNum = JobAsmbl.JobNum and PORel.AssemblySeq = JobAsmbl.AssemblySeq) no-lock by POHeader.PONum by PODetail.POLine.
>
> Any ideas?
>
> thanks
>
> Lissette Contreras
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
I have created a BAQ that displays the PO NUmber,PO Lines, Part/Descrption and qunatities and the Cost of each line. However, we have been adding a lot of miscellaneous charges to our Purchase orders , so I am in the need to add them in the BAQ. I've been trying for a few days but still dont get to display the Misc Amount. This is my query:

for each POHeader where ( POHeader.ApprovalStatus = 'A') no-lock , each Vendor where (POHeader.Company = Vendor.Company and POHeader.VendorNum = Vendor.VendorNum) no-lock , each PODetail where (POHeader.Company = PODetail.Company and POHeader.PONum = PODetail.PONUM) no-lock , each PORel where ( PORel.PORelNum = 1) and (PODetail.Company = PORel.Company and PODetail.PONUM = PORel.PONum and PODetail.POLine = PORel.POLine) no-lock , each POMisc outer-join where (POHeader.Company = POMisc.Company and POHeader.PONum = integer(POMisc.DocMiscAmt)) no-lock , each JobAsmbl where (PORel.JobNum = JobAsmbl.JobNum and PORel.AssemblySeq = JobAsmbl.AssemblySeq) no-lock by POHeader.PONum by PODetail.POLine.

Any ideas?

thanks

Lissette Contreras
 You may have a problem here, with this 'join' :
Â
(POHeader.Company = POMisc.Company and POHeader.PONum = integer(POMisc.DocMiscAmt))
Â
I'm guessing you want:
Â
(POHeader.Company = POMisc.Company and POHeader.PONum = POMisc.PONum)


--- On Fri, 5/21/10, liss_c <lissette.contreras@...> wrote:


From: liss_c <lissette.contreras@...>
Subject: [Vantage] BAQ for Miscelaneous Charges
To: vantage@yahoogroups.com
Date: Friday, May 21, 2010, 12:21 PM


Â



I have created a BAQ that displays the PO NUmber,PO Lines, Part/Descrption and qunatities and the Cost of each line. However, we have been adding a lot of miscellaneous charges to our Purchase orders , so I am in the need to add them in the BAQ. I've been trying for a few days but still dont get to display the Misc Amount. This is my query:

for each POHeader where ( POHeader.ApprovalStatus = 'A') no-lock , each Vendor where (POHeader.Company = Vendor.Company and POHeader.VendorNum = Vendor.VendorNum) no-lock , each PODetail where (POHeader.Company = PODetail.Company and POHeader.PONum = PODetail.PONUM) no-lock , each PORel where ( PORel.PORelNum = 1) and (PODetail.Company = PORel.Company and PODetail.PONUM = PORel.PONum and PODetail.POLine = PORel.POLine) no-lock , each POMisc outer-join where (POHeader.Company = POMisc.Company and POHeader.PONum = integer(POMisc.DocMiscAmt)) no-lock , each JobAsmbl where (PORel.JobNum = JobAsmbl.JobNum and PORel.AssemblySeq = JobAsmbl.AssemblySeq) no-lock by POHeader.PONum by PODetail.POLine.

Any ideas?

thanks

Lissette Contreras











[Non-text portions of this message have been removed]