[VANTAGE 8.03.404B] -- BAQ with tables OrderHed, OrderDtl, and C

system · June 30, 2008, 12:05pm

If the user is NOT assigned as an authorized user to any workforce, they
should be able to view all customers.

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
ahmeterispaha
Sent: Monday, June 30, 2008 11:01 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: [VANTAGE 8.03.404B] -- BAQ with tables OrderHed,
OrderDtl, and Customer returns no data

Daniel,

Is it your understanding that if the logged in user is NOT set up as a
Work Force, then the user should be able to pull Customer data from a
BAQ even before Epicor delivers the fix to this bug?

Ahmet Erispaha

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Daniel
Laidig" <daniellaidig@...>
wrote:

>
> This is a reported bug: 50931. They claim it will be fixed in
> 8.03.407. If the user currently logged into Vantage is set up as a
> Work Force, then they MUST be marked as the default authorized user.
> If not, they will not be able to see any customers, quotes, orders
> etc. I worked with support over this issue for a long time before
> they finally recognized it as a bug.
>

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

system · June 23, 2008, 9:49am

When I create a BAQ with tables OrderHed, OrderDtl, and Customer, I get no data.

The problem seems to be with the Customer table because a BAQ with only tables OrderHed and OrderDtl returns reults. However, when I go back to Phrase Builder, add the Customer table, then click the Test button in the Analyze tab, my query results disappear.

The table relations and field relations thet Vantage automatically creates look ok.

Is this a known problem?

Ahmet Erispaha

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

system · June 23, 2008, 9:54am

> When I create a BAQ with tables OrderHed, OrderDtl, and Customer, I get no
> data.

....

> The table relations and field relations thet Vantage automatically creates
> look ok.

Make sure that you're linking with CustNum and not CustID. The CustID is
alphanumeric but all of Vantage uses the numeric CustNum.

Mark W.

system · June 23, 2008, 10:30am

Dear Ahmet:

I have tried to recreate your situation in the manner that you
described. I started with the OrderHed and OrderDtl tables and
Tested; then I added the Customer Table and re-Tested. I get a
dataset everytime.

In my short experience with BAQ's, I have never been able to get the
correct dataset by accepting the table and field relationship that
Vantage automatically creates.

These are the relationships with which I get successful results:

For Parent Table OrderHed (KeyID OrderNum) to Child Table OrderDtl:
OrderHed.Company = OrderDtl.Company
OrderHed.OrderNum = OrderHed.OrderNum

For Parent Table OrderHed (KeyID CustNum) to Child Table Customer:
OrderHed.Company = Customer.Company
OrderHed.CustNum = Customer.CustNum

Lynn

--- In vantage@yahoogroups.com, Ahmet Erispaha <ahmeterispaha@...>
wrote:

>
> When I create a BAQ with tables OrderHed, OrderDtl, and Customer, I

get no data.

>
> The problem seems to be with the Customer table because a BAQ

with only tables OrderHed and OrderDtl returns reults. However, when
I go back to Phrase Builder, add the Customer table, then click the
Test button in the Analyze tab, my query results disappear.

>
> The table relations and field relations thet Vantage

automatically creates look ok.

>
> Is this a known problem?
>
> Ahmet Erispaha
>
>
>
> [Non-text portions of this message have been removed]
>

system · June 23, 2008, 10:35am

Sorry, I made a mis-print.

It should read this:

These are the relationships with which I get successful results:

For Parent Table OrderHed (KeyID OrderNum) to Child Table OrderDtl:
OrderHed.Company = OrderDtl.Company
OrderHed.OrderNum = OrderDtl.OrderNum

For Parent Table OrderHed (KeyID CustNum) to Child Table Customer:
OrderHed.Company = Customer.Company
OrderHed.CustNum = Customer.CustNum

Lynn

--- In vantage@yahoogroups.com, "Lynn" <lynn.khalife@...> wrote:
>
> Dear Ahmet:
>
> I have tried to recreate your situation in the manner that you
> described. I started with the OrderHed and OrderDtl tables and
> Tested; then I added the Customer Table and re-Tested. I get a
> dataset everytime.
>
> In my short experience with BAQ's, I have never been able to get
the
> correct dataset by accepting the table and field relationship that
> Vantage automatically creates.
>
> These are the relationships with which I get successful results:
>
> For Parent Table OrderHed (KeyID OrderNum) to Child Table OrderDtl:
> OrderHed.Company = OrderDtl.Company
> OrderHed.OrderNum = OrderHed.OrderNum
>
> For Parent Table OrderHed (KeyID CustNum) to Child Table Customer:
> OrderHed.Company = Customer.Company
> OrderHed.CustNum = Customer.CustNum
>
> Lynn
>
>
> --- In vantage@yahoogroups.com, Ahmet Erispaha <ahmeterispaha@>
> wrote:
> >
> > When I create a BAQ with tables OrderHed, OrderDtl, and Customer,
I
> get no data.
> >
> > The problem seems to be with the Customer table because a BAQ
> with only tables OrderHed and OrderDtl returns reults. However,
when
> I go back to Phrase Builder, add the Customer table, then click the
> Test button in the Analyze tab, my query results disappear.
> >
> > The table relations and field relations thet Vantage
> automatically creates look ok.
> >
> > Is this a known problem?
> >
> > Ahmet Erispaha
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>

