Final Operation - BOM

Yahoo Archive
1
Just as an FYI, for those backflushing labor, the final operation indicates that any preceeding operations are eligible to be backflushed through the backflush labor process server. If the final operation on a MOM is checked, you only have to report quantity on that operation and your other operations will backflush the labor if those operations labor methods are set to backflush.




________________________________
From: Gary Parfrey <garyp@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Monday, November 5, 2012 6:43 AM
Subject: RE: [Vantage] Final Operation - BOM

Â

In Vantage 6.1 and before, you had to flag this checkbox otherwise you would never get any completed quantity on your job.
As of Vantage 8 and in turn Epicor 9, this checkbox is only used by exception. In other words the system assumes the last operation sequence on assembly zero is the last operation
This checkbox is so you can use an operation prior to the last, in order to mark job quantity complete when quantity is posted to it.

The last operation sequence is stored in the PartRev and in the JobAsmbl tables, but updated via the Part Operation and Job Operation views You do not necessarily need to check this box for the system to work.

Gary



[cid:mailto:image491a56.GIF%40c5306ae5.47938236]

From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf Of Turgeon, Bill
Sent: 02 November 2012 19:52
To: mailto:vantage%40yahoogroups.com
Subject: RE: [Vantage] Final Operation - BOM



That doesn’t help me…. There must be something on the Partopr that indicates which operation is the last one.

How does the Job know which is last? I remember indicating “FinalOper” on the DMT tool when importing our BOM’s way back when….



From: mailto:vantage%40yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:mailto:vantage%40yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Mark Wagner
Sent: Friday, November 02, 2012 3:49 PM
To: mailto:vantage%40yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Final Operation - BOM





Its on the joboper table

________________________________
From: "Turgeon, Bill" <mailto:bturgeon%40cotorelay.com<mailto:bturgeon%40cotorelay.com> <mailto:bturgeon%40cotorelay.com> >
To: mailto:vantage%40yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Sent: Friday, November 2, 2012 3:35 PM
Subject: RE: [Vantage] Final Operation - BOM


I see it but it points to the ECO table… I’m looking at the PartOpr table

From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf Of Mark Wagner
Sent: Friday, November 02, 2012 3:18 PM
To: mailto:vantage%40yahoogroups.com
Subject: Re: [Vantage] Final Operation - BOM

Its on the operations tab on your method of manufacturing in engineering workbench

________________________________
From: "Turgeon, Bill" <mailto:bturgeon%40cotorelay.com <mailto:bturgeon%40cotorelay.com <mailto:bturgeon%40cotorelay.com%20%3cmailto:bturgeon%40cotorelay.com<mailto:bturgeon%40cotorelay.com%20%3cmailto:bturgeon%40cotorelay.com%20%3cmailto:bturgeon%40cotorelay.com%20%3cmailto:bturgeon%40cotorelay.com>> > >
To: mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Friday, November 2, 2012 3:13 PM
Subject: [Vantage] Final Operation - BOM

Ok folks, I having a senior moment.... I know there is a field somewhere
that indicates the operation is the 'Final Operation'.

Be damned if I can find it.... Anyone?

Also, I may need to create a SQL view, but once created, how can I
access it via a BAQ?

Thanks!!

Bill Turgeon

Director, Information Technology

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


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




[Non-text portions of this message have been removed]
2
Ok folks, I having a senior moment.... I know there is a field somewhere
that indicates the operation is the 'Final Operation'.

Be damned if I can find it.... Anyone?



Also, I may need to create a SQL view, but once created, how can I
access it via a BAQ?





Thanks!!



Bill Turgeon

Director, Information Technology



[Non-text portions of this message have been removed]
3
Its on the operations tab on your method of manufacturing in engineering workbench



________________________________
From: "Turgeon, Bill" <bturgeon@...>
To: vantage@yahoogroups.com
Sent: Friday, November 2, 2012 3:13 PM
Subject: [Vantage] Final Operation - BOM

Â
Ok folks, I having a senior moment.... I know there is a field somewhere
that indicates the operation is the 'Final Operation'.

Be damned if I can find it.... Anyone?

Also, I may need to create a SQL view, but once created, how can I
access it via a BAQ?

Thanks!!

Bill Turgeon

Director, Information Technology

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




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

To access a SQL database in a BAQ you need to create an External Query. Before you do this you need to create an ODBC on the Epicor server, the driver should be SQL Server Native Client 10.0. Then the ODBC connection will be available in the Data Source drop down. I also create SQL Server credentials to use for the ODBC connection as well as in the External Query setup.

I don't think it is possible to then link the SQL tables to any Epicor tables. I have been able to add SQL and Epicor tables to the Phrase build and link them, but then Epicor gets upset when trying to run the query.

