BAQ Help Blank Title 57176

Yahoo Archive
21
Yes it appears to, I exported to an xml file then tried to import to Epicor 9, and then it Epic Failed.... Something about being a legacy query.

--- In vantage@yahoogroups.com, Ted Koch wrote:
>
> I'm not familiar with Vista I have never used it, but does it have an export BAQ feature like E9?
>
>
>
>
> ________________________________
> From: bryandavis1980
> To: vantage@yahoogroups.com
> Sent: Monday, February 4, 2013 1:31 PM
> Subject: [Vantage] BAQ Help
>
> Does anybody have a good guide or way of converting BAQs from Vista 8.03.409C to Epicor 9.05.700C. I have access to both systems at the moment and I was just wondering how the query in our new Epicor 9 enviornment. I wish it was a simple as pasting the code from the old query... Any help would be great!
>
> Thank you,
> Bryan
>
>
>
> ------------------------------------
>
> 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]
>
22
Sounds like you may be forced to recreate the BAQs by hand.




________________________________
From: bryandavis1980 <bryandavis1980@...>
To: vantage@yahoogroups.com
Sent: Monday, February 4, 2013 2:01 PM
Subject: [Vantage] Re: BAQ Help

Yes it appears to, I exported to an xml file then tried to import to Epicor 9, and then it Epic Failed.... Something about being a legacy query.

--- In vantage@yahoogroups.com, Ted Koch wrote:
>
> I'm not familiar with Vista I have never used it, but does it have an export BAQ feature like E9?
>
>
>
>
> ________________________________
>Â From: bryandavis1980
> To: vantage@yahoogroups.com
> Sent: Monday, February 4, 2013 1:31 PM
> Subject: [Vantage] BAQ Help
>Â
> Does anybody have a good guide or way of converting BAQs from Vista 8.03.409C to Epicor 9.05.700C. I have access to both systems at the moment and I was just wondering how the query in our new Epicor 9 enviornment. I wish it was a simple as pasting the code from the old query... Any help would be great!
>
> Thank you,
> Bryan
>
>
>
> ------------------------------------
>
> 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]
>




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

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]
23
Possibly some may work (I do not have 9 installed) - those with the same fields and tables may work...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ted Koch
Sent: Monday, February 04, 2013 1:11 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: BAQ Help



Sounds like you may be forced to recreate the BAQs by hand.

________________________________
From: bryandavis1980 bryandavis1980@...<mailto:bryandavis1980%40yahoo.com>>
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Sent: Monday, February 4, 2013 2:01 PM
Subject: [Vantage] Re: BAQ Help

Yes it appears to, I exported to an xml file then tried to import to Epicor 9, and then it Epic Failed.... Something about being a legacy query.

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Ted Koch wrote:
>
> I'm not familiar with Vista I have never used it, but does it have an export BAQ feature like E9?
>
>
>
>
> ________________________________
> From: bryandavis1980
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Sent: Monday, February 4, 2013 1:31 PM
> Subject: [Vantage] BAQ Help
>
> Does anybody have a good guide or way of converting BAQs from Vista 8.03.409C to Epicor 9.05.700C. I have access to both systems at the moment and I was just wondering how the query in our new Epicor 9 enviornment. I wish it was a simple as pasting the code from the old query... Any help would be great!
>
> Thank you,
> Bryan
>
>
>
> ------------------------------------
>
> 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/.<http://groups.yahoo.com/group/vantage/files/>
> (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]
>

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

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/.<http://groups.yahoo.com/group/vantage/files/>
(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]



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

I am trying to pull material information from a job in a BAQ. For some reason I am getting duplicate rows of information. I have displayed all of the options in that table to see if there was something different but, everything is the same.  Has anyone ever experienced duplicate lines for the same part number? It is preventing me from getting accurate job totals.

 

Millicent

This message is intended only for the addressee and may contain information that is company confidential or privileged. Any technical data in this message may be exported only in accordance with the U.S. International Traffic in Arms Regulations (22 CFR Parts 120-130) or the Export Administration Regulations (15 CFR Parts 730-774). Unauthorized use is strictly prohibited and may be unlawful. If you are not the intended recipient, or the person responsible for delivering to the intended recipient, you should not read, copy, disclose or otherwise use this message. If you have received this email in error, please delete it, and advise the sender immediately.
25

