Thanks Nancy this was very helpful. Definite thumbs up post.
We have one part we purchase from a supplier we want to inspect, but not the other parts coming from that supplier (so we cant set inspection at the supplier level and dont want to set it at the part class level) and, we dont want to have to remind purchasing to set it at the PO Line, so I was thinking about adding a UD Checkbox on the part for inspection required and when the new PO line is generated it would update the inspection required checkbox on the PO Line
Â
Anyone doing this already?
[Non-text portions of this message have been removed]
Â
Anyone doing this already?
[Non-text portions of this message have been removed]
Hi Mark,
Yes, we are. We have part.checkbox01 for the inspection required on the part and we have two bpms on PO.update.
First bpm, ensure we're cleared out:
POClearRcvInspection where if there is at least one updated row in the ttPODetail table or there is at least one added row in teh ttPODetail table, set the PODetail.RcvInspectionReq field = false
second bpm set it:
POSetRcvInspectionIfReqd
if number of rows in the Part Checkbox01 query is not less than 1 (query is: for each ttPODetail no-lock , each Part no-lock where (Part.Company = ttPODetail.Company and Part.PartNum = ttPODetail.PartNum and Part.Checkbox01 = 'True')
then set the PODetail.RcvInspectionReq field of the changed row to the true expression.
I'm sorry that without further testing, I can't exactly recall why we needed the clear out bpm. However, i do know that it's been functioning well for us for two years.
HTH
Nanc
Yes, we are. We have part.checkbox01 for the inspection required on the part and we have two bpms on PO.update.
First bpm, ensure we're cleared out:
POClearRcvInspection where if there is at least one updated row in the ttPODetail table or there is at least one added row in teh ttPODetail table, set the PODetail.RcvInspectionReq field = false
second bpm set it:
POSetRcvInspectionIfReqd
if number of rows in the Part Checkbox01 query is not less than 1 (query is: for each ttPODetail no-lock , each Part no-lock where (Part.Company = ttPODetail.Company and Part.PartNum = ttPODetail.PartNum and Part.Checkbox01 = 'True')
then set the PODetail.RcvInspectionReq field of the changed row to the true expression.
I'm sorry that without further testing, I can't exactly recall why we needed the clear out bpm. However, i do know that it's been functioning well for us for two years.
HTH
Nanc
--- In vantage@yahoogroups.com, Mark Wagner <mjfw2003@...> wrote:
>
> We have one part we purchase from a supplier we want to inspect, but not the other parts coming from that supplier (so we cant set inspection at the supplier level and dont want to set it at the part class level) and, we dont want to have to remind purchasing to set it at the PO Line, so I was thinking about adding a UD Checkbox on the part for inspection required and when the new PO line is generated it would update the inspection required checkbox on the PO Line
> Â
> Anyone doing this already?
>
> [Non-text portions of this message have been removed]
>
Excellent Nanc, this will save me set up time
Â
Thanks!
________________________________
From: Nancy <nhoyt111@...>
To: vantage@yahoogroups.com
Sent: Thursday, March 7, 2013 1:26 PM
Subject: [Vantage] Re: E9- Set inspection required at Part Level
Â
Hi Mark,
Yes, we are. We have part.checkbox01 for the inspection required on the part and we have two bpms on PO.update.
First bpm, ensure we're cleared out:
POClearRcvInspection where if there is at least one updated row in the ttPODetail table or there is at least one added row in teh ttPODetail table, set the PODetail.RcvInspectionReq field = false
second bpm set it:
POSetRcvInspectionIfReqd
if number of rows in the Part Checkbox01 query is not less than 1 (query is: for each ttPODetail no-lock , each Part no-lock where (Part.Company = ttPODetail.Company and Part.PartNum = ttPODetail.PartNum and Part.Checkbox01 = 'True')
then set the PODetail.RcvInspectionReq field of the changed row to the true expression.
I'm sorry that without further testing, I can't exactly recall why we needed the clear out bpm. However, i do know that it's been functioning well for us for two years.
HTH
Nanc
Â
Thanks!
________________________________
From: Nancy <nhoyt111@...>
To: vantage@yahoogroups.com
Sent: Thursday, March 7, 2013 1:26 PM
Subject: [Vantage] Re: E9- Set inspection required at Part Level
Â
Hi Mark,
Yes, we are. We have part.checkbox01 for the inspection required on the part and we have two bpms on PO.update.
First bpm, ensure we're cleared out:
POClearRcvInspection where if there is at least one updated row in the ttPODetail table or there is at least one added row in teh ttPODetail table, set the PODetail.RcvInspectionReq field = false
second bpm set it:
POSetRcvInspectionIfReqd
if number of rows in the Part Checkbox01 query is not less than 1 (query is: for each ttPODetail no-lock , each Part no-lock where (Part.Company = ttPODetail.Company and Part.PartNum = ttPODetail.PartNum and Part.Checkbox01 = 'True')
then set the PODetail.RcvInspectionReq field of the changed row to the true expression.
I'm sorry that without further testing, I can't exactly recall why we needed the clear out bpm. However, i do know that it's been functioning well for us for two years.
HTH
Nanc
--- In mailto:vantage%40yahoogroups.com, Mark Wagner <mjfw2003@...> wrote:
>
> We have one part we purchase from a supplier we want to inspect, but not the other parts coming from that supplier (so we cant set inspection at the supplier level and dont want to set it at the part class level) and, we dont want to have to remind purchasing to set it at the PO Line, so I was thinking about adding a UD Checkbox on the part for inspection required and when the new PO line is generated it would update the inspection required checkbox on the PO Line
> Â
> Anyone doing this already?
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]
Inspection Required is on the Part Plant tab. I did the Data Directive below to set the PO Detail.
Greg Payne
/* Set Rcv Insp Required */
For each ttPODetail fields ( RcvInspectionReq PartNum ) where ttPODetail.RowMod = 'A' or ttPODetail.RowMod = 'U',
each PartPlant fields ( RcvInspectionReq ) where ttPODetail.Company = PartPlant.Company and ttPODetail.PartNum = PartPlant.PartNum and PartPlant.RcvInspectionReq = yes.
Assign ttPODetail.RcvInspectionReq = PartPlant.RcvInspectionReq.
End.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wagner
Sent: Thursday, March 07, 2013 10:11 AM
To: Vantage User Group
Subject: [Vantage] E9- Set inspection required at Part Level
We have one part we purchase from a supplier we want to inspect, but not the other parts coming from that supplier (so we cant set inspection at the supplier level and dont want to set it at the part class level) and, we dont want to have to remind purchasing to set it at the PO Line, so I was thinking about adding a UD Checkbox on the part for inspection required and when the new PO line is generated it would update the inspection required checkbox on the PO Line
Anyone doing this already?
[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]
Greg Payne
/* Set Rcv Insp Required */
For each ttPODetail fields ( RcvInspectionReq PartNum ) where ttPODetail.RowMod = 'A' or ttPODetail.RowMod = 'U',
each PartPlant fields ( RcvInspectionReq ) where ttPODetail.Company = PartPlant.Company and ttPODetail.PartNum = PartPlant.PartNum and PartPlant.RcvInspectionReq = yes.
Assign ttPODetail.RcvInspectionReq = PartPlant.RcvInspectionReq.
End.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wagner
Sent: Thursday, March 07, 2013 10:11 AM
To: Vantage User Group
Subject: [Vantage] E9- Set inspection required at Part Level
We have one part we purchase from a supplier we want to inspect, but not the other parts coming from that supplier (so we cant set inspection at the supplier level and dont want to set it at the part class level) and, we dont want to have to remind purchasing to set it at the PO Line, so I was thinking about adding a UD Checkbox on the part for inspection required and when the new PO line is generated it would update the inspection required checkbox on the PO Line
Anyone doing this already?
[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]
I've never seen inspection required on any part tab, did you add a UD field for that? I'm looking at part plant tab on 905.700c and dont see that field.
________________________________
From: Greg Payne <gpayne@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Thursday, March 7, 2013 4:00 PM
Subject: RE: [Vantage] E9- Set inspection required at Part Level
Â
Inspection Required is on the Part Plant tab. I did the Data Directive below to set the PO Detail.
Greg Payne
/* Set Rcv Insp Required */
For each ttPODetail fields ( RcvInspectionReq PartNum ) where ttPODetail.RowMod = 'A' or ttPODetail.RowMod = 'U',
each PartPlant fields ( RcvInspectionReq ) where ttPODetail.Company = PartPlant.Company and ttPODetail.PartNum = PartPlant.PartNum and PartPlant.RcvInspectionReq = yes.
Assign ttPODetail.RcvInspectionReq = PartPlant.RcvInspectionReq.
End.
From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf Of Mark Wagner
Sent: Thursday, March 07, 2013 10:11 AM
To: Vantage User Group
Subject: [Vantage] E9- Set inspection required at Part Level
We have one part we purchase from a supplier we want to inspect, but not the other parts coming from that supplier (so we cant set inspection at the supplier level and dont want to set it at the part class level) and, we dont want to have to remind purchasing to set it at the PO Line, so I was thinking about adding a UD Checkbox on the part for inspection required and when the new PO line is generated it would update the inspection required checkbox on the PO Line
Anyone doing this already?
[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]
[Non-text portions of this message have been removed]
________________________________
From: Greg Payne <gpayne@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Thursday, March 7, 2013 4:00 PM
Subject: RE: [Vantage] E9- Set inspection required at Part Level
Â
Inspection Required is on the Part Plant tab. I did the Data Directive below to set the PO Detail.
Greg Payne
/* Set Rcv Insp Required */
For each ttPODetail fields ( RcvInspectionReq PartNum ) where ttPODetail.RowMod = 'A' or ttPODetail.RowMod = 'U',
each PartPlant fields ( RcvInspectionReq ) where ttPODetail.Company = PartPlant.Company and ttPODetail.PartNum = PartPlant.PartNum and PartPlant.RcvInspectionReq = yes.
Assign ttPODetail.RcvInspectionReq = PartPlant.RcvInspectionReq.
End.
From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf Of Mark Wagner
Sent: Thursday, March 07, 2013 10:11 AM
To: Vantage User Group
Subject: [Vantage] E9- Set inspection required at Part Level
We have one part we purchase from a supplier we want to inspect, but not the other parts coming from that supplier (so we cant set inspection at the supplier level and dont want to set it at the part class level) and, we dont want to have to remind purchasing to set it at the PO Line, so I was thinking about adding a UD Checkbox on the part for inspection required and when the new PO line is generated it would update the inspection required checkbox on the PO Line
Anyone doing this already?
[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]
[Non-text portions of this message have been removed]
I am also running 700C. I found it in the Part Plant list mode and added it to the detail view. It is in the schema ( see below ) .
280
RcvInspectionReq
x<http://svr-eapp2/datadictionary/Mfgsys/00-cross-r.html#RcvInspectionReq>
Inspection Required
logical
yes/no
no
D: Indicates if Inspection is required for items received from this vendor. Inspection will also be enforced if the related PartClass, Vendor, Podetail, JobMtl or JobOper have their "RcvInspectionReq" fields set to Yes.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wagner
Sent: Thursday, March 07, 2013 4:20 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] E9- Set inspection required at Part Level
I've never seen inspection required on any part tab, did you add a UD field for that? I'm looking at part plant tab on 905.700c and dont see that field.
________________________________
From: Greg Payne <gpayne@...<mailto:gpayne%40compulink-usa.com>>
To: "vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>
Sent: Thursday, March 7, 2013 4:00 PM
Subject: RE: [Vantage] E9- Set inspection required at Part Level
Inspection Required is on the Part Plant tab. I did the Data Directive below to set the PO Detail.
Greg Payne
/* Set Rcv Insp Required */
For each ttPODetail fields ( RcvInspectionReq PartNum ) where ttPODetail.RowMod = 'A' or ttPODetail.RowMod = 'U',
each PartPlant fields ( RcvInspectionReq ) where ttPODetail.Company = PartPlant.Company and ttPODetail.PartNum = PartPlant.PartNum and PartPlant.RcvInspectionReq = yes.
Assign ttPODetail.RcvInspectionReq = PartPlant.RcvInspectionReq.
End.
From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf Of Mark Wagner
Sent: Thursday, March 07, 2013 10:11 AM
To: Vantage User Group
Subject: [Vantage] E9- Set inspection required at Part Level
We have one part we purchase from a supplier we want to inspect, but not the other parts coming from that supplier (so we cant set inspection at the supplier level and dont want to set it at the part class level) and, we dont want to have to remind purchasing to set it at the PO Line, so I was thinking about adding a UD Checkbox on the part for inspection required and when the new PO line is generated it would update the inspection required checkbox on the PO Line
Anyone doing this already?
[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]
[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]
280
RcvInspectionReq
x<http://svr-eapp2/datadictionary/Mfgsys/00-cross-r.html#RcvInspectionReq>
Inspection Required
logical
yes/no
no
D: Indicates if Inspection is required for items received from this vendor. Inspection will also be enforced if the related PartClass, Vendor, Podetail, JobMtl or JobOper have their "RcvInspectionReq" fields set to Yes.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Mark Wagner
Sent: Thursday, March 07, 2013 4:20 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] E9- Set inspection required at Part Level
I've never seen inspection required on any part tab, did you add a UD field for that? I'm looking at part plant tab on 905.700c and dont see that field.
________________________________
From: Greg Payne <gpayne@...<mailto:gpayne%40compulink-usa.com>>
To: "vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>
Sent: Thursday, March 7, 2013 4:00 PM
Subject: RE: [Vantage] E9- Set inspection required at Part Level
Inspection Required is on the Part Plant tab. I did the Data Directive below to set the PO Detail.
Greg Payne
/* Set Rcv Insp Required */
For each ttPODetail fields ( RcvInspectionReq PartNum ) where ttPODetail.RowMod = 'A' or ttPODetail.RowMod = 'U',
each PartPlant fields ( RcvInspectionReq ) where ttPODetail.Company = PartPlant.Company and ttPODetail.PartNum = PartPlant.PartNum and PartPlant.RcvInspectionReq = yes.
Assign ttPODetail.RcvInspectionReq = PartPlant.RcvInspectionReq.
End.
From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf Of Mark Wagner
Sent: Thursday, March 07, 2013 10:11 AM
To: Vantage User Group
Subject: [Vantage] E9- Set inspection required at Part Level
We have one part we purchase from a supplier we want to inspect, but not the other parts coming from that supplier (so we cant set inspection at the supplier level and dont want to set it at the part class level) and, we dont want to have to remind purchasing to set it at the PO Line, so I was thinking about adding a UD Checkbox on the part for inspection required and when the new PO line is generated it would update the inspection required checkbox on the PO Line
Anyone doing this already?
[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]
[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]