Hope it helps,

-Ted




________________________________
From: "Turgeon, Bill" <bturgeon@...>
To: vantage@yahoogroups.com
Sent: Friday, November 2, 2012 3:13 PM
Subject: [Vantage] Final Operation - BOM

Ok folks, I having a senior moment.... I know there is a field somewhere
that indicates the operation is the 'Final Operation'.

Be damned if I can find it.... Anyone?



Also, I may need to create a SQL view, but once created, how can I
access it via a BAQ?





Thanks!!



Bill Turgeon

Director, Information Technology



[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]
5
I see it but it points to the ECO table… I’m looking at the PartOpr table



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wagner
Sent: Friday, November 02, 2012 3:18 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Final Operation - BOM





Its on the operations tab on your method of manufacturing in engineering workbench

________________________________
From: "Turgeon, Bill" <bturgeon@... <mailto:bturgeon%40cotorelay.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Friday, November 2, 2012 3:13 PM
Subject: [Vantage] Final Operation - BOM


Ok folks, I having a senior moment.... I know there is a field somewhere
that indicates the operation is the 'Final Operation'.

Be damned if I can find it.... Anyone?

Also, I may need to create a SQL view, but once created, how can I
access it via a BAQ?

Thanks!!

Bill Turgeon

Director, Information Technology

[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]
6
Its on the joboper table



________________________________
From: "Turgeon, Bill" <bturgeon@...>
To: vantage@yahoogroups.com
Sent: Friday, November 2, 2012 3:35 PM
Subject: RE: [Vantage] Final Operation - BOM

Â
I see it but it points to the ECO table… I’m looking at the PartOpr table



From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf Of Mark Wagner
Sent: Friday, November 02, 2012 3:18 PM
To: mailto:vantage%40yahoogroups.com
Subject: Re: [Vantage] Final Operation - BOM





Its on the operations tab on your method of manufacturing in engineering workbench

________________________________
From: "Turgeon, Bill" <mailto:bturgeon%40cotorelay.com <mailto:bturgeon%40cotorelay.com> >
To: mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Friday, November 2, 2012 3:13 PM
Subject: [Vantage] Final Operation - BOM


Ok folks, I having a senior moment.... I know there is a field somewhere
that indicates the operation is the 'Final Operation'.

Be damned if I can find it.... Anyone?

Also, I may need to create a SQL view, but once created, how can I
access it via a BAQ?

Thanks!!

Bill Turgeon

Director, Information Technology

[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]
7
That doesn’t help me…. There must be something on the Partopr that indicates which operation is the last one.

How does the Job know which is last? I remember indicating “FinalOper” on the DMT tool when importing our BOM’s way back when….



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wagner
Sent: Friday, November 02, 2012 3:49 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Final Operation - BOM





Its on the joboper table

________________________________
From: "Turgeon, Bill" <bturgeon@... <mailto:bturgeon%40cotorelay.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Friday, November 2, 2012 3:35 PM
Subject: RE: [Vantage] Final Operation - BOM


I see it but it points to the ECO table… I’m looking at the PartOpr table

From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf Of Mark Wagner
Sent: Friday, November 02, 2012 3:18 PM
To: mailto:vantage%40yahoogroups.com
Subject: Re: [Vantage] Final Operation - BOM

Its on the operations tab on your method of manufacturing in engineering workbench

________________________________
From: "Turgeon, Bill" <mailto:bturgeon%40cotorelay.com <mailto:bturgeon%40cotorelay.com <mailto:bturgeon%40cotorelay.com%20%3cmailto:bturgeon%40cotorelay.com> > >
To: mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Friday, November 2, 2012 3:13 PM
Subject: [Vantage] Final Operation - BOM

Ok folks, I having a senior moment.... I know there is a field somewhere
that indicates the operation is the 'Final Operation'.

Be damned if I can find it.... Anyone?

Also, I may need to create a SQL view, but once created, how can I
access it via a BAQ?

Thanks!!

Bill Turgeon

Director, Information Technology

[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]
8
PartRev.FinalOpr becomes JobAsmbl.FinalOpr. It is the OprSeq of the operation.

FinalOpr

x<http://svr-eapp2/datadictionary/Mfgsys/00-cross-f.html#FinalOpr>

Final Operation

integer

>>>9

0


D: The sequence of the operation that is to be considered as the operation which indicates the quantity complete for the Job/Assembly. In other words this operations completed quantity = Job/Assembly completed. Note: Zero = no operation is set and that the system should use the last operation to determine quantity complete. This field is not directly maintainable. Instead it is set during operation maintenance by having the user mark a check box indicating "Final Operation" which then updates this field with the operations sequence number.


