DMT Mass update Bill of Operations

Epicor ERP 10
1

So I am planning on mass updating Bill of Operations. Which table do I use? ECOOpr or PartOpr? And what is the difference between the two?

Thanks!

2

HI

EcoOpr is the table for the parts checked out to engineering workbench.

PartOpr is for updating the Part Rev

1 Like
3

First off, Why not use Mass Operation Update?

if you do go DMT, it is PartOpr. ECOOpr only temporarily holds the Opr’s while a change is being made via Engineering Workbench

1 Like
4

If you’re using the DMT, look under the Engineering tab for Bill of Operations.

PartOpr stores data for revisions that are NOT in the Engineering Workbench.

ECOOpr stores data for revisions that are checked out into the Engineering Workbench.

5

Where is this Mass Operation Update? I cannot find it.

6

Under Engineering.

Note that it is an across the board change. It will change every BOM that uses the ‘from Oper’ to the ‘to Oper’

image

1 Like
7

Hmmm, i do not have. I have admin access to the menus.

8

We have the Configurator module - which might include some “Advanced Engineering” programs.

DMT is just as good.

And with DMT you can selectively update which parents get changed. The Mass Operation Update does affect un-approved revisions (i.e. old revs)- Which might not be what you want.

Query the PartOpr table to get the records you want to change. Note that you might want to update the Oper Description too. The Mass Update defaults to leaving the Description unchanged.

1 Like