BAQ Issue with Part and PartCost

Yahoo Archive
1
Big thanks to Bruce and Ernie. One sent me an exported BAQ and it got me
going and the other the SCR number for the fix (which Epicor has already
sent!) and I'm back in business.

Everybody's help is very much appreciated!

Mark W.

On Fri, Nov 4, 2011 at 8:09 AM, Elizabeth <gracefulthreads@...> wrote:

> **
>
>
> Ask about SCR 78693, BAQ Table Relationships. We had problems with most
> BAQs until getting that fix in place. Be aware you'll have to install it on
> each client machine that creates BAQs.
>
> Ernie Lowell
> Diba Industries
>
>
> --- In vantage@yahoogroups.com, Mark Wonsil <mark_wonsil@...> wrote:
> >
> > > Well, I've had a few strange things happen with BAQs in 9.04.xxx
> > > Not specifically the one you are having.
> > > You might want to call Epicor.
> > > I spoke to them about this a few weeks ago & there are some version
> issues that they know about & some one-off fixes.
> >
> > Yeah, we're calling. Our last call about the User Field Mapping ended
> > with, "Well, it works in .606"
> >
> > Which meant we were SOL...
> >
> > Thanks everyone.
> >
> > Mark W.
> >
>
>
>


[Non-text portions of this message have been removed]
2
Epicor 9.04.507A

Every time we try to link these two tables, we get an error saying
that there are two "root tables". Any one else get this error?

Thanks!

Mark W.
3
What are you trying to pull out of the tables? And do you have a link between the two?



________________________________
From: Mark Wonsil <mark_wonsil@...>
To: vantage@yahoogroups.com
Sent: Wednesday, November 2, 2011 4:47 PM
Subject: [Vantage] BAQ Issue with Part and PartCost

Epicor 9.04.507A

Every time we try to link these two tables, we get an error saying
that there are two "root tables". Any one else get this error?

Thanks!

Mark W.


------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%c2%a0
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links



[Non-text portions of this message have been removed]
4
I tried it on 9.04.506C & it is OK here.
Do you have multiple companies? And include company in the joins?

I seem to remember I had root errors on a security file because the company is blank.

--- In vantage@yahoogroups.com, Mark Wonsil <mark_wonsil@...> wrote:
>
> Epicor 9.04.507A
>
> Every time we try to link these two tables, we get an error saying
> that there are two "root tables". Any one else get this error?
>
> Thanks!
>
> Mark W.
>
5
> I tried it on 9.04.506C & it is OK here.
> Do you have multiple companies? And include company in the joins?
>
> I seem to remember I had root errors on a security file because the company is blank.
>

Yes, there is a link using both Company, PartNum. What's odd is that
it worked in 504B. Even recreating from scratch duplicates the
error...

Sigh...

Mark W.
6
Well, I've had a few strange things happen with BAQs in 9.04.xxx
Not specifically the one you are having.
You might want to call Epicor.
I spoke to them about this a few weeks ago & there are some version issues that they know about & some one-off fixes.

--- In vantage@yahoogroups.com, Mark Wonsil <mark_wonsil@...> wrote:
>
> > I tried it on 9.04.506C & it is OK here.
> > Do you have multiple companies? And include company in the joins?
> >
> > I seem to remember I had root errors on a security file because the company is blank.
> >
>
> Yes, there is a link using both Company, PartNum. What's odd is that
> it worked in 504B. Even recreating from scratch duplicates the
> error...
>
> Sigh...
>
> Mark W.
>
7
> Well, I've had a few strange things happen with BAQs in 9.04.xxx
> Not specifically the one you are having.
> You might want to call Epicor.
> I spoke to them about this a few weeks ago & there are some version issues that they know about & some one-off fixes.

Yeah, we're calling. Our last call about the User Field Mapping ended
with, "Well, it works in .606"

Which meant we were SOL...

Thanks everyone.

Mark W.
8
Hi Ted,

>
> What are you trying to pull out of the tables? And do you have a link between the two?
>

Since Vantage 8.03, during our Physical Inventory, we've exported the
tags (CountTag now CCTag), the Part, and the PartCost information to
Excel. It made looking at variances a lot easier than printing the
Count Variance Report and searching through 250 pages by hand. This
BAQ has worked for years but needed to be updated to the new tags
table and it just won't link them any more.

Mark W.
9
What I've found when this happens to some of my BAQ's is to make sure all the links are pointing in the right direction, especially with Outer Joins. Check the directions of the links. Many database apps don't worry about this but Epicor 9 sure does.

Jeff


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wonsil
Sent: Thursday, November 03, 2011 8:52 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BAQ Issue with Part and PartCost



Hi Ted,

>
> What are you trying to pull out of the tables? And do you have a link between the two?
>

Since Vantage 8.03, during our Physical Inventory, we've exported the
tags (CountTag now CCTag), the Part, and the PartCost information to
Excel. It made looking at variances a lot easier than printing the
Count Variance Report and searching through 250 pages by hand. This
BAQ has worked for years but needed to be updated to the new tags
table and it just won't link them any more.

Mark W.


**********************************************************************
This e-mail message is intended for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.
Imagineering Finishing Technologies and its affiliates may review and retain incoming and outgoing electronic mail for this e-mail address for quality assurance and regulatory compliance purposes. The confidentiality of internet e-mail cannot be guaranteed. Your transmission of electronic mail to this address represents your consent to two-way communication by internet e-mail.

www.iftworldwide.com
**********************************************************************



[Non-text portions of this message have been removed]
10
Ask about SCR 78693, BAQ Table Relationships. We had problems with most BAQs until getting that fix in place. Be aware you'll have to install it on each client machine that creates BAQs.

Ernie Lowell
Diba Industries

--- In vantage@yahoogroups.com, Mark Wonsil <mark_wonsil@...> wrote:
>
> > Well, I've had a few strange things happen with BAQs in 9.04.xxx
> > Not specifically the one you are having.
> > You might want to call Epicor.
> > I spoke to them about this a few weeks ago & there are some version issues that they know about & some one-off fixes.
>
> Yeah, we're calling. Our last call about the User Field Mapping ended
> with, "Well, it works in .606"
>
> Which meant we were SOL...
>
> Thanks everyone.
>
> Mark W.
>