system · June 23, 2008, 11:06am

Vantage automatically links OrderHed and customer on CustNum. I'm not changing this.

Mark Wonsil <mark_wonsil@...> wrote: > When I create a BAQ with tables OrderHed, OrderDtl, and Customer, I get no

> data.

....

> The table relations and field relations thet Vantage automatically creates
> look ok.

Make sure that you're linking with CustNum and not CustID. The CustID is
alphanumeric but all of Vantage uses the numeric CustNum.

Mark W.

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

system · June 23, 2008, 11:18am

Hi Lynn,

Here are some more details.

1. I select the OrderHed, OrderDtl, and Customer tables (in that order).
2. The Table Relations dialog indicates that Vantage has chosen to link a) OrderHed to OrderDtl on Company and OrderNum; and b) OrderHed to Customer on Company and CustNum. These default table and field relationships look reasonable to me. Would you agree?
3. This is the Query Phrase that Vantage generates:
for each OrderHed no-lock , each OrderDtl where (OrderHed.Company = OrderDtl.Company and OrderHed.OrderNum = OrderDtl.OrderNum) no-lock , each Customer where (OrderHed.Company = Customer.Company and OrderHed.CustNum = Customer.CustNum) no-lock

Can you post the Query Phrase that you're getting for comparison?

Thanks,

Ahmet

Lynn <lynn.khalife@...> wrote:
Sorry, I made a mis-print.

It should read this:

These are the relationships with which I get successful results:

For Parent Table OrderHed (KeyID OrderNum) to Child Table OrderDtl:
OrderHed.Company = OrderDtl.Company
OrderHed.OrderNum = OrderDtl.OrderNum

For Parent Table OrderHed (KeyID CustNum) to Child Table Customer:
OrderHed.Company = Customer.Company
OrderHed.CustNum = Customer.CustNum

Lynn

--- In vantage@yahoogroups.com, "Lynn" <lynn.khalife@...> wrote:
>
> Dear Ahmet:
>
> I have tried to recreate your situation in the manner that you
> described. I started with the OrderHed and OrderDtl tables and
> Tested; then I added the Customer Table and re-Tested. I get a
> dataset everytime.
>
> In my short experience with BAQ's, I have never been able to get
the
> correct dataset by accepting the table and field relationship that
> Vantage automatically creates.
>
> These are the relationships with which I get successful results:
>
> For Parent Table OrderHed (KeyID OrderNum) to Child Table OrderDtl:
> OrderHed.Company = OrderDtl.Company
> OrderHed.OrderNum = OrderHed.OrderNum
>
> For Parent Table OrderHed (KeyID CustNum) to Child Table Customer:
> OrderHed.Company = Customer.Company
> OrderHed.CustNum = Customer.CustNum
>
> Lynn
>
>
> --- In vantage@yahoogroups.com, Ahmet Erispaha <ahmeterispaha@>
> wrote:
> >
> > When I create a BAQ with tables OrderHed, OrderDtl, and Customer,
I
> get no data.
> >
> > The problem seems to be with the Customer table because a BAQ
> with only tables OrderHed and OrderDtl returns reults. However,
when
> I go back to Phrase Builder, add the Customer table, then click the
> Test button in the Analyze tab, my query results disappear.
> >
> > The table relations and field relations thet Vantage
> automatically creates look ok.
> >
> > Is this a known problem?
> >
> > Ahmet Erispaha
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>

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

system · June 23, 2008, 12:05pm

Always use CustNum. Especially since CustID doesn't exist anywhere but
in the Customer table.

I will, however, bring in CustID once joined. I have had better results
(performance) filtering on Customer.CustID versus Customer.CustNum.

And, sometimes the BAQ Report Designer's filtering options won't filter
on CustNum, so it's always nice to have CustID included, too.

Vic

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ahmet Erispaha
Sent: Monday, June 23, 2008 11:07 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] [VANTAGE 8.03.404B] -- BAQ with tables OrderHed,
OrderDtl, and Customer returns no data

Vantage automatically links OrderHed and customer on CustNum. I'm not
changing this.

Mark Wonsil <mark_wonsil@... <mailto:mark_wonsil%40yahoo.com> >
wrote: > When I create a BAQ with tables OrderHed, OrderDtl, and
Customer, I get no