Good Day Millicent:

 

            Did you link to any other tables that might have duplicate records ( rev level, qty-bins, etc., plants, )

 

            If in Job transactions could be reversal of an issue?

            Same part in two assemblies?

 

                                                                                                            Len

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 2:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Help

 

 

I am trying to pull material information from a job in a BAQ. For some reason I am getting duplicate rows of information. I have displayed all of the options in that table to see if there was something different but, everything is the same.  Has anyone ever experienced duplicate lines for the same part number? It is preventing me from getting accurate job totals.

 

Millicent

This message is intended only for the addressee and may contain information that is company confidential or privileged. Any technical data in this message may be exported only in accordance with the U.S. International Traffic in Arms Regulations (22 CFR Parts 120-130) or the Export Administration Regulations (15 CFR Parts 730-774). Unauthorized use is strictly prohibited and may be unlawful. If you are not the intended recipient, or the person responsible for delivering to the intended recipient, you should not read, copy, disclose or otherwise use this message. If you have received this email in error, please delete it, and advise the sender immediately.

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.
26
I do have the same part in multiple sub-assemblies, but even the req. qty is showing the same so that's why I did not think that was the issue. I will look to see if I can find a way to clear additional entries without removing what I need. All I am trying to get is a comparison of the total job estimates against the actuals. I will try again.

Thank you for your response Len.

Mdm

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 2:51 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: BAQ Help


Good Day Millicent:

Did you link to any other tables that might have duplicate records ( rev level, qty-bins, etc., plants, )

If in Job transactions could be reversal of an issue?
Same part in two assemblies?

Len

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 2:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Help


I am trying to pull material information from a job in a BAQ. For some reason I am getting duplicate rows of information. I have displayed all of the options in that table to see if there was something different but, everything is the same. Has anyone ever experienced duplicate lines for the same part number? It is preventing me from getting accurate job totals.

Millicent
This message is intended only for the addressee and may contain information that is company confidential or privileged. Any technical data in this message may be exported only in accordance with the U.S. International Traffic in Arms Regulations (22 CFR Parts 120-130) or the Export Administration Regulations (15 CFR Parts 730-774). Unauthorized use is strictly prohibited and may be unlawful. If you are not the intended recipient, or the person responsible for delivering to the intended recipient, you should not read, copy, disclose or otherwise use this message. If you have received this email in error, please delete it, and advise the sender immediately.
________________________________
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]
27

Copy the BAQ here…example:  This will allow the users to see what the query is and what tables are linked.

 

for each PartRev no-lock  where  PartRev.Approved = true And PartRev.Plant = 'nwo'  ,  each PartOpr no-lock  where (PartRev.Company = PartOpr.Company and PartRev.PartNum = PartOpr.PartNum and PartRev.RevisionNum = PartOpr.RevisionNum and PartRev.AltMethod = PartOpr.AltMethod ) and  not PartOpr.OpCode BEGINS 'n-' .

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 12:25 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: BAQ Help

 

 

I do have the same part in multiple sub-assemblies, but even the req. qty is showing the same so that's why I did not think that was the issue. I will look to see if I can find a way to clear additional entries without removing what I need. All I am trying to get is a comparison of the total job estimates against the actuals. I will try again.

Thank you for your response Len.

Mdm

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 2:51 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: BAQ Help

Good Day Millicent:

Did you link to any other tables that might have duplicate records ( rev level, qty-bins, etc., plants, )

If in Job transactions could be reversal of an issue?
Same part in two assemblies?

Len

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 2:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Help

I am trying to pull material information from a job in a BAQ. For some reason I am getting duplicate rows of information. I have displayed all of the options in that table to see if there was something different but, everything is the same. Has anyone ever experienced duplicate lines for the same part number? It is preventing me from getting accurate job totals.

Millicent
This message is intended only for the addressee and may contain information that is company confidential or privileged. Any technical data in this message may be exported only in accordance with the U.S. International Traffic in Arms Regulations (22 CFR Parts 120-130) or the Export Administration Regulations (15 CFR Parts 730-774). Unauthorized use is strictly prohibited and may be unlawful. If you are not the intended recipient, or the person responsible for delivering to the intended recipient, you should not read, copy, disclose or otherwise use this message. If you have received this email in error, please delete it, and advise the sender immediately.
________________________________
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]

28
Good Day Millicent:

