If you had a project ID trying all those jobs together look at project tracker…it gives you what you are looking for in your BAQ.
Manasa
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, September 24, 2014 3:11 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]