Loading Holiday Labor Records in Epicor 9

Epicor ERP 9
14

Here is our solution yet to be implemented but will work nice

  1. We build from an empty UD a holiday entry table. (You could use UDCodes as well but I want to build functionality into this screen that adds and removes the days from the production calendars as well)
  2. Already every night 1am we have a UBAQ with preproc advanced BPM on GetList run using the export method that creates labor records for everyone salaried (helps feed our payroll 3rd party). We don’t care about the query honestly it grabs top 1 record from company table
  3. When that runs the custom BPM code on the UBAQ would be updated to add holiday records for everyone or just the salaried records from the empbasic ud field. It would use a left join to figure out if today is a holiday.

It’s a bit over engineered, based on @timshuwy post from earlier, I feel like he would approve lol, but this is one of those things I would not want to have the task perpetually live in IT to manage holiday’s for the company using DMT.

1 Like