> data.

....

> The table relations and field relations thet Vantage automatically

creates

> look ok.

Make sure that you're linking with CustNum and not CustID. The CustID is
alphanumeric but all of Vantage uses the numeric CustNum.

Mark W.

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

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

system · June 23, 2008, 1:22pm

Yes, I agree. The steps you list are exactly what I did when I
attempted to recreate your problem. Here is my Query Phrase. It
looks exactly like yours. I am puzzled as to why I get good data and
you do not.

for each OrderHed no-lock , each OrderDtl where (OrderHed.Company =
OrderDtl.Company and OrderHed.OrderNum = OrderDtl.OrderNum) no-lock ,
each Customer where (OrderHed.Company = Customer.Company and
OrderHed.CustNum = Customer.CustNum) no-lock by Customer.Name by
OrderHed.CustNum by OrderDtl.OrderNum by OrderDtl.OrderLine.

My next suggestion comes from another Vantage user who suggested this
to me last week. He & I have both had experience where something in
Vantage just won't work no matter what. So, we start again
completely from scratch with the *EXACT* same settings. And, viola,
for some reason, the newly-created-from-scratch query works!

Lynn

--- In vantage@yahoogroups.com, Ahmet Erispaha <ahmeterispaha@...>
wrote:

>
> Hi Lynn,
>
> Here are some more details.
>
> 1. I select the OrderHed, OrderDtl, and Customer tables (in that

order).

> 2. The Table Relations dialog indicates that Vantage has chosen

to link a) OrderHed to OrderDtl on Company and OrderNum; and b)
OrderHed to Customer on Company and CustNum. These default table and
field relationships look reasonable to me. Would you agree?

> 3. This is the Query Phrase that Vantage generates:
> for each OrderHed no-lock , each OrderDtl where (OrderHed.Company

= OrderDtl.Company and OrderHed.OrderNum = OrderDtl.OrderNum) no-
lock , each Customer where (OrderHed.Company = Customer.Company and
OrderHed.CustNum = Customer.CustNum) no-lock

>
> Can you post the Query Phrase that you're getting for comparison?
>
> Thanks,
>
> Ahmet
>
> Lynn <lynn.khalife@...> wrote:
> Sorry, I made a mis-print.
>
> It should read this:
>
> These are the relationships with which I get successful results:
>
> For Parent Table OrderHed (KeyID OrderNum) to Child Table OrderDtl:
> OrderHed.Company = OrderDtl.Company
> OrderHed.OrderNum = OrderDtl.OrderNum
>
> For Parent Table OrderHed (KeyID CustNum) to Child Table Customer:
> OrderHed.Company = Customer.Company
> OrderHed.CustNum = Customer.CustNum
>
> Lynn
>
> --- In vantage@yahoogroups.com, "Lynn" <lynn.khalife@> wrote:
> >
> > Dear Ahmet:
> >
> > I have tried to recreate your situation in the manner that you
> > described. I started with the OrderHed and OrderDtl tables and
> > Tested; then I added the Customer Table and re-Tested. I get a
> > dataset everytime.
> >
> > In my short experience with BAQ's, I have never been able to get
> the
> > correct dataset by accepting the table and field relationship

that

> > Vantage automatically creates.
> >
> > These are the relationships with which I get successful results:
> >
> > For Parent Table OrderHed (KeyID OrderNum) to Child Table

OrderDtl:

> > OrderHed.Company = OrderDtl.Company
> > OrderHed.OrderNum = OrderHed.OrderNum
> >
> > For Parent Table OrderHed (KeyID CustNum) to Child Table Customer:
> > OrderHed.Company = Customer.Company
> > OrderHed.CustNum = Customer.CustNum
> >
> > Lynn
> >
> >
> > --- In vantage@yahoogroups.com, Ahmet Erispaha <ahmeterispaha@>
> > wrote:
> > >
> > > When I create a BAQ with tables OrderHed, OrderDtl, and

Customer,

> I
> > get no data.
> > >
> > > The problem seems to be with the Customer table because a BAQ
> > with only tables OrderHed and OrderDtl returns reults. However,
> when
> > I go back to Phrase Builder, add the Customer table, then click

the

> > Test button in the Analyze tab, my query results disappear.
> > >
> > > The table relations and field relations thet Vantage
> > automatically creates look ok.
> > >
> > > Is this a known problem?
> > >
> > > Ahmet Erispaha
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · June 23, 2008, 2:15pm

Hi Lynn,

What version of Vantage are you on?

Ahmet

Lynn <lynn.khalife@...> wrote:
Sorry, I made a mis-print.

It should read this:

These are the relationships with which I get successful results:

