V8 to E9 BAQ Questions

[system]

Its under system mananagement/utilities. You create an id for your solution and when you save it automatically brings in and displays all RDD, BAQ,s Dashboards, etc., You can then decide which ones you want to maintain for that particular solution manager ID

--- On Tue, 4/27/10, Chris Thompson <chriselectrix@...> wrote:


From: Chris Thompson <chriselectrix@...>
Subject: Re: [Vantage] V8 to E9 BAQ Questions
To: vantage@yahoogroups.com
Date: Tuesday, April 27, 2010, 4:13 AM


Â



Do you have any more information on the solutions manager?

Is it in a sub-menu?

Thanks,

CHRIS THOMPSON

____________ _________ _________ __
From: Mark Wagner <mjfw2003@yahoo. com>
To: vantage@yahoogroups .com
Sent: Tue, 27 April, 2010 2:10:29
Subject: RE: [Vantage] V8 to E9 BAQ Questions

Â
Joe, if you are just getting into E9, check out the Solutions Manager as well. They added it around 9.04 and it allows you to now transfer data definitions in additions to dashboards, BAQs, etc betwen databases. Not well publicized but finally added in E9. Look under systems management and you will see it

--- On Mon, 4/26/10, Joe Rojas <jrojas@matsinc. com> wrote:

From: Joe Rojas <jrojas@matsinc. com>
Subject: RE: [Vantage] V8 to E9 BAQ Questions
To: vantage@yahoogroups .com
Date: Monday, April 26, 2010, 8:41 PM

Â

Sheesh. So simple. I just tried it and I got the same results.

I was so fixated on how it worked in V8, I just assumed it was broke. :)

Thanks Scott.

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of sysadmin@mercuryele ctronics. com
Sent: Monday, April 26, 2010 6:54 PM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] V8 to E9 BAQ Questions

We are using 9.04.506a also. Fwiw, if I open BAQ Designer, enter an
unrecognized value into the Query ID field and press tab, the app
immediately prefixes our company ID on the value and displays a "Record
not
found. Add new?" prompt.

Regards,
Scott

_____

From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
[mailto:vantage@ yahoogroups .com <mailto:vantage% 40yahoogroups. com> ] On
Behalf Of
Mark Wagner
Sent: Monday, April 26, 2010 5:16 PM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Subject: Re: [Vantage] V8 to E9 BAQ Questions

I was told that too by Epicor support, but am so used to putting it in
there
that I havent tried without it. They said if you create the query ID and
description and click save it should add the company identifier in the
beginning but havent seen it work yet

--- On Mon, 4/26/10, Joe Rojas <jrojas@matsinc.
<mailto:jrojas% 40matsinc. com> com> wrote:

From: Joe Rojas <jrojas@matsinc. <mailto:jrojas% 40matsinc. com> com>
Subject: [Vantage] V8 to E9 BAQ Questions
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Date: Monday, April 26, 2010, 2:24 PM

E9.04.506A

In V8, when creating a BAQ, the Company ID would automatically populate
in the ID field and I believe that this was a requirement when creating
BAQs, the ID must be prefixed with the company ID.

When I create a BAQ in E9, the company ID does not auto populate. Does
this mean that it is not required in E9 or is it required but is a know
bug?

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@matsinc. com | www.matsinc. com Ask us about our clean, green and
beautiful matting and flooring

[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]

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











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

[system]

E9.04.506A



In V8, when creating a BAQ, the Company ID would automatically populate
in the ID field and I believe that this was a requirement when creating
BAQs, the ID must be prefixed with the company ID.

When I create a BAQ in E9, the company ID does not auto populate. Does
this mean that it is not required in E9 or is it required but is a know
bug?










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
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]

[system]

I don't know if it's a bug or not but it would be recommended to include all applicable indexes in the joins. While technically it shouldn't matter in a single company setup, I have seen different query results with and without company in the joins. :shrug:

