By using this website, you agree to our Terms of Use (click here)
Hi All
I have setup a business event and Notification Template that will email the sales team when a Promised On date is changed within a Purchase Order. This allows the sales team to proactively engage with customers to alert them to the changes.
The Notification Template has a html table in it listing the POLine's and their "new" promised on dates.
The team have asked me to add conditional formatting to the email where if the Promised On date has been moved to a later date the line is shown in red, if its been brought forward then it will show green. This will help them quickly identify if its good news or bad news for customers.
Does acumatica store the Last/Previous Promised On date in a table somewhere? If i could get this data within the system i could use this for the conditional formatting.
Any other ideas for this solution would be great!
Thanks all