For Parent Table OrderHed (KeyID OrderNum) to Child Table OrderDtl:
OrderHed.Company = OrderDtl.Company
OrderHed.OrderNum = OrderDtl.OrderNum

For Parent Table OrderHed (KeyID CustNum) to Child Table Customer:
OrderHed.Company = Customer.Company
OrderHed.CustNum = Customer.CustNum

Lynn

--- In vantage@yahoogroups.com, "Lynn" <lynn.khalife@...> wrote:
>
> Dear Ahmet:
>
> I have tried to recreate your situation in the manner that you
> described. I started with the OrderHed and OrderDtl tables and
> Tested; then I added the Customer Table and re-Tested. I get a
> dataset everytime.
>
> In my short experience with BAQ's, I have never been able to get
the
> correct dataset by accepting the table and field relationship that
> Vantage automatically creates.
>
> These are the relationships with which I get successful results:
>
> For Parent Table OrderHed (KeyID OrderNum) to Child Table OrderDtl:
> OrderHed.Company = OrderDtl.Company
> OrderHed.OrderNum = OrderHed.OrderNum
>
> For Parent Table OrderHed (KeyID CustNum) to Child Table Customer:
> OrderHed.Company = Customer.Company
> OrderHed.CustNum = Customer.CustNum
>
> Lynn
>
>
> --- In vantage@yahoogroups.com, Ahmet Erispaha <ahmeterispaha@>
> wrote:
> >
> > When I create a BAQ with tables OrderHed, OrderDtl, and Customer,
I
> get no data.
> >
> > The problem seems to be with the Customer table because a BAQ
> with only tables OrderHed and OrderDtl returns reults. However,
when
> I go back to Phrase Builder, add the Customer table, then click the
> Test button in the Analyze tab, my query results disappear.
> >
> > The table relations and field relations thet Vantage
> automatically creates look ok.
> >
> > Is this a known problem?
> >
> > Ahmet Erispaha
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>

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

system · June 23, 2008, 2:24pm

Vantage 8.03.404

--- In vantage@yahoogroups.com, Ahmet Erispaha <ahmeterispaha@...>
wrote:

>
> Hi Lynn,
>
> What version of Vantage are you on?
>
> Ahmet
>
> Lynn <lynn.khalife@...> wrote:
> Sorry, I made a mis-print.
>
> It should read this:
>
> These are the relationships with which I get successful results:
>
> For Parent Table OrderHed (KeyID OrderNum) to Child Table OrderDtl:
> OrderHed.Company = OrderDtl.Company
> OrderHed.OrderNum = OrderDtl.OrderNum
>
> For Parent Table OrderHed (KeyID CustNum) to Child Table Customer:
> OrderHed.Company = Customer.Company
> OrderHed.CustNum = Customer.CustNum
>
> Lynn
>
> --- In vantage@yahoogroups.com, "Lynn" <lynn.khalife@> wrote:
> >
> > Dear Ahmet:
> >
> > I have tried to recreate your situation in the manner that you
> > described. I started with the OrderHed and OrderDtl tables and
> > Tested; then I added the Customer Table and re-Tested. I get a
> > dataset everytime.
> >
> > In my short experience with BAQ's, I have never been able to get
> the
> > correct dataset by accepting the table and field relationship

that

> > Vantage automatically creates.
> >
> > These are the relationships with which I get successful results:
> >
> > For Parent Table OrderHed (KeyID OrderNum) to Child Table

OrderDtl:

> > OrderHed.Company = OrderDtl.Company
> > OrderHed.OrderNum = OrderHed.OrderNum
> >
> > For Parent Table OrderHed (KeyID CustNum) to Child Table Customer:
> > OrderHed.Company = Customer.Company
> > OrderHed.CustNum = Customer.CustNum
> >
> > Lynn
> >
> >
> > --- In vantage@yahoogroups.com, Ahmet Erispaha <ahmeterispaha@>
> > wrote:
> > >
> > > When I create a BAQ with tables OrderHed, OrderDtl, and

Customer,

> I
> > get no data.
> > >
> > > The problem seems to be with the Customer table because a BAQ
> > with only tables OrderHed and OrderDtl returns reults. However,
> when
> > I go back to Phrase Builder, add the Customer table, then click

the

> > Test button in the Analyze tab, my query results disappear.
> > >
> > > The table relations and field relations thet Vantage
> > automatically creates look ok.
> > >
> > > Is this a known problem?
> > >
> > > Ahmet Erispaha
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · June 23, 2008, 2:55pm

We're on 8.03.404B.

By the way, I tried recreating the BAQ from scratch and got the same results.

I opened a ticked with Epicor support to see if they can help.

Thanks, all, for the reponses.

Ahmet Erispaha

Lynn <lynn.khalife@...> wrote:
Vantage 8.03.404

