Update Production Standards with DMT

I used ProdStandard.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, October 15, 2014 7:23 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Update Production Standards with DMT

 

 

Hello, I need to update the production standard for each operation as we would like to get them more inline with actuals.

 

Using the DMT, I selected Engineering > Bill Of Operations and created this template:

 

Company,PartNum,RevisionNum,OprSeq,OpCode,Plant,ECOGroupID,EstProdHours

 

I then created a CSV file with this info:

 

Company,PartNum,RevisionNum,OprSeq,OpCode,Plant,ECOGroupID,EstProdHours
CAL,1234-7,A,0,10,MfgSys,METHODS - REVISIONS,0.01
CAL,1234-7,A,0,20,MfgSys,METHODS - REVISIONS,7.95
CAL,1234-7,A,0,30,MfgSys,METHODS - REVISIONS,2.64
CAL,1234-7,A,0,40,MfgSys,METHODS - REVISIONS,0.81
CAL,1234-7,A,0,50,MfgSys,METHODS - REVISIONS,0.8
CAL,1234-7,A,0,60,MfgSys,METHODS - REVISIONS,0.17
CAL,1234-7,A,0,70,MfgSys,METHODS - REVISIONS,0.3

 

I checked Update and then clicked Process. It finished without errors and looked like it worked. It created this completed log file:

 

2014-10-15T11:08:08  RPM 58  1234-7 0
2014-10-15T11:08:09  RPM 76  1234-7 0
2014-10-15T11:08:09  RPM 85  1234-7 0
2014-10-15T11:08:10  RPM 92  1234-7 0
2014-10-15T11:08:10  RPM 100  1234-7 0
2014-10-15T11:08:11  RPM 103  1234-7 0
2014-10-15T11:08:51  RPM 10  1234-7 0

Import:  Bill Of Operations
Started: 15-Oct-2014 11:08:07 AM
Finished: 15-Oct-2014 11:08:51 AM
Duration: 00.00:00:43
Records: 7/7
RPM:  10
Errors:  0
Version: DMT 1.0.4.6 HF7 for 9.05.702
AppServer: AppServerDC://epicortest:9401

 

When I go into Epicor, it doesn't look like anything changed. None of the production standards got updated... as far as I can tell (ran a BAQ on ECO Opr).

 

How do I do this? Thanks!

Hello, I need to update the production standard for each operation as we would like to get them more inline with actuals.


Using the DMT, I selected Engineering > Bill Of Operations and created this template:


Company,PartNum,RevisionNum,OprSeq,OpCode,Plant,ECOGroupID,EstProdHours


I then created a CSV file with this info:


Company,PartNum,RevisionNum,OprSeq,OpCode,Plant,ECOGroupID,EstProdHours
CAL,1234-7,A,0,10,MfgSys,METHODS - REVISIONS,0.01
CAL,1234-7,A,0,20,MfgSys,METHODS - REVISIONS,7.95
CAL,1234-7,A,0,30,MfgSys,METHODS - REVISIONS,2.64
CAL,1234-7,A,0,40,MfgSys,METHODS - REVISIONS,0.81
CAL,1234-7,A,0,50,MfgSys,METHODS - REVISIONS,0.8
CAL,1234-7,A,0,60,MfgSys,METHODS - REVISIONS,0.17
CAL,1234-7,A,0,70,MfgSys,METHODS - REVISIONS,0.3


I checked Update and then clicked Process. It finished without errors and looked like it worked. It created this completed log file:


2014-10-15T11:08:08  RPM 58  1234-7 0
2014-10-15T11:08:09  RPM 76  1234-7 0
2014-10-15T11:08:09  RPM 85  1234-7 0
2014-10-15T11:08:10  RPM 92  1234-7 0
2014-10-15T11:08:10  RPM 100  1234-7 0
2014-10-15T11:08:11  RPM 103  1234-7 0
2014-10-15T11:08:51  RPM 10  1234-7 0

Import:  Bill Of Operations
Started: 15-Oct-2014 11:08:07 AM
Finished: 15-Oct-2014 11:08:51 AM
Duration: 00.00:00:43
Records: 7/7
RPM:  10
Errors:  0
Version: DMT 1.0.4.6 HF7 for 9.05.702
AppServer: AppServerDC://epicortest:9401


When I go into Epicor, it doesn't look like anything changed. None of the production standards got updated... as far as I can tell (ran a BAQ on ECO Opr).


How do I do this? Thanks!

Sorry, that was attempt #2, which failed because I tried updating the 'EstProdHours' column. My first attempt I tried updating 'ProdStandard', which looked like it worked, but didn't seem to update anything in Epicor.
Just to wrap this up, I mistook Operation Sequence for Assembly Sequence. So in my template file I put ...0, 10..., when it should have read ...10, Layup... Problem solved and I can now safely update all of our operations so they're more in line with actuals for next year.