I just got off the phone and a webex with EPicor support. They admit this is a problem because the outerjoin is not working properly. They aren't sure if it's our data or the outerjoin itself.
As for a different tool than BAQ - my current work around will be a BAQ report where the crystal will also include an ODBC (outerjoin) to SHIPTO. The problem is, our company policy is to not use ODBC for normal user reports - so this is a short term solution until Epicor Support gets back with me.
We're at 9.04.506C, There are some known issues with BAQ's specifically with Criteria selection (if you change the criteria, it might delete all the links to your other files is one example)
their next patch 507 scheduled for 11/25 might fix a few of these. Some of my other issues with BAQ's are supposed to be addressed in 9.05.601 (which was just released)- and won't be addressed at the 9.04 level.
Support did say that your best bet, is to make a change. Save it. Exit, and then go back into the BAQ. Very Flakey.
As for a different tool than BAQ - my current work around will be a BAQ report where the crystal will also include an ODBC (outerjoin) to SHIPTO. The problem is, our company policy is to not use ODBC for normal user reports - so this is a short term solution until Epicor Support gets back with me.
We're at 9.04.506C, There are some known issues with BAQ's specifically with Criteria selection (if you change the criteria, it might delete all the links to your other files is one example)
their next patch 507 scheduled for 11/25 might fix a few of these. Some of my other issues with BAQ's are supposed to be addressed in 9.05.601 (which was just released)- and won't be addressed at the 9.04 level.
Support did say that your best bet, is to make a change. Save it. Exit, and then go back into the BAQ. Very Flakey.
--- In vantage@yahoogroups.com, "Nancy" <nhoyt111@...> wrote:
>
> we're on epicor 904.506B; I have had decent success with a single outer join in BAQ query designer, but when I add more than one out-join, it doesn't work . It doesn't provide null recordds from the second outer join recordset. it is as if it ignores the "outer join" setting altogether. I pulled the data out and put it into access to do the sql there, and proved that it wasn't working...
>
> Is there a better way to sql records then using the darn BAQ designer?
>
> --- In vantage@yahoogroups.com, Joe Rojas <jrojas@> wrote:
> >
> > Could you put the BAQ back to how you originally had it and then copy
> > and paste the Query Phase so that we can take a closer look?
> >
> > In theory you're right but to compare 4GL to SQL can be like comparing
> > apples to oranges.
> >
> >
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of pklein256
> > Sent: Thursday, October 07, 2010 1:22 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] BAQ - OuterJoin with Shipto file does not work.
> >
> >
> >
> >
> >
> > I've got a BAQ with an outerjoin to the SHIPTO file that does not return
> > all of the records that it should. I removed the SHIPTO file from the
> > BAQ and got the results I was expecting.. my question for support was -
> > shouldn't an outer join with the shipto file and removing the file from
> > the BAQ produce the same results???
> >
> > the next step I tried... I just created a BAQ over the SHIPTO file
> > itself. The records I was questioning in the previous BAQ were still
> > missing.
> >
> > I wrote an ODBC crystal over the SHIPTO file, and all of the records
> > appeared.
> > So.
> > When I run an ODBC crystal over SHIPTO - I get ALL of the records.
> > When I run a BAQ over SHIPTO - several records are missing.
> >
> > The BAQ is missing 1000 SHIPTO records. Anyone else experience this??
> > This really makes it difficult to analyze your data by SHIPTO/state.
> >
> > Any Ideas?
> >
> > Thanks,
> > Pam
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Joe Rojas | Director of Information Technology | Mats Inc
> > dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> > jrojas@ | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring
> >
> >
> > This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
> >
> >
> > [Non-text portions of this message have been removed]
> >
>