Can anyone tell me if there is a date recorded in Epicor 9.05.702a for when a new part is first setup in Epicor? We could really use a system field like this for some of our sales reports.
Any information or suggestions would be welcome.
Thanks.
Hmm. I checked and could find no such field on the Part table. There are origin-type date fields in various ECO tables (if you created the part through the engineering workbench, then the group has a creation or approval date), and the PartRev table also, but that assumes you created a revision and are interested in its origin.
However, it sounds like you’re just looking for the create date of the Part record. I would create a post-processing Method directive that fires on event “Part.GetNewPart”. Add no criteria and for the action, select "Set the specified field of the changed row to the specific expression, substituting “Part.Date01” for "specified and the “Today” function for “specific” . This will help going forward, but you’d have to manually update that field for all existing parts.
No, most people add a UD field to track this. There is an enhancement request at the EUG (Epicor User’s Group). If you’re a member and want to vote:
http://www.epicorusers.net/enhancements/list_enhancements.php?enhID=1055
Mark W.
You can glean the information from change log if you have them setup. We set user and date in fields with a data directive.
Greg
If you have change logs turned on for the part master table. It will be
there.
Brad
Thank you all for the information and suggestions. Andrew, I tried your method and it seems to work perfectly, thank you!
My pleasure Lori. If you haven’t already (I’m a fairly new user of this site), select the post that resolved your issue and mark it resolved.