I have created a custom entity called Fiscal Periods that contains a closed period date for each Business Unit. I am trying to prevent an invoice from posting if the closed period date has passed (e.g. end of previous month)
I have tried several approaches but I am hitting a dead end. What I want is a script that would run in the Invoice entity that checks the closed period date in the Fiscal Periods entity for the Bus Unit of the invoice and pops up an alert telling the user that the period has been closed.
Any help would be great. Let me know if you need more details.