--- In vantage@yahoogroups.com, Joe Rojas <jrojas@...> wrote:
>
> E9.04.506A
>
>
>
> In V8, when creating a BAQ, the Company ID would automatically populate
> in the ID field and I believe that this was a requirement when creating
> BAQs, the ID must be prefixed with the company ID.
>
> When I create a BAQ in E9, the company ID does not auto populate. Does
> this mean that it is not required in E9 or is it required but is a know
> bug?
>
>
>
>
>
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
> 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]
>

[system]

I was told that too by Epicor support, but am so used to putting it in there that I havent tried without it. They said if you create the query ID and description and click save it should add the company identifier in the beginning but havent seen it work yet

--- On Mon, 4/26/10, Joe Rojas <jrojas@...> wrote:


From: Joe Rojas <jrojas@...>
Subject: [Vantage] V8 to E9 BAQ Questions
To: vantage@yahoogroups.com
Date: Monday, April 26, 2010, 2:24 PM


Â



E9.04.506A

In V8, when creating a BAQ, the Company ID would automatically populate
in the ID field and I believe that this was a requirement when creating
BAQs, the ID must be prefixed with the company ID.

When I create a BAQ in E9, the company ID does not auto populate. Does
this mean that it is not required in E9 or is it required but is a know
bug?







Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@matsinc. com | 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]











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

[system]

We are using 9.04.506a also. Fwiw, if I open BAQ Designer, enter an
unrecognized value into the Query ID field and press tab, the app
immediately prefixes our company ID on the value and displays a "Record not
found. Add new?" prompt.



Regards,
Scott



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mark Wagner
Sent: Monday, April 26, 2010 5:16 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] V8 to E9 BAQ Questions



I was told that too by Epicor support, but am so used to putting it in there
that I havent tried without it. They said if you create the query ID and
description and click save it should add the company identifier in the
beginning but havent seen it work yet

--- On Mon, 4/26/10, Joe Rojas <jrojas@matsinc.
<mailto:jrojas%40matsinc.com> com> wrote:

From: Joe Rojas <jrojas@matsinc. <mailto:jrojas%40matsinc.com> com>
Subject: [Vantage] V8 to E9 BAQ Questions
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Date: Monday, April 26, 2010, 2:24 PM

E9.04.506A

In V8, when creating a BAQ, the Company ID would automatically populate
in the ID field and I believe that this was a requirement when creating
BAQs, the ID must be prefixed with the company ID.

When I create a BAQ in E9, the company ID does not auto populate. Does
this mean that it is not required in E9 or is it required but is a know
bug?

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@matsinc. com | www.matsinc. com Ask us about our clean, green and
beautiful matting and flooring





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

[system]

Sheesh. So simple. I just tried it and I got the same results.

I was so fixated on how it worked in V8, I just assumed it was broke. :)



Thanks Scott.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of sysadmin@...
Sent: Monday, April 26, 2010 6:54 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] V8 to E9 BAQ Questions





We are using 9.04.506a also. Fwiw, if I open BAQ Designer, enter an
unrecognized value into the Query ID field and press tab, the app
immediately prefixes our company ID on the value and displays a "Record
not
found. Add new?" prompt.

Regards,
Scott

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Mark Wagner
Sent: Monday, April 26, 2010 5:16 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] V8 to E9 BAQ Questions

I was told that too by Epicor support, but am so used to putting it in
there
that I havent tried without it. They said if you create the query ID and
description and click save it should add the company identifier in the
beginning but havent seen it work yet

--- On Mon, 4/26/10, Joe Rojas <jrojas@matsinc.
<mailto:jrojas%40matsinc.com> com> wrote:

From: Joe Rojas <jrojas@matsinc. <mailto:jrojas%40matsinc.com> com>
Subject: [Vantage] V8 to E9 BAQ Questions
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Date: Monday, April 26, 2010, 2:24 PM

E9.04.506A

In V8, when creating a BAQ, the Company ID would automatically populate
in the ID field and I believe that this was a requirement when creating
BAQs, the ID must be prefixed with the company ID.

When I create a BAQ in E9, the company ID does not auto populate. Does
this mean that it is not required in E9 or is it required but is a know
bug?

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@matsinc. com | www.matsinc. com Ask us about our clean, green and
beautiful matting and flooring

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




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

[system]