--- In vantage@yahoogroups.com, Ahmet Erispaha <ahmeterispaha@...>
wrote:

>
> Hi Lynn,
>
> What version of Vantage are you on?
>
> Ahmet
>
> Lynn <lynn.khalife@...> wrote:
> Sorry, I made a mis-print.
>
> It should read this:
>
> These are the relationships with which I get successful results:
>
> For Parent Table OrderHed (KeyID OrderNum) to Child Table OrderDtl:
> OrderHed.Company = OrderDtl.Company
> OrderHed.OrderNum = OrderDtl.OrderNum
>
> For Parent Table OrderHed (KeyID CustNum) to Child Table Customer:
> OrderHed.Company = Customer.Company
> OrderHed.CustNum = Customer.CustNum
>
> Lynn
>
> --- In vantage@yahoogroups.com, "Lynn" <lynn.khalife@> wrote:
> >
> > Dear Ahmet:
> >
> > I have tried to recreate your situation in the manner that you
> > described. I started with the OrderHed and OrderDtl tables and
> > Tested; then I added the Customer Table and re-Tested. I get a
> > dataset everytime.
> >
> > In my short experience with BAQ's, I have never been able to get
> the
> > correct dataset by accepting the table and field relationship

that

> > Vantage automatically creates.
> >
> > These are the relationships with which I get successful results:
> >
> > For Parent Table OrderHed (KeyID OrderNum) to Child Table

OrderDtl:

> > OrderHed.Company = OrderDtl.Company
> > OrderHed.OrderNum = OrderHed.OrderNum
> >
> > For Parent Table OrderHed (KeyID CustNum) to Child Table Customer:
> > OrderHed.Company = Customer.Company
> > OrderHed.CustNum = Customer.CustNum
> >
> > Lynn
> >
> >
> > --- In vantage@yahoogroups.com, Ahmet Erispaha <ahmeterispaha@>
> > wrote:
> > >
> > > When I create a BAQ with tables OrderHed, OrderDtl, and

Customer,

> I
> > get no data.
> > >
> > > The problem seems to be with the Customer table because a BAQ
> > with only tables OrderHed and OrderDtl returns reults. However,
> when
> > I go back to Phrase Builder, add the Customer table, then click

the

> > Test button in the Analyze tab, my query results disappear.
> > >
> > > The table relations and field relations thet Vantage
> > automatically creates look ok.
> > >
> > > Is this a known problem?
> > >
> > > Ahmet Erispaha
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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

system · June 25, 2008, 8:12am

Are you on Progress or SQL Server DB?Â I've heard there is a problem with BAQs on 8.03.404BÂ with SQL Server.
Â
Anyone else experiencing BAQ problems on 8.03.404B with SQL Server DB?

--- On Mon, 6/23/08, Lynn <lynn.khalife@...> wrote:

From: Lynn <lynn.khalife@...>
Subject: [Vantage] Re: [VANTAGE 8.03.404B] -- BAQ with tables OrderHed, OrderDtl, and Customer returns no data
To: vantage@yahoogroups.com
Date: Monday, June 23, 2008, 2:24 PM

Vantage 8.03.404

--- In vantage@yahoogroups .com, Ahmet Erispaha <ahmeterispaha@ ...>
wrote:
>
> Hi Lynn,
>
> What version of Vantage are you on?
>
> Ahmet
>
> Lynn <lynn.khalife@ ...> wrote:
> Sorry, I made a mis-print.
>
> It should read this:
>
> These are the relationships with which I get successful results:
>
> For Parent Table OrderHed (KeyID OrderNum) to Child Table OrderDtl:
> OrderHed.Company = OrderDtl.Company
> OrderHed.OrderNum = OrderDtl.OrderNum
>
> For Parent Table OrderHed (KeyID CustNum) to Child Table Customer:
> OrderHed.Company = Customer.Company
> OrderHed.CustNum = Customer.CustNum
>
> Lynn
>
> --- In vantage@yahoogroups .com, "Lynn" <lynn.khalife@ > wrote:
> >
> > Dear Ahmet:
> >
> > I have tried to recreate your situation in the manner that you
> > described. I started with the OrderHed and OrderDtl tables and
> > Tested; then I added the Customer Table and re-Tested. I get a
> > dataset everytime.
> >
> > In my short experience with BAQ's, I have never been able to get
> the
> > correct dataset by accepting the table and field relationship
that
> > Vantage automatically creates.
> >
> > These are the relationships with which I get successful results:
> >
> > For Parent Table OrderHed (KeyID OrderNum) to Child Table
OrderDtl:
> > OrderHed.Company = OrderDtl.Company
> > OrderHed.OrderNum = OrderHed.OrderNum
> >
> > For Parent Table OrderHed (KeyID CustNum) to Child Table Customer:
> > OrderHed.Company = Customer.Company
> > OrderHed.CustNum = Customer.CustNum
> >
> > Lynn
> >
> >
> > --- In vantage@yahoogroups .com, Ahmet Erispaha <ahmeterispaha@ >
> > wrote:
> > >
> > > When I create a BAQ with tables OrderHed, OrderDtl, and
Customer,
> I
> > get no data.
> > >
> > > The problem seems to be with the Customer table because a BAQ
> > with only tables OrderHed and OrderDtl returns reults. However,
> when
> > I go back to Phrase Builder, add the Customer table, then click
the
> > Test button in the Analyze tab, my query results disappear.
> > >
> > > The table relations and field relations thet Vantage
> > automatically creates look ok.
> > >
> > > Is this a known problem?
> > >
> > > Ahmet Erispaha
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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

