The simplest (and maybe hackiest) way to get your DD to fire wold be to schedule a Windows task, to run DMT via a powershell script, to “touch” the MscShpHd table at 12:01 each day.
Here’s a PS script I use to update a UD table, which has a DD tied to the field.
# This Script runs the Epicor DMT utility to update table UD05
# The change of UD05.Checkbox20 from 0 -> 1 initiates a Data Directive
# that generates the code to auto email shipping notices.
# This should be run at 4:00 PM EST every day
$DMTPath = "C:\Epicor\ERP10\LocalClients\PRD_102300\DMT.exe"
$User = "XXXXX"
$Pass = "XXXXX"
$Source = "C:\Temp\trigger.csv"
echo "Company,Key1,Key2,Key3,Key4,Key5,CheckBox20" > $Source
echo "MC,CKRU,,,,,1" >> $Source
echo "MC,CKRU,,,,,0" >> $Source
Start-Process -Wait -FilePath $DMTPath -ArgumentList "-NoUI -ConfigValue MATCOR -User $User -Pass $Pass -Update -Import UD05 -Source $Source "
It creates the CSV file (“trigger.csv”), then runs DMT, which basically toggles UD05.Checkbox20. A DD is set for when UD05.Checkbox20 goes from
true, and builds the email to send.