Report design problem trying to find open PO's where "Buy For" i

Yahoo Archive
1
As Cathy said, it's on the PORel table and not PODetail... look for the TranType field. A value of "PUR-SUB" indicates subcontract. The JobSeqType should also be "S", but the TranType field is always there in both Vantage and E9.

Ernie Lowell
Diba Industries

--- In vantage@yahoogroups.com, "Cathy" <cathy@...> wrote:
>
> We have Epicor 9, not Vantage.
>
>
>
> Check the field PORel.JobSeqType = 'S'. Hopefully, this has not changed.
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> Mike Abell
> Sent: Wednesday, November 14, 2012 8:40 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Report design problem trying to find open PO's where "Buy
> For" is subcontract in Vantage 8.03
>
>
>
>
>
> Vantage nation,
>
> I'm trying to write a Crystal Report to find subcontract PO's. To find the
> field I went to developer mode, then customization on PO tracker, clicked on
> the "subcontract" field under the Buy For area and it tells me the data
> source is "PODetail" and the data field is "CalcTranType". So far so good.
> However, when I look in Data Dictionary and Crystal ODBC connection to
> PODetail, this field is NOT THERE in PODetail. Can anyone shed some light on
> this as to what exactly is happening? Thanks!
>
> Mike Abell
> Systems Analyst / Network Administrator
> Flexial - BOA Group - Cookeville, Tennessee
> Office: 931.432.1853 ext 302
> Mobile: 615.418.3055
> email: MAbell@... <mailto:MAbell%40flexial.com>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
Vantage nation,

I'm trying to write a Crystal Report to find subcontract PO's. To find the field I went to developer mode, then customization on PO tracker, clicked on the "subcontract" field under the Buy For area and it tells me the data source is "PODetail" and the data field is "CalcTranType". So far so good. However, when I look in Data Dictionary and Crystal ODBC connection to PODetail, this field is NOT THERE in PODetail. Can anyone shed some light on this as to what exactly is happening? Thanks!

Mike Abell
Systems Analyst / Network Administrator
Flexial - BOA Group - Cookeville, Tennessee
Office: 931.432.1853 ext 302
Mobile: 615.418.3055
email: MAbell@...




[Non-text portions of this message have been removed]
3
We have Epicor 9, not Vantage.



Check the field PORel.JobSeqType = 'S'. Hopefully, this has not changed.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mike Abell
Sent: Wednesday, November 14, 2012 8:40 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report design problem trying to find open PO's where "Buy
For" is subcontract in Vantage 8.03





Vantage nation,

I'm trying to write a Crystal Report to find subcontract PO's. To find the
field I went to developer mode, then customization on PO tracker, clicked on
the "subcontract" field under the Buy For area and it tells me the data
source is "PODetail" and the data field is "CalcTranType". So far so good.
However, when I look in Data Dictionary and Crystal ODBC connection to
PODetail, this field is NOT THERE in PODetail. Can anyone shed some light on
this as to what exactly is happening? Thanks!

Mike Abell
Systems Analyst / Network Administrator
Flexial - BOA Group - Cookeville, Tennessee
Office: 931.432.1853 ext 302
Mobile: 615.418.3055
email: MAbell@... <mailto:MAbell%40flexial.com>

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





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