system · June 25, 2008, 8:12am

Lynn,
Â
Are you on Progress or SQL Server DB?Â I've heard there is a problem with BAQs on 8.03.404BÂ with SQL Server.
Â
Anyone else experiencing BAQ problems on 8.03.404B with SQL Server DB?

--- On Mon, 6/23/08, Lynn <lynn.khalife@...> wrote:

From: Lynn <lynn.khalife@...>
Subject: [Vantage] Re: [VANTAGE 8.03.404B] -- BAQ with tables OrderHed, OrderDtl, and Customer returns no data
To: vantage@yahoogroups.com
Date: Monday, June 23, 2008, 2:24 PM

Vantage 8.03.404

--- In vantage@yahoogroups .com, Ahmet Erispaha <ahmeterispaha@ ...>
wrote:
>
> Hi Lynn,
>
> What version of Vantage are you on?
>
> Ahmet
>
> Lynn <lynn.khalife@ ...> wrote:
> Sorry, I made a mis-print.
>
> It should read this:
>
> These are the relationships with which I get successful results:
>
> For Parent Table OrderHed (KeyID OrderNum) to Child Table OrderDtl:
> OrderHed.Company = OrderDtl.Company
> OrderHed.OrderNum = OrderDtl.OrderNum
>
> For Parent Table OrderHed (KeyID CustNum) to Child Table Customer:
> OrderHed.Company = Customer.Company
> OrderHed.CustNum = Customer.CustNum
>
> Lynn
>
> --- In vantage@yahoogroups .com, "Lynn" <lynn.khalife@ > wrote:
> >
> > Dear Ahmet:
> >
> > I have tried to recreate your situation in the manner that you
> > described. I started with the OrderHed and OrderDtl tables and
> > Tested; then I added the Customer Table and re-Tested. I get a
> > dataset everytime.
> >
> > In my short experience with BAQ's, I have never been able to get
> the
> > correct dataset by accepting the table and field relationship
that
> > Vantage automatically creates.
> >
> > These are the relationships with which I get successful results:
> >
> > For Parent Table OrderHed (KeyID OrderNum) to Child Table
OrderDtl:
> > OrderHed.Company = OrderDtl.Company
> > OrderHed.OrderNum = OrderHed.OrderNum
> >
> > For Parent Table OrderHed (KeyID CustNum) to Child Table Customer:
> > OrderHed.Company = Customer.Company
> > OrderHed.CustNum = Customer.CustNum
> >
> > Lynn
> >
> >
> > --- In vantage@yahoogroups .com, Ahmet Erispaha <ahmeterispaha@ >
> > wrote:
> > >
> > > When I create a BAQ with tables OrderHed, OrderDtl, and
Customer,
> I
> > get no data.
> > >
> > > The problem seems to be with the Customer table because a BAQ
> > with only tables OrderHed and OrderDtl returns reults. However,
> when
> > I go back to Phrase Builder, add the Customer table, then click
the
> > Test button in the Analyze tab, my query results disappear.
> > >
> > > The table relations and field relations thet Vantage
> > automatically creates look ok.
> > >
> > > Is this a known problem?
> > >
> > > Ahmet Erispaha
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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

system · June 25, 2008, 9:19am

Dear Ahmet:

Vantage 8.03.404 on Progress DB.

Is it possible that the DB (SQL Server vs. Progress) is why this BAQ
works for me, but not for you?

Lynn

--- In vantage@yahoogroups.com, Ahmet Erispaha <ahmeterispaha@...>
wrote:

>
> Lynn,
> Â
> Are you on Progress or SQL Server DB?Â I've heard there is a

problem with BAQs on 8.03.404BÂ with SQL Server.

> Â
> Anyone else experiencing BAQ problems on 8.03.404B with SQL Server

DB?

>
>
> --- On Mon, 6/23/08, Lynn <lynn.khalife@...> wrote:
>
> From: Lynn <lynn.khalife@...>
> Subject: [Vantage] Re: [VANTAGE 8.03.404B] -- BAQ with tables