Greg


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Turgeon, Bill
Sent: Friday, November 02, 2012 3:52 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Final Operation - BOM



That doesn’t help me…. There must be something on the Partopr that indicates which operation is the last one.

How does the Job know which is last? I remember indicating “FinalOper” on the DMT tool when importing our BOM’s way back when….



From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Mark Wagner
Sent: Friday, November 02, 2012 3:49 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Final Operation - BOM





Its on the joboper table

________________________________
From: "Turgeon, Bill" <bturgeon@...<mailto:bturgeon%40cotorelay.com> <mailto:bturgeon%40cotorelay.com> >
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Sent: Friday, November 2, 2012 3:35 PM
Subject: RE: [Vantage] Final Operation - BOM


I see it but it points to the ECO table… I’m looking at the PartOpr table

From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf Of Mark Wagner
Sent: Friday, November 02, 2012 3:18 PM
To: mailto:vantage%40yahoogroups.com
Subject: Re: [Vantage] Final Operation - BOM

Its on the operations tab on your method of manufacturing in engineering workbench

________________________________
From: "Turgeon, Bill" <mailto:bturgeon%40cotorelay.com <mailto:bturgeon%40cotorelay.com <mailto:bturgeon%40cotorelay.com%20%3cmailto:bturgeon%40cotorelay.com<mailto:bturgeon%40cotorelay.com%20%3cmailto:bturgeon%40cotorelay.com%20%3cmailto:bturgeon%40cotorelay.com%20%3cmailto:bturgeon%40cotorelay.com>> > >
To: mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Friday, November 2, 2012 3:13 PM
Subject: [Vantage] Final Operation - BOM

Ok folks, I having a senior moment.... I know there is a field somewhere
that indicates the operation is the 'Final Operation'.

Be damned if I can find it.... Anyone?

Also, I may need to create a SQL view, but once created, how can I
access it via a BAQ?

Thanks!!

Bill Turgeon

Director, Information Technology

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


________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."


[Non-text portions of this message have been removed]
9
In Vantage 6.1 and before, you had to flag this checkbox otherwise you would never get any completed quantity on your job.
As of Vantage 8 and in turn Epicor 9, this checkbox is only used by exception. In other words the system assumes the last operation sequence on assembly zero is the last operation
This checkbox is so you can use an operation prior to the last, in order to mark job quantity complete when quantity is posted to it.

The last operation sequence is stored in the PartRev and in the JobAsmbl tables, but updated via the Part Operation and Job Operation views You do not necessarily need to check this box for the system to work.

Gary



[cid:image491a56.GIF@c5306ae5.47938236]

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Turgeon, Bill
Sent: 02 November 2012 19:52
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Final Operation - BOM



That doesn’t help me…. There must be something on the Partopr that indicates which operation is the last one.

How does the Job know which is last? I remember indicating “FinalOper” on the DMT tool when importing our BOM’s way back when….



From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Mark Wagner
Sent: Friday, November 02, 2012 3:49 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Final Operation - BOM





Its on the joboper table

________________________________
From: "Turgeon, Bill" <bturgeon@...<mailto:bturgeon%40cotorelay.com> <mailto:bturgeon%40cotorelay.com> >
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Sent: Friday, November 2, 2012 3:35 PM
Subject: RE: [Vantage] Final Operation - BOM


I see it but it points to the ECO table… I’m looking at the PartOpr table

From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf Of Mark Wagner
Sent: Friday, November 02, 2012 3:18 PM
To: mailto:vantage%40yahoogroups.com
Subject: Re: [Vantage] Final Operation - BOM

Its on the operations tab on your method of manufacturing in engineering workbench

________________________________
From: "Turgeon, Bill" <mailto:bturgeon%40cotorelay.com <mailto:bturgeon%40cotorelay.com <mailto:bturgeon%40cotorelay.com%20%3cmailto:bturgeon%40cotorelay.com<mailto:bturgeon%40cotorelay.com%20%3cmailto:bturgeon%40cotorelay.com%20%3cmailto:bturgeon%40cotorelay.com%20%3cmailto:bturgeon%40cotorelay.com>> > >
To: mailto:vantage%40yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Friday, November 2, 2012 3:13 PM
Subject: [Vantage] Final Operation - BOM

Ok folks, I having a senior moment.... I know there is a field somewhere
that indicates the operation is the 'Final Operation'.

Be damned if I can find it.... Anyone?

Also, I may need to create a SQL view, but once created, how can I
access it via a BAQ?

Thanks!!

Bill Turgeon

Director, Information Technology

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



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