BAQ: Accessing same table for Different record in calculated fie

Yahoo Archive
1
Good Day:

Sun Is on:
M2K, 7.0 SP7, Informix ( not Unix) (Currently using).
Going to: Epicor 9, 9.04 ( was suppose to be 9.05), SQL (live
7/1/2010- maybe 8/1/10)

In E9 on which we are being trained, I created BAQ using ECOmtl,
Part, and Part (one screen is Part1). I edited the Part1 link to be
Component to Part# in order to get the description of the component. See
attached.

Remember, this is E9.


len.hartka@...




________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of pklein256
Sent: Thursday, January 28, 2010 2:44 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ: Accessing same table for Different record in
calculated field




I have not been successful in having the same table twice within the
same BAQ. An Epicor consultant told mt it wasn't possible, but I could
use ODBC (which does work). Within a dashboard, you can have multiple
BAQs/data displayed, and then create a crystal report tieing the two BAQ
outputs into a report.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"dgodfrey_amc" <dgodfrey_amc@...> wrote:
>
> What I need to do is use the JobOper.OprSeq to find the previous
> JobOper.OprSeq. My goal is to identify the "Quantity At Location" on a
specific operation.
>
> SO I think that I need to get the previous JobOper record by using the
OprSeq field to know the previous JobOper.QtyCompleted and subract it
from the Current QtyCompleted. This should give me the Current Qty still
waiting on current operation.
>
> Does anyone know how to access the same table but a different record
on a BAQ calculated field?
>






This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.


[Non-text portions of this message have been removed]
2
What I need to do is use the JobOper.OprSeq to find the previous
JobOper.OprSeq. My goal is to identify the "Quantity At Location" on a specific operation.

SO I think that I need to get the previous JobOper record by using the OprSeq field to know the previous JobOper.QtyCompleted and subract it from the Current QtyCompleted. This should give me the Current Qty still waiting on current operation.

Does anyone know how to access the same table but a different record on a BAQ calculated field?
3
Please, I would be so appreciative to anyone that can help.

--- In vantage@yahoogroups.com, "dgodfrey_amc" <dgodfrey_amc@...> wrote:
>
> What I need to do is use the JobOper.OprSeq to find the previous
> JobOper.OprSeq. My goal is to identify the "Quantity At Location" on a specific operation.
>
> SO I think that I need to get the previous JobOper record by using the OprSeq field to know the previous JobOper.QtyCompleted and subract it from the Current QtyCompleted. This should give me the Current Qty still waiting on current operation.
>
> Does anyone know how to access the same table but a different record on a BAQ calculated field?
>
4
The tables you want to look at are zDataTable and zDataField. In theory, if you create additional entries in those two tables with table name of JobOper2 but pointing to the original dbtablename=JobOper, then you will be able to select the table in your BAQ designer. In practice, some as-yet-undiscovered special step appears to be required to get the table to appear. Has anyone else had better luck?



--- In vantage@yahoogroups.com, "dgodfrey_amc" <dgodfrey_amc@...> wrote:
>
> Please, I would be so appreciative to anyone that can help.
>
> --- In vantage@yahoogroups.com, "dgodfrey_amc" <dgodfrey_amc@> wrote:
> >
> > What I need to do is use the JobOper.OprSeq to find the previous
> > JobOper.OprSeq. My goal is to identify the "Quantity At Location" on a specific operation.
> >
> > SO I think that I need to get the previous JobOper record by using the OprSeq field to know the previous JobOper.QtyCompleted and subract it from the Current QtyCompleted. This should give me the Current Qty still waiting on current operation.
> >
> > Does anyone know how to access the same table but a different record on a BAQ calculated field?
> >
>
5
I have not been successful in having the same table twice within the same BAQ. An Epicor consultant told mt it wasn't possible, but I could use ODBC (which does work). Within a dashboard, you can have multiple BAQs/data displayed, and then create a crystal report tieing the two BAQ outputs into a report.

--- In vantage@yahoogroups.com, "dgodfrey_amc" <dgodfrey_amc@...> wrote:
>
> What I need to do is use the JobOper.OprSeq to find the previous
> JobOper.OprSeq. My goal is to identify the "Quantity At Location" on a specific operation.
>
> SO I think that I need to get the previous JobOper record by using the OprSeq field to know the previous JobOper.QtyCompleted and subract it from the Current QtyCompleted. This should give me the Current Qty still waiting on current operation.
>
> Does anyone know how to access the same table but a different record on a BAQ calculated field?
>