BAQ Summarize Problem

Yahoo Archive
1
Thanks Robert

First I didn't say I am on Epicor 9.04

Secondly that where statement was added after it didn't work and I tried to make it work.
The type of PO strangely is in POrel not in POdtl.
The POrel is linked to POdtl through company,ponum,poline.

Ephraim
Ephraim Feldman

-----Original Message-----
From: Robert Brown <robertb_versa@...>
Sender: vantage@yahoogroups.com
Date: Thu, 8 Jul 2010 13:55:27
To: <vantage@yahoogroups.com>
Reply-To: vantage@yahoogroups.com
Subject: Re: [Vantage] BAQ Summarize Problem

Working from memory - but isn't subcontract (versus stock or misc) defined in
PODtl (not PORel)?

I've also never written a BAQ where I had the need to have the initial statement
"where Part.Company = Constants.CurrentCompany".

That may be driving your error message as you initially defined company as
constant for Part (& the BAQ wizard isn't the brightest app I've ever used - to
put it mildly - and it may not be trickling down thru your Part to PartMtl join
& PartMtl to PODtl join - particularly depending upon the table field joins you
then set up to bring in POrel).

Just a thought as you aren't showing what table (and fields) you joined POrel
thru.

Rob



________________________________
From: efyf_1999 <effgroups@...>
To: vantage@yahoogroups.com
Sent: Thu, July 8, 2010 2:04:10 PM
Subject: [Vantage] BAQ Summarize Problem

Â
Hi

I try to Make a BAQ having the Part Joined to PartMtl wich in turn joines the
POdtl to get the BOM last purchase price

Here is the Query:
for each Part no-lock where Part.Company = Constants.CurrentCompany , each
PartMtl no-lock where (Part.Company = PartMtl.Company and Part.PartNum =
PartMtl.PartNum ) , last PODetail no-lock where (PartMtl.Company =
PODetail.Company and PartMtl.MtlPartNum = PODetail.PartNum ).

Now i created a calculated field to sum the PO price per part (Total of all BOM
prices) and it works fine

But then i wanted to link to the PORel Table to see if the POline was a
subcontracted or a stock order but i get the following error when Analyzing:

PODetail Company must be a quoted constant or an unabbreviated, unambiguous
buffer/field reference for buffers known to query . (7328)

Can someone help me on how to do it?







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




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

I try to Make a BAQ having the Part Joined to PartMtl wich in turn joines the POdtl to get the BOM last purchase price

Here is the Query:
for each Part no-lock where Part.Company = Constants.CurrentCompany , each PartMtl no-lock where (Part.Company = PartMtl.Company and Part.PartNum = PartMtl.PartNum ) , last PODetail no-lock where (PartMtl.Company = PODetail.Company and PartMtl.MtlPartNum = PODetail.PartNum ).

Now i created a calculated field to sum the PO price per part (Total of all BOM prices) and it works fine

But then i wanted to link to the PORel Table to see if the POline was a subcontracted or a stock order but i get the following error when Analyzing:

PODetail Company must be a quoted constant or an unabbreviated, unambiguous buffer/field reference for buffers known to query . (7328)


Can someone help me on how to do it?
3
Working from memory - but isn't subcontract (versus stock or misc) defined in
PODtl (not PORel)?

I've also never written a BAQ where I had the need to have the initial statement
"where Part.Company = Constants.CurrentCompany".

That may be driving your error message as you initially defined company as
constant for Part (& the BAQ wizard isn't the brightest app I've ever used - to
put it mildly - and it may not be trickling down thru your Part to PartMtl join
& PartMtl to PODtl join - particularly depending upon the table field joins you
then set up to bring in POrel).

Just a thought as you aren't showing what table (and fields) you joined POrel
thru.

Rob



________________________________
From: efyf_1999 <effgroups@...>
To: vantage@yahoogroups.com
Sent: Thu, July 8, 2010 2:04:10 PM
Subject: [Vantage] BAQ Summarize Problem

Â
Hi

I try to Make a BAQ having the Part Joined to PartMtl wich in turn joines the
POdtl to get the BOM last purchase price

Here is the Query:
for each Part no-lock where Part.Company = Constants.CurrentCompany , each
PartMtl no-lock where (Part.Company = PartMtl.Company and Part.PartNum =
PartMtl.PartNum ) , last PODetail no-lock where (PartMtl.Company =
PODetail.Company and PartMtl.MtlPartNum = PODetail.PartNum ).

Now i created a calculated field to sum the PO price per part (Total of all BOM
prices) and it works fine

But then i wanted to link to the PORel Table to see if the POline was a
subcontracted or a stock order but i get the following error when Analyzing:

PODetail Company must be a quoted constant or an unabbreviated, unambiguous
buffer/field reference for buffers known to query . (7328)

Can someone help me on how to do it?







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