I need some help wit this one, please.
We have several hundred part operations that need to have the Days Out value updated. I’ve tried the basic methods I’m aware of, but no luck. When testing, the query reports the update was successful, but the updated value doesn’t ‘stick’.
Which table should I be updating? Using which method?
Thanks in advance!
Steve
What is your query?
Updating part revisions can only be done via Engineering Workbench (ECOMtl and ECOOpr, among others), and when you check the part back in from the ECO Group the PartMtl and PartOpr tables (among others) get updated… this is how Epicor enforces revision control. The best way to do this for “several hundred part operations” would be via DMT… and if you don’t have the DMT this would be a GREAT reason to buy it!
PartOpr is the table to update the Bill of Operations. Are you doing this via DMT?
if you use DMT, then you can do this by creating a spreadsheet that has some minimum number of fields, including the Part number, ECO Group, Plant, Rev, oper seq, etc… here is a screenshot of an excel spreadsheet I used to add/update a bunch of PartOpr records. Note that the ECOGroup needed to exist before i did the DMT Import… you can add more columns if you need to update more stuff…
Hello, and thanks Ernie.
I’ve tried a number of different approaches. Below are a couple:
for each ECOOpr no-lock , each ECORev no-lock where (ECOOpr.Company = ECORev.Company and ECOOpr.GroupID = ECORev.GroupID and ECOOpr.PartNum = ECORev.PartNum and ECOOpr.RevisionNum = ECORev.RevisionNum and ECOOpr.AltMethod = ECORev.AltMethod ) and ECORev.Approved = true , each ECOGroup no-lock where (ECORev.Company = ECOGroup.Company and ECORev.GroupID = ECOGroup.GroupID )
and…
for each Part no-lock , each PartOpr no-lock where (PartOpr.Company = Part.Company and PartOpr.PartNum = Part.PartNum ) , each PartRev no-lock where (PartOpr.Company = PartRev.Company and PartOpr.PartNum = PartRev.PartNum and PartOpr.RevisionNum = PartRev.RevisionNum and PartOpr.AltMethod = PartRev.AltMethod ).
Hi Cathy - no, unfortunately not! It certainly sounds like the way to go.
@timshuwy - I may have to convince the powers that be to open the checkbook for me to get the DMT
If I’m reading these comments correctly, the only method that will work for mass update of this field is using DMT. Bummer for me (at this moment)
Queries of the “ECO” tables will only find parts that are currently checked out to the Engineering Workbench, so depending on your process you might get some or no parts there. The Part query is the way to go to actually get the data you’re looking to change, but once you get it you’ll still need the DMT in order to change the Days Out value itself.
Depending on when you purchased Epicor, you may have received DMT as part of your base package. It may be as simple as installing it onto your system (which is a simple download).