OrderHed, OrderDtl, and Customer returns no data

> To: vantage@yahoogroups.com
> Date: Monday, June 23, 2008, 2:24 PM
>
>
>
>
>
>
> Vantage 8.03.404
>
> --- In vantage@yahoogroups .com, Ahmet Erispaha

<ahmeterispaha@ ...>

> wrote:
> >
> > Hi Lynn,
> >
> > What version of Vantage are you on?
> >
> > Ahmet
> >
> > Lynn <lynn.khalife@ ...> wrote:
> > Sorry, I made a mis-print.
> >
> > It should read this:
> >
> > These are the relationships with which I get successful results:
> >
> > For Parent Table OrderHed (KeyID OrderNum) to Child Table

OrderDtl:

> > OrderHed.Company = OrderDtl.Company
> > OrderHed.OrderNum = OrderDtl.OrderNum
> >
> > For Parent Table OrderHed (KeyID CustNum) to Child Table Customer:
> > OrderHed.Company = Customer.Company
> > OrderHed.CustNum = Customer.CustNum
> >
> > Lynn
> >
> > --- In vantage@yahoogroups .com, "Lynn" <lynn.khalife@ > wrote:
> > >
> > > Dear Ahmet:
> > >
> > > I have tried to recreate your situation in the manner that you
> > > described. I started with the OrderHed and OrderDtl tables and
> > > Tested; then I added the Customer Table and re-Tested. I get a
> > > dataset everytime.
> > >
> > > In my short experience with BAQ's, I have never been able to

get

> > the
> > > correct dataset by accepting the table and field relationship
> that
> > > Vantage automatically creates.
> > >
> > > These are the relationships with which I get successful results:
> > >
> > > For Parent Table OrderHed (KeyID OrderNum) to Child Table
> OrderDtl:
> > > OrderHed.Company = OrderDtl.Company
> > > OrderHed.OrderNum = OrderHed.OrderNum
> > >
> > > For Parent Table OrderHed (KeyID CustNum) to Child Table

Customer:

> > > OrderHed.Company = Customer.Company
> > > OrderHed.CustNum = Customer.CustNum
> > >
> > > Lynn
> > >
> > >
> > > --- In vantage@yahoogroups .com, Ahmet Erispaha <ahmeterispaha@
>
> > > wrote:
> > > >
> > > > When I create a BAQ with tables OrderHed, OrderDtl, and
> Customer,
> > I
> > > get no data.
> > > >
> > > > The problem seems to be with the Customer table because a BAQ
> > > with only tables OrderHed and OrderDtl returns reults. However,
> > when
> > > I go back to Phrase Builder, add the Customer table, then click
> the
> > > Test button in the Analyze tab, my query results disappear.
> > > >
> > > > The table relations and field relations thet Vantage
> > > automatically creates look ok.
> > > >
> > > > Is this a known problem?
> > > >
> > > > Ahmet Erispaha
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · June 25, 2008, 12:39pm

According to Epicor support, SQL Server v.s. Progress is not the issue.
Â
They said in order for me to see results of a BAQ that references Customer, my user id needs to be set up in CRM with the "View all territories" box checked.Â It sounded strange that I would need to do this even though I'm not a salesperson, butÂ we went ahead and did it anyway.Â Result: no change.Â When I query on the Customer table, I get the column headings but no data.
Â
This appears to have happened when weÂ migrated to 8.03.404B.Â Â
Â
Anybody see this before?
Â
Thanks,
Â
Ahmet Erispaha

--- On Mon, 6/23/08, Lynn <lynn.khalife@...> wrote:

From: Lynn <lynn.khalife@...>
Subject: [Vantage] Re: [VANTAGE 8.03.404B] -- BAQ with tables OrderHed, OrderDtl, and Customer returns no data
To: vantage@yahoogroups.com
Date: Monday, June 23, 2008, 2:24 PM

Vantage 8.03.404

