We have a circumstance where the date in the invoice is being autopopulated with the next billing schedule date (which is set up correctly); however when the Billing schedules are not followed these dates can be from last year.
Secondarily the date field autopopulates the current date if no billing schedule is assigned to the project/SO
I was asked to create a 'show message' on the Transaction Record for the Invoices; that if the date is prior to the current month a friendly little reminder pops up stating Invoice is dated in a prior period do you want to continue.
I created a WF:
** Event on Create or Edit
I've also tried:
{trandate}<{createddate} and that doesn't work; so I think it is in the Client side trigger creation.
After testing workflow history shows that it executes and processes fine.
I would like the message to appear before record submit (which would be after edit on the client)
Not sure what I am doing wrong here, and could really use some guidance.
Thank you.