Joe, if you are just getting into E9, check out the Solutions Manager as well. They added it around 9.04 and it allows you to now transfer data definitions in additions to dashboards, BAQs, etc betwen databases. Not well publicized but finally added in E9. Look under systems management and you will see it

--- On Mon, 4/26/10, Joe Rojas <jrojas@...> wrote:


From: Joe Rojas <jrojas@...>
Subject: RE: [Vantage] V8 to E9 BAQ Questions
To: vantage@yahoogroups.com
Date: Monday, April 26, 2010, 8:41 PM


Â



Sheesh. So simple. I just tried it and I got the same results.

I was so fixated on how it worked in V8, I just assumed it was broke. :)

Thanks Scott.

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of sysadmin@mercuryele ctronics. com
Sent: Monday, April 26, 2010 6:54 PM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] V8 to E9 BAQ Questions

We are using 9.04.506a also. Fwiw, if I open BAQ Designer, enter an
unrecognized value into the Query ID field and press tab, the app
immediately prefixes our company ID on the value and displays a "Record
not
found. Add new?" prompt.

Regards,
Scott

_____

From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
[mailto:vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com> ] On
Behalf Of
Mark Wagner
Sent: Monday, April 26, 2010 5:16 PM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Subject: Re: [Vantage] V8 to E9 BAQ Questions

I was told that too by Epicor support, but am so used to putting it in
there
that I havent tried without it. They said if you create the query ID and
description and click save it should add the company identifier in the
beginning but havent seen it work yet

--- On Mon, 4/26/10, Joe Rojas <jrojas@matsinc.
<mailto:jrojas% 40matsinc. com> com> wrote:

From: Joe Rojas <jrojas@matsinc. <mailto:jrojas% 40matsinc. com> com>
Subject: [Vantage] V8 to E9 BAQ Questions
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Date: Monday, April 26, 2010, 2:24 PM

E9.04.506A

In V8, when creating a BAQ, the Company ID would automatically populate
in the ID field and I believe that this was a requirement when creating
BAQs, the ID must be prefixed with the company ID.

When I create a BAQ in E9, the company ID does not auto populate. Does
this mean that it is not required in E9 or is it required but is a know
bug?

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@matsinc. com | www.matsinc. com Ask us about our clean, green and
beautiful matting and flooring

[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]

Do you have any more information on the solutions manager?

Is it in a sub-menu?

Thanks,


CHRIS THOMPSON




________________________________
From: Mark Wagner <mjfw2003@...>
To: vantage@yahoogroups.com
Sent: Tue, 27 April, 2010 2:10:29
Subject: RE: [Vantage] V8 to E9 BAQ Questions

Â
Joe, if you are just getting into E9, check out the Solutions Manager as well. They added it around 9.04 and it allows you to now transfer data definitions in additions to dashboards, BAQs, etc betwen databases. Not well publicized but finally added in E9. Look under systems management and you will see it

--- On Mon, 4/26/10, Joe Rojas <jrojas@matsinc. com> wrote:

From: Joe Rojas <jrojas@matsinc. com>
Subject: RE: [Vantage] V8 to E9 BAQ Questions
To: vantage@yahoogroups .com
Date: Monday, April 26, 2010, 8:41 PM

Â

Sheesh. So simple. I just tried it and I got the same results.

I was so fixated on how it worked in V8, I just assumed it was broke. :)

Thanks Scott.

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of sysadmin@mercuryele ctronics. com
Sent: Monday, April 26, 2010 6:54 PM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] V8 to E9 BAQ Questions

We are using 9.04.506a also. Fwiw, if I open BAQ Designer, enter an
unrecognized value into the Query ID field and press tab, the app
immediately prefixes our company ID on the value and displays a "Record
not
found. Add new?" prompt.

Regards,
Scott

_____

From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
[mailto:vantage@ yahoogroups .com <mailto:vantage% 40yahoogroups. com> ] On
Behalf Of
Mark Wagner
Sent: Monday, April 26, 2010 5:16 PM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Subject: Re: [Vantage] V8 to E9 BAQ Questions

I was told that too by Epicor support, but am so used to putting it in
there
that I havent tried without it. They said if you create the query ID and
description and click save it should add the company identifier in the
beginning but havent seen it work yet