Part.Tracker program has a cost by assembly screen Part.Tracker>>Job details >> Assemblies >>Costs which might help.
Note that you have to highlight the item in the tree and then "retrieve" to get each assembly.

My interpretation is that "Estimated" is the cost of the parts when the JOB was created.
"Actual Total" is the cost when the parts are issued.
There is then a "details' button in the middle of the screen.

Len

[cid:image003.jpg@01CFD80F.C0805A60]



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 3:25 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: BAQ Help



I do have the same part in multiple sub-assemblies, but even the req. qty is showing the same so that's why I did not think that was the issue. I will look to see if I can find a way to clear additional entries without removing what I need. All I am trying to get is a comparison of the total job estimates against the actuals. I will try again.

Thank you for your response Len.

Mdm

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 2:51 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: BAQ Help

Good Day Millicent:

Did you link to any other tables that might have duplicate records ( rev level, qty-bins, etc., plants, )

If in Job transactions could be reversal of an issue?
Same part in two assemblies?

Len

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 2:30 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] BAQ Help

I am trying to pull material information from a job in a BAQ. For some reason I am getting duplicate rows of information. I have displayed all of the options in that table to see if there was something different but, everything is the same. Has anyone ever experienced duplicate lines for the same part number? It is preventing me from getting accurate job totals.

Millicent
This message is intended only for the addressee and may contain information that is company confidential or privileged. Any technical data in this message may be exported only in accordance with the U.S. International Traffic in Arms Regulations (22 CFR Parts 120-130) or the Export Administration Regulations (15 CFR Parts 730-774). Unauthorized use is strictly prohibited and may be unlawful. If you are not the intended recipient, or the person responsible for delivering to the intended recipient, you should not read, copy, disclose or otherwise use this message. If you have received this email in error, please delete it, and advise the sender immediately.
________________________________
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]



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]
29
Please see my BAQ below... It is not complete because I have to add a calculation for the cost that the table does not list, total estimate.

for each JobOpDtl no-lock , each JobHead no-lock where (JobOpDtl.Company = JobHead.Company and JobOpDtl.JobNum = JobHead.JobNum ) , each JobMtl no-lock where (JobHead.Company = JobMtl.Company and JobHead.JobNum = JobMtl.JobNum ) and JobMtl.JobNum BEGINS '737-03' .

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 3:36 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: BAQ Help


Copy the BAQ here...example: This will allow the users to see what the query is and what tables are linked.

for each PartRev no-lock where PartRev.Approved = true And PartRev.Plant = 'nwo' , each PartOpr no-lock where (PartRev.Company = PartOpr.Company and PartRev.PartNum = PartOpr.PartNum and PartRev.RevisionNum = PartOpr.RevisionNum and PartRev.AltMethod = PartOpr.AltMethod ) and not PartOpr.OpCode BEGINS 'n-' .

Miguel A. Santillan
Compass Manufacturing Systems

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 12:25 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: BAQ Help



I do have the same part in multiple sub-assemblies, but even the req. qty is showing the same so that's why I did not think that was the issue. I will look to see if I can find a way to clear additional entries without removing what I need. All I am trying to get is a comparison of the total job estimates against the actuals. I will try again.

Thank you for your response Len.

Mdm

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 2:51 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: BAQ Help

Good Day Millicent:

Did you link to any other tables that might have duplicate records ( rev level, qty-bins, etc., plants, )

If in Job transactions could be reversal of an issue?
Same part in two assemblies?

Len

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 2:30 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] BAQ Help

I am trying to pull material information from a job in a BAQ. For some reason I am getting duplicate rows of information. I have displayed all of the options in that table to see if there was something different but, everything is the same. Has anyone ever experienced duplicate lines for the same part number? It is preventing me from getting accurate job totals.

Millicent
This message is intended only for the addressee and may contain information that is company confidential or privileged. Any technical data in this message may be exported only in accordance with the U.S. International Traffic in Arms Regulations (22 CFR Parts 120-130) or the Export Administration Regulations (15 CFR Parts 730-774). Unauthorized use is strictly prohibited and may be unlawful. If you are not the intended recipient, or the person responsible for delivering to the intended recipient, you should not read, copy, disclose or otherwise use this message. If you have received this email in error, please delete it, and advise the sender immediately.
________________________________
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]