--- In vantage@yahoogroups .com, Ahmet Erispaha <ahmeterispaha@ ...>
wrote:
>
> Hi Lynn,
>
> What version of Vantage are you on?
>
> Ahmet
>
> Lynn <lynn.khalife@ ...> wrote:
> Sorry, I made a mis-print.
>
> It should read this:
>
> These are the relationships with which I get successful results:
>
> For Parent Table OrderHed (KeyID OrderNum) to Child Table OrderDtl:
> OrderHed.Company = OrderDtl.Company
> OrderHed.OrderNum = OrderDtl.OrderNum
>
> For Parent Table OrderHed (KeyID CustNum) to Child Table Customer:
> OrderHed.Company = Customer.Company
> OrderHed.CustNum = Customer.CustNum
>
> Lynn
>
> --- In vantage@yahoogroups .com, "Lynn" <lynn.khalife@ > wrote:
> >
> > Dear Ahmet:
> >
> > I have tried to recreate your situation in the manner that you
> > described. I started with the OrderHed and OrderDtl tables and
> > Tested; then I added the Customer Table and re-Tested. I get a
> > dataset everytime.
> >
> > In my short experience with BAQ's, I have never been able to get
> the
> > correct dataset by accepting the table and field relationship
that
> > Vantage automatically creates.
> >
> > These are the relationships with which I get successful results:
> >
> > For Parent Table OrderHed (KeyID OrderNum) to Child Table
OrderDtl:
> > OrderHed.Company = OrderDtl.Company
> > OrderHed.OrderNum = OrderHed.OrderNum
> >
> > For Parent Table OrderHed (KeyID CustNum) to Child Table Customer:
> > OrderHed.Company = Customer.Company
> > OrderHed.CustNum = Customer.CustNum
> >
> > Lynn
> >
> >
> > --- In vantage@yahoogroups .com, Ahmet Erispaha <ahmeterispaha@ >
> > wrote:
> > >
> > > When I create a BAQ with tables OrderHed, OrderDtl, and
Customer,
> I
> > get no data.
> > >
> > > The problem seems to be with the Customer table because a BAQ
> > with only tables OrderHed and OrderDtl returns reults. However,
> when
> > I go back to Phrase Builder, add the Customer table, then click
the
> > Test button in the Analyze tab, my query results disappear.
> > >
> > > The table relations and field relations thet Vantage
> > automatically creates look ok.
> > >
> > > Is this a known problem?
> > >
> > > Ahmet Erispaha
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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

system · June 25, 2008, 1:11pm

Hi Ahmet,

> They said in order for me to see results of a BAQ that references
> Customer, my user id needs to be set up in CRM with the "View all
> territories" box checked. It sounded strange that I would need to do this
> even though I'm not a salesperson, but we went ahead and did it anyway.
> Result: no change. When I query on the Customer table, I get the column
> headings but no data.

We are experiencing something similar since going to 404B. All of the
sudden, our oldest inside sales manager cannot see Quotes. If we add her as
an Authorized User to the Work Force (for each sales person) she can see
them BUT the existing owner of the Quote cannot. Still working on it, so it
may or may not be related.

Mark W.

system · June 30, 2008, 8:59am

This is a reported bug: 50931. They claim it will be fixed in
8.03.407. If the user currently logged into Vantage is set up as a
Work Force, then they MUST be marked as the default authorized user.
If not, they will not be able to see any customers, quotes, orders
etc. I worked with support over this issue for a long time before
they finally recognized it as a bug.

--- In vantage@yahoogroups.com, "Mark Wonsil" <mark_wonsil@...> wrote:
>
> Hi Ahmet,
>
> > They said in order for me to see results of a BAQ that references
> > Customer, my user id needs to be set up in CRM with the "View all
> > territories" box checked. It sounded strange that I would need to
do this
> > even though I'm not a salesperson, but we went ahead and did it
anyway.
> > Result: no change. When I query on the Customer table, I get the
column
> > headings but no data.
>
> We are experiencing something similar since going to 404B. All of the
> sudden, our oldest inside sales manager cannot see Quotes. If we add
her as
> an Authorized User to the Work Force (for each sales person) she can see
> them BUT the existing owner of the Quote cannot. Still working on
it, so it
> may or may not be related.
>
> Mark W.
>

system · June 30, 2008, 11:00am

Daniel,

Is it your understanding that if the logged in user is NOT set up as a
Work Force, then the user should be able to pull Customer data from a
BAQ even before Epicor delivers the fix to this bug?

Ahmet Erispaha

--- In vantage@yahoogroups.com, "Daniel Laidig" <daniellaidig@...>
wrote:

>
> This is a reported bug: 50931. They claim it will be fixed in
> 8.03.407. If the user currently logged into Vantage is set up as a
> Work Force, then they MUST be marked as the default authorized user.
> If not, they will not be able to see any customers, quotes, orders
> etc. I worked with support over this issue for a long time before
> they finally recognized it as a bug.
>

Topic		Replies	Views
BAQ Missing Data Yahoo Archive	4	693	February 22, 2010
BAQ Help Blank Title 57176 Yahoo Archive	33	982	September 25, 2014
QuoteHed Missing Records Yahoo Archive	3	443	November 18, 2014
E10: Tracing a bad BAQ Yahoo Archive	6	738	June 23, 2015
Fields not available for Filter in Report Yahoo Archive	1	279	July 13, 2009

[VANTAGE 8.03.404B] -- BAQ with tables OrderHed, OrderDtl, and C

Related Topics