For integration with an external system - When the new job number is created by Epicor when the MRP job is firmed/released, where can we find the original MRP job number Epicor created? We want to keep the association in the external system.
If you mean the original unfirmed job number, that may get muddy as there isn’t a 1:1 link between the two, Epicor will recycle those unfirm job numbers so in practice you could have the same unfirm job # turn into N different firm jobs over time.
The only way that I can think of to capture that would be to turn on change logging for JobHead.JobNum and link to the changelog table.
1 Like
Thanks. If we use a function to firm and release, from REST API perhaps, will function capture the resulting job number and make the connection there?
That would most likely work. Your function would still have to capture that unfirm job # and stick it somehwhere for reference later, like a UD field on the JobHead table, before the job gets firmed up and the job # changes.
As far as Epicor is concerned, the unfirm job and the firm job it turns into are not related, so any relation between those two things would have to be something you come up with.
1 Like