E9: Subcontract POs on Time Phase

Did you all create the dashboard because the Subcontract Status report would not work?  Under Job Management > Report > Subcontract Status

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, March 21, 2016 12:12 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E9: Subcontract POs on Time Phase

 

 

Kathy:

 

I had a consultant work on this and he re-used fields for this. You could put Customer and Vendor in SourceFile. On TimePhas.GoProcessTimePhase Post processing.

 

You should be able to adapt the below and then unhide the field in a customization.

 

Greg

 

 

 

 

for each ttTimePhas:

 

                If ttTimePhas.SourceFile = 'BB' Then ttTimePhas.SourceFile = ''.

                If ttTimePhas.SourceFile = 'OR' Then ttTimePhas.SourceFile = ''.

 

               

                IF ttTimePhas.OrderNum > 0 then

                                FOR First OrderHed NO-LOCK WHERE OrderHed.Company=cur-comp and OrderHed.OrderNum = ttTimePhas.OrderNum.

 

                                                                                FOR EACH Customer NO-LOCK WHERE Customer.Company=OrderHed.Company and Customer.CustNum=OrderHed.CustNum:

                                                                                                ASSIGN ttTimePhas.SourceFile=Customer.CustID.

                                               

                                               

                                                                                END.

 

                                               

                  END.

 

 

                IF ttTimePhas.PONum > 0 then

                                FOR First PORel NO-LOCK WHERE PORel.Company=cur-comp and PORel.PONum = ttTimePhas.PONum and PORel.POLine = ttTimePhas.POLine and PORel.PORelNum = ttTimePhas.PORelNum.

 

                                                                if PORel.CheckBox03 = true then

                                                                                ASSIGN ttTimePhas.Exception = "Best Date".

                               

                               

                                               

 

                                               

                                END.

 

 

End.

 

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, March 21, 2016 2:23 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E9: Subcontract POs on Time Phase

 

 

It would be nice -  but – when I looked at the Collection – in the detail area through customization  â€“ there isn’t any user defined fields that you can use.

 

But, I do have limited programming skills.

 

I would also like the customer to display when there is a sales order and the vendor on a PO.

 

I could do it on the printed form but, we don’t usually print out time phased.

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, March 21, 2016 10:54 AM
To: vantage@yahoogroups.com
Subject: [Vantage] E9: Subcontract POs on Time Phase

 

 

Should subcontract POs show up on TimePhase?

 

 

Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

 



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-6240 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."



Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

Should subcontract POs show up on TimePhase?

 



Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

It would be nice - but – when I looked at the Collection – in the detail area through customization  – there isn’t any user defined fields that you can use.

 

But, I do have limited programming skills.

 

I would also like the customer to display when there is a sales order and the vendor on a PO.

 

I could do it on the printed form but, we don’t usually print out time phased.

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, March 21, 2016 10:54 AM
To: vantage@yahoogroups.com
Subject: [Vantage] E9: Subcontract POs on Time Phase

 

 

Should subcontract POs show up on TimePhase?

 

 

Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

I just want to make sure before I tell them to use the Subcontract Status Report.  The email they sent me sounded like it used to, but I cant verify that.

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, March 21, 2016 11:23 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E9: Subcontract POs on Time Phase

 

 

It would be nice -  but – when I looked at the Collection – in the detail area through customization  â€“ there isn’t any user defined fields that you can use.

 

But, I do have limited programming skills.

 

I would also like the customer to display when there is a sales order and the vendor on a PO.

 

I could do it on the printed form but, we don’t usually print out time phased.

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, March 21, 2016 10:54 AM
To: vantage@yahoogroups.com
Subject: [Vantage] E9: Subcontract POs on Time Phase

 

 

Should subcontract POs show up on TimePhase?

 

 

Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.



Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

We are just now working on the sub-contact process and I couldn’t find them in time phase, so I wrote a dashboard to track them.

 

Here is the BAQ query.

for each PODetail no-lock  ,  each PORel no-lock  where (PODetail.Company = PORel.Company and PODetail.PONum = PORel.PONUM and PODetail.POLine = PORel.POLine ) and  PORel.JobSeqType = 'S' And PORel.OpenRelease = true .

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, March 21, 2016 2:53 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E9: Subcontract POs on Time Phase

 

 

I just want to make sure before I tell them to use the Subcontract Status Report.  The email they sent me sounded like it used to, but I cant verify that.

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, March 21, 2016 11:23 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E9: Subcontract POs on Time Phase

 

 

