Hi There -
I'm attempting to prevent users from generating an invoice in the current month IF the item fulfillment is dated in the previous month. Obviously related to COGS here, we'll have the IF picked, packed & shipped (posting at shipped), and usually the invoice is generated by the same user and saved. Using today as an example - we have item fulfillments shipped on September 28, and the invoice was not generated until 10/1. Now we have the ship transaction posted in September, and the sale/invoice posted in October.
The workaround has been to change the date on the item fulfillment in these cases - the user will go into the IF, date it to October, then save both transactions.
In my attempts to generate a user pop-up message, I set the following formula as criteria on the workflow, set on the Invoice transaction to show an alert that the IF is in the previous month from the created invoice -
TO_CHAR({trandate},'MONTH') != TO_CHAR({createdfrom.actualshipdate},'MONTH')
- but this formula is freezing up the transaction when I activate the workflow.
Anyone have a better approach for this? I really just want to prevent the month mismatch from IF to Invoice, and our workaround would be fine internally if this workflow would operate properly, is there something clearly wrong with my criteria formula?
Thanks