--- On Mon, 4/26/10, Joe Rojas <jrojas@matsinc.
<mailto:jrojas% 40matsinc. com> com> wrote:

From: Joe Rojas <jrojas@matsinc. <mailto:jrojas% 40matsinc. com> com>
Subject: [Vantage] V8 to E9 BAQ Questions
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Date: Monday, April 26, 2010, 2:24 PM

E9.04.506A

In V8, when creating a BAQ, the Company ID would automatically populate
in the ID field and I believe that this was a requirement when creating
BAQs, the ID must be prefixed with the company ID.

When I create a BAQ in E9, the company ID does not auto populate. Does
this mean that it is not required in E9 or is it required but is a know
bug?

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@matsinc. com | www.matsinc. com Ask us about our clean, green and
beautiful matting and flooring

[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]







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

[system]

I found it. This sounds pretty cool!



It is under System Management -> Utilities





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Tuesday, April 27, 2010 4:13 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] V8 to E9 BAQ Questions





Do you have any more information on the solutions manager?

Is it in a sub-menu?

Thanks,

CHRIS THOMPSON












Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
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.



________________________________

From: Mark Wagner <mjfw2003@... <mailto:mjfw2003%40yahoo.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Tue, 27 April, 2010 2:10:29
Subject: RE: [Vantage] V8 to E9 BAQ Questions


Joe, if you are just getting into E9, check out the Solutions Manager as well. They added it around 9.04 and it allows you to now transfer data definitions in additions to dashboards, BAQs, etc betwen databases. Not well publicized but finally added in E9. Look under systems management and you will see it

--- On Mon, 4/26/10, Joe Rojas <jrojas@matsinc. com> wrote:

From: Joe Rojas <jrojas@matsinc. com>
Subject: RE: [Vantage] V8 to E9 BAQ Questions
To: vantage@yahoogroups .com
Date: Monday, April 26, 2010, 8:41 PM



Sheesh. So simple. I just tried it and I got the same results.

I was so fixated on how it worked in V8, I just assumed it was broke. :)

Thanks Scott.

From: vantage@yahoogroups .com [mailto:vantage@ yahoogroups .com] On Behalf
Of sysadmin@mercuryele ctronics. com
Sent: Monday, April 26, 2010 6:54 PM
To: vantage@yahoogroups .com
Subject: RE: [Vantage] V8 to E9 BAQ Questions

We are using 9.04.506a also. Fwiw, if I open BAQ Designer, enter an
unrecognized value into the Query ID field and press tab, the app
immediately prefixes our company ID on the value and displays a "Record
not
found. Add new?" prompt.

Regards,
Scott

_____

From: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
[mailto:vantage@ yahoogroups .com <mailto:vantage% 40yahoogroups. com> ] On
Behalf Of
Mark Wagner
Sent: Monday, April 26, 2010 5:16 PM
To: vantage@yahoogroups .com <mailto:vantage% 40yahoogroups. com>
Subject: Re: [Vantage] V8 to E9 BAQ Questions

I was told that too by Epicor support, but am so used to putting it in
there
that I havent tried without it. They said if you create the query ID and
description and click save it should add the company identifier in the
beginning but havent seen it work yet

--- On Mon, 4/26/10, Joe Rojas <jrojas@matsinc.
<mailto:jrojas% 40matsinc. com> com> wrote:

From: Joe Rojas <jrojas@matsinc. <mailto:jrojas% 40matsinc. com> com>
Subject: [Vantage] V8 to E9 BAQ Questions
To: vantage@yahoogroups <mailto:vantage% 40yahoogroups. com> .com
Date: Monday, April 26, 2010, 2:24 PM

E9.04.506A

In V8, when creating a BAQ, the Company ID would automatically populate
in the ID field and I believe that this was a requirement when creating
BAQs, the ID must be prefixed with the company ID.

When I create a BAQ in E9, the company ID does not auto populate. Does
this mean that it is not required in E9 or is it required but is a know
bug?

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@matsinc. com | www.matsinc. com Ask us about our clean, green and
beautiful matting and flooring

[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]

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




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