It would be nice -  but – when I looked at the Collection – in the detail area through customization  â€“ there isn’t any user defined fields that you can use.

 

But, I do have limited programming skills.

 

I would also like the customer to display when there is a sales order and the vendor on a PO.

 

I could do it on the printed form but, we don’t usually print out time phased.

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, March 21, 2016 10:54 AM
To: vantage@yahoogroups.com
Subject: [Vantage] E9: Subcontract POs on Time Phase

 

 

Should subcontract POs show up on TimePhase?

 

 

Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

 

Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.




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-6240 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."

Kathy:

 

I had a consultant work on this and he re-used fields for this. You could put Customer and Vendor in SourceFile. On TimePhas.GoProcessTimePhase Post processing.

 

You should be able to adapt the below and then unhide the field in a customization.

 

Greg

 

 

 

 

for each ttTimePhas:

 

                If ttTimePhas.SourceFile = 'BB' Then ttTimePhas.SourceFile = ''.

                If ttTimePhas.SourceFile = 'OR' Then ttTimePhas.SourceFile = ''.

 

               

                IF ttTimePhas.OrderNum > 0 then

                                FOR First OrderHed NO-LOCK WHERE OrderHed.Company=cur-comp and OrderHed.OrderNum = ttTimePhas.OrderNum.

 

                                                                                FOR EACH Customer NO-LOCK WHERE Customer.Company=OrderHed.Company and Customer.CustNum=OrderHed.CustNum:

                                                                                                ASSIGN ttTimePhas.SourceFile=Customer.CustID.

                                               

                                               

                                                                                END.

 

                                               

                  END.

 

 

                IF ttTimePhas.PONum > 0 then

                                FOR First PORel NO-LOCK WHERE PORel.Company=cur-comp and PORel.PONum = ttTimePhas.PONum and PORel.POLine = ttTimePhas.POLine and PORel.PORelNum = ttTimePhas.PORelNum.

 

                                                                if PORel.CheckBox03 = true then

                                                                                ASSIGN ttTimePhas.Exception = "Best Date".

                               

                               

                                               

 

                                               

                                END.

 

 

End.

 

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, March 21, 2016 2:23 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E9: Subcontract POs on Time Phase

 

 

It would be nice -  but – when I looked at the Collection – in the detail area through customization  â€“ there isn’t any user defined fields that you can use.

 

But, I do have limited programming skills.

 

I would also like the customer to display when there is a sales order and the vendor on a PO.

 

I could do it on the printed form but, we don’t usually print out time phased.

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, March 21, 2016 10:54 AM
To: vantage@yahoogroups.com
Subject: [Vantage] E9: Subcontract POs on Time Phase

 

 

Should subcontract POs show up on TimePhase?

 

 

Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.




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-6240 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."

We also created a subcontract dashboard.

 

The tabs are:

 

Send to supplier (no subcontract shipment record)

At Supplier

PO suggestion (means the job is created without a PO)

At Supplier

To be review – they came back but, have not been received to stock.

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, March 21, 2016 12:03 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E9: Subcontract POs on Time Phase

 

 

We are just now working on the sub-contact process and I couldn’t find them in time phase, so I wrote a dashboard to track them.

 

Here is the BAQ query.

for each PODetail no-lock  ,  each PORel no-lock  where (PODetail.Company = PORel.Company and PODetail.PONum = PORel.PONUM and PODetail.POLine = PORel.POLine ) and  PORel.JobSeqType = 'S' And PORel.OpenRelease = true .

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, March 21, 2016 2:53 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E9: Subcontract POs on Time Phase

 

 

I just want to make sure before I tell them to use the Subcontract Status Report.  The email they sent me sounded like it used to, but I cant verify that.

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, March 21, 2016 11:23 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E9: Subcontract POs on Time Phase

 

 

It would be nice -  but – when I looked at the Collection – in the detail area through customization  â€“ there isn’t any user defined fields that you can use.

 

But, I do have limited programming skills.

 

I would also like the customer to display when there is a sales order and the vendor on a PO.

 

I could do it on the printed form but, we don’t usually print out time phased.

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, March 21, 2016 10:54 AM
To: vantage@yahoogroups.com
Subject: [Vantage] E9: Subcontract POs on Time Phase

 

 

Should subcontract POs show up on TimePhase?

 

 

Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

 

Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

 



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-6240 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."