Has anyone gotten a DMT to work for Production Calendar Maintenance? I am trying to add Non Working Days and not having any luck. I see there is an old Epicor Idea Log In - Epicor Identity that states it is in development and I tried to get an answer on it back in 2024 @timshuwy
1 Like
I have tried NO, False, 0 for ProdCalDay#WorkingDay - none work. I can add a record for Non Working Days using an UBAQ but not DMT.
That is very annoying. Any errors, or trace details… (you can use the trace in the settings at the bottom right of the DMT status bar)
Did you try adding the ProdCalDay#ExceptionLabel = Non Work Day
I did just try “Non Work Day” and still no luck.
If I run as “Add new” I get the error Company XXX CalendarID XXX Record already exists.
If I run as “Update” I get the error Company XXX CalendarID XXX Record not found.
I turned trace on and am looking at it but not seeing any errors. It seems to be showing all entries for the calendar.
Some more detail on the trace log. From what I see the “Add New” in DMT is using GetRows where the UBAQ using GetNew. Not sure if that is the issue.
Most DMTs need Add New and Update checked at the same time if you are adding/updating. Sounds counterintuitive I know.
1 Like
OMG…That did the trick! I normally only do “Update” so did not realize that for Add I had to have both checked. We use DMT on a limited basis. Thank you!
2 Likes