[Non-text portions of this message have been removed]
30
Len,
Yes, I am aware of the one in Job Tracker but, I have multiple jobs tied together, like a project. I wanted to add the total estimate for those jobs without doing it individually every time. I am adding them manually using production detail until a come up with something that will add them for me based on job pre-fix.

Mdm

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 3:54 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: BAQ Help



Good Day Millicent:

Part.Tracker program has a cost by assembly screen Part.Tracker>>Job details >> Assemblies >>Costs which might help.
Note that you have to highlight the item in the tree and then "retrieve" to get each assembly.

My interpretation is that "Estimated" is the cost of the parts when the JOB was created.
"Actual Total" is the cost when the parts are issued.
There is then a "details' button in the middle of the screen.

Len

[cid:image003.jpg@01CFD80F.C0805A60]

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 3:25 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: BAQ Help

I do have the same part in multiple sub-assemblies, but even the req. qty is showing the same so that's why I did not think that was the issue. I will look to see if I can find a way to clear additional entries without removing what I need. All I am trying to get is a comparison of the total job estimates against the actuals. I will try again.

Thank you for your response Len.

Mdm

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 2:51 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: BAQ Help

Good Day Millicent:

Did you link to any other tables that might have duplicate records ( rev level, qty-bins, etc., plants, )

If in Job transactions could be reversal of an issue?
Same part in two assemblies?

Len

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 2:30 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] BAQ Help

I am trying to pull material information from a job in a BAQ. For some reason I am getting duplicate rows of information. I have displayed all of the options in that table to see if there was something different but, everything is the same. Has anyone ever experienced duplicate lines for the same part number? It is preventing me from getting accurate job totals.

Millicent
This message is intended only for the addressee and may contain information that is company confidential or privileged. Any technical data in this message may be exported only in accordance with the U.S. International Traffic in Arms Regulations (22 CFR Parts 120-130) or the Export Administration Regulations (15 CFR Parts 730-774). Unauthorized use is strictly prohibited and may be unlawful. If you are not the intended recipient, or the person responsible for delivering to the intended recipient, you should not read, copy, disclose or otherwise use this message. If you have received this email in error, please delete it, and advise the sender immediately.
________________________________
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]

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]



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

How many operations did that specific job have?  How many material parts did that Job contain?  I ran your BAQ as is and I received a record for every material per operation.  I changed the BAQ to the following and I was able to get multiple jobs (based on my filter), and each material specific to the relatedOperation. Try this.

 

for each JobHead where (  JobHead.JobNum BEGINS '678') no-lock , each JobOpDtl where (JobHead.Company = JobOpDtl.Company and JobHead.JobNum = JobOpDtl.JobNum) no-lock , each JobMtl where (JobOpDtl.Company = JobMtl.Company and JobOpDtl.JobNum = JobMtl.JobNum and JobOpDtl.OprSeq = JobMtl.RelatedOperation) no-lock .

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 1:05 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: BAQ Help

 

 

Please see my BAQ below... It is not complete because I have to add a calculation for the cost that the table does not list, total estimate.

for each JobOpDtl no-lock , each JobHead no-lock where (JobOpDtl.Company = JobHead.Company and JobOpDtl.JobNum = JobHead.JobNum ) , each JobMtl no-lock where (JobHead.Company = JobMtl.Company and JobHead.JobNum = JobMtl.JobNum ) and JobMtl.JobNum BEGINS '737-03' .

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 3:36 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: BAQ Help

Copy the BAQ here...example: This will allow the users to see what the query is and what tables are linked.

for each PartRev no-lock where PartRev.Approved = true And PartRev.Plant = 'nwo' , each PartOpr no-lock where (PartRev.Company = PartOpr.Company and PartRev.PartNum = PartOpr.PartNum and PartRev.RevisionNum = PartOpr.RevisionNum and PartRev.AltMethod = PartOpr.AltMethod ) and not PartOpr.OpCode BEGINS 'n-' .

Miguel A. Santillan
Compass Manufacturing Systems

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 12:25 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: BAQ Help

I do have the same part in multiple sub-assemblies, but even the req. qty is showing the same so that's why I did not think that was the issue. I will look to see if I can find a way to clear additional entries without removing what I need. All I am trying to get is a comparison of the total job estimates against the actuals. I will try again.

Thank you for your response Len.

