When using Map Reduce, all the script run as Administrator. One problem we have is that the Admin rol can post on G/L on closed periods. Other roles are simply blocked by default, but not the Admin one. Is there an alternative other than "manually" checking for the intended transaction date > get period > check if is period open?

I don't know if there's another way, but I would recommend you use the transaction's posting period field and not the transaction date, just in case the two are different.

It's not ideal, but currently I set the

trandate

, that updates the posting period, then I check if that posting period is open. All runs before submit.

I know our accounting team can select a posting period that differs from the transaction date for transactions such as vendor bills received after the period is closed. For example, they receive a bill dated after November is closed, the transaction date would be November 27, but the posting period would be January. In this case, detecting the posting period's closed status from the transaction date would show closed, when the posting period for the transaction is actually open.