Want to create "sub Revs" on Part Rev Detail

Epicor ERP 10
1

Hello All,

We’re looking to track small changes on Part revisions and we thought that doing an “Engineering Rev” field would be a good way to do so. The idea is that we don’t want to create a whole new revision if we just change out a screw for example but we still want to see those changes. I thought that we would be able to create a few custom fields on PartRev_UD, Eng Rev, ECN, and Eng Rev effective date on Part Rev sheet with ECN being a unique identifier. When we go from Part - Rev - EngRev we want to see each change. For example if we went from XXXXA1 to XXXXA2 we want to be able to see that. Currently when I change from 1 to 2, 2 just saves over the current row because I can’t assign ECN field as a unique identifier. Is there a way to set a custom field as a unique identifier? I also thought about using a UD table for this however I can’t seem to bind fields from the UD table to the Part Rev sheet.

2

Basically I want to Add a row with ECN as unique value rather than Update the row.

3

we already have this type of information gathered in the “Audit Log”… you can unapprove, checkout, Checkin, and approve multiple times against the same part/rev… and you get an audit log each time (if you have that setting turned on in Company setup). The audit log asks you what you did… it is then put onto the Audit Log tab under the revision.
if you want true before/after change tracking for comparisons, then the only real way to do that is to actually create a new rev. Note that you COULD have rev A, then for each minor change do something like rev A-1, A-2, so-on…

image
image.png742×209 8.23 KB

2 Likes
4

Thanks @timshuwy, this along with change log will work for us.