Mdm

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 2:51 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: BAQ Help

Good Day Millicent:

Did you link to any other tables that might have duplicate records ( rev level, qty-bins, etc., plants, )

If in Job transactions could be reversal of an issue?
Same part in two assemblies?

Len

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 2:30 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] BAQ Help

I am trying to pull material information from a job in a BAQ. For some reason I am getting duplicate rows of information. I have displayed all of the options in that table to see if there was something different but, everything is the same. Has anyone ever experienced duplicate lines for the same part number? It is preventing me from getting accurate job totals.

Millicent
This message is intended only for the addressee and may contain information that is company confidential or privileged. Any technical data in this message may be exported only in accordance with the U.S. International Traffic in Arms Regulations (22 CFR Parts 120-130) or the Export Administration Regulations (15 CFR Parts 730-774). Unauthorized use is strictly prohibited and may be unlawful. If you are not the intended recipient, or the person responsible for delivering to the intended recipient, you should not read, copy, disclose or otherwise use this message. If you have received this email in error, please delete it, and advise the sender immediately.
________________________________
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]

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

------------------------------------------------------------------------------------------------------------------------ CONFIDENTIALITY NOTICE: The data attached/enclosed may contain information (including technology and technical data) which is subject to the U.S. International Traffic in Arms Regulations (ITAR) or Export Administration Regulations (EAR). This information may not be exported, released, or disclosed to foreign persons either inside or outside the United States without first obtaining the proper U.S. export license or written authorization. In addition, the information and articles described herein are either patented or proprietary, and the copying or reproduction thereof is prohibited without ADVANCED Motion Controls prior written consent. If you are not the intended recipient (or have received this e-mail in error), please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Thank you for your compliance. X3BTB534
32

Good Day Millicent:

 

            Looks rather straightforward; the only possibility is “Issue-Qty” in JobMtl. Maybe you get duplicate records if you issue, de-issue, re-issue.

 

            For one of the ones with a problem, look at transaction screen, PTHT, and see if there is more than one entry there. Issue-reissue, or partial issue then final issue.

            In Part.tracker under  on-hand>> part location >> WIP see if it has a duplicate record.

 

            I do not used JOB’s very much, so do not have a lot of experience.

 

                                                                                                                                    Len

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 4:12 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: BAQ Help

 

 

Len,
Yes, I am aware of the one in Job Tracker but, I have multiple jobs tied together, like a project. I wanted to add the total estimate for those jobs without doing it individually every time. I am adding them manually using production detail until a come up with something that will add them for me based on job pre-fix.

Mdm

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 3:54 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: BAQ Help

Good Day Millicent:

Part.Tracker program has a cost by assembly screen Part.Tracker>>Job details >> Assemblies >>Costs which might help.
Note that you have to highlight the item in the tree and then "retrieve" to get each assembly.

My interpretation is that "Estimated" is the cost of the parts when the JOB was created.
"Actual Total" is the cost when the parts are issued.
There is then a "details' button in the middle of the screen.

Len

[cid:image003.jpg@01CFD80F.C0805A60]

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 3:25 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: BAQ Help

I do have the same part in multiple sub-assemblies, but even the req. qty is showing the same so that's why I did not think that was the issue. I will look to see if I can find a way to clear additional entries without removing what I need. All I am trying to get is a comparison of the total job estimates against the actuals. I will try again.

Thank you for your response Len.

Mdm

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 2:51 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: BAQ Help

Good Day Millicent:

Did you link to any other tables that might have duplicate records ( rev level, qty-bins, etc., plants, )

If in Job transactions could be reversal of an issue?
Same part in two assemblies?

Len

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 2:30 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] BAQ Help

I am trying to pull material information from a job in a BAQ. For some reason I am getting duplicate rows of information. I have displayed all of the options in that table to see if there was something different but, everything is the same. Has anyone ever experienced duplicate lines for the same part number? It is preventing me from getting accurate job totals.

Millicent
This message is intended only for the addressee and may contain information that is company confidential or privileged. Any technical data in this message may be exported only in accordance with the U.S. International Traffic in Arms Regulations (22 CFR Parts 120-130) or the Export Administration Regulations (15 CFR Parts 730-774). Unauthorized use is strictly prohibited and may be unlawful. If you are not the intended recipient, or the person responsible for delivering to the intended recipient, you should not read, copy, disclose or otherwise use this message. If you have received this email in error, please delete it, and advise the sender immediately.
________________________________
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]

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]

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

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.
33

Do your jobs contain subassemblies or just materials?

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 1:47 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: BAQ Help

 

 

How many operations did that specific job have?  How many material parts did that Job contain?  I ran your BAQ as is and I received a record for every material per operation.  I changed the BAQ to the following and I was able to get multiple jobs (based on my filter), and each material specific to the relatedOperation. Try this.

 

for each JobHead where (  JobHead.JobNum BEGINS '678') no-lock , each JobOpDtl where (JobHead.Company = JobOpDtl.Company and JobHead.JobNum = JobOpDtl.JobNum) no-lock , each JobMtl where (JobOpDtl.Company = JobMtl.Company and JobOpDtl.JobNum = JobMtl.JobNum and JobOpDtl.OprSeq = JobMtl.RelatedOperation) no-lock .

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 1:05 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: BAQ Help

 

 

Please see my BAQ below... It is not complete because I have to add a calculation for the cost that the table does not list, total estimate.

for each JobOpDtl no-lock , each JobHead no-lock where (JobOpDtl.Company = JobHead.Company and JobOpDtl.JobNum = JobHead.JobNum ) , each JobMtl no-lock where (JobHead.Company = JobMtl.Company and JobHead.JobNum = JobMtl.JobNum ) and JobMtl.JobNum BEGINS '737-03' .

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 3:36 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: BAQ Help

Copy the BAQ here...example: This will allow the users to see what the query is and what tables are linked.

for each PartRev no-lock where PartRev.Approved = true And PartRev.Plant = 'nwo' , each PartOpr no-lock where (PartRev.Company = PartOpr.Company and PartRev.PartNum = PartOpr.PartNum and PartRev.RevisionNum = PartOpr.RevisionNum and PartRev.AltMethod = PartOpr.AltMethod ) and not PartOpr.OpCode BEGINS 'n-' .

Miguel A. Santillan
Compass Manufacturing Systems

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 12:25 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: BAQ Help

I do have the same part in multiple sub-assemblies, but even the req. qty is showing the same so that's why I did not think that was the issue. I will look to see if I can find a way to clear additional entries without removing what I need. All I am trying to get is a comparison of the total job estimates against the actuals. I will try again.

Thank you for your response Len.

Mdm

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 2:51 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: BAQ Help

Good Day Millicent:

Did you link to any other tables that might have duplicate records ( rev level, qty-bins, etc., plants, )

If in Job transactions could be reversal of an issue?
Same part in two assemblies?

Len

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 2:30 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] BAQ Help

I am trying to pull material information from a job in a BAQ. For some reason I am getting duplicate rows of information. I have displayed all of the options in that table to see if there was something different but, everything is the same. Has anyone ever experienced duplicate lines for the same part number? It is preventing me from getting accurate job totals.

Millicent
This message is intended only for the addressee and may contain information that is company confidential or privileged. Any technical data in this message may be exported only in accordance with the U.S. International Traffic in Arms Regulations (22 CFR Parts 120-130) or the Export Administration Regulations (15 CFR Parts 730-774). Unauthorized use is strictly prohibited and may be unlawful. If you are not the intended recipient, or the person responsible for delivering to the intended recipient, you should not read, copy, disclose or otherwise use this message. If you have received this email in error, please delete it, and advise the sender immediately.
________________________________
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]

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

------------------------------------------------------------------------------------------------------------------------ CONFIDENTIALITY NOTICE: The data attached/enclosed may contain information (including technology and technical data) which is subject to the U.S. International Traffic in Arms Regulations (ITAR) or Export Administration Regulations (EAR). This information may not be exported, released, or disclosed to foreign persons either inside or outside the United States without first obtaining the proper U.S. export license or written authorization. In addition, the information and articles described herein are either patented or proprietary, and the copying or reproduction thereof is prohibited without ADVANCED Motion Controls prior written consent. If you are not the intended recipient (or have received this e-mail in error), please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Thank you for your compliance. X3BTB534

34

Millicent,

If all you are trying to do is compare estimates with actuals for the totals, take a look at the JobAsmbl table.  The Data Dictionary Viewer will give you field definitions - you mentioned projects and this is a great way to get the top level versus lower level information if you are using job-to-job transactions.