Hello everyone,
Hoping to get some guidance on how to add system notes field on Journal entries as a condition in Transaction approval workflow as I am not able to find available fields.
Currently we have an approval workflow that stops the Next Approver from approving their own journal entry, ie if Created by = Next Approver then the Approve button won't show up.
But this should only apply for manual created journal entries, system generated entries such as Amortization and ARM journal entries should be excluded. For these journal
entries, the created by = Netsuite System ( set up as an employee record ) so
the Next Approver still can approve it.
Currently the process is that the Next Approver runs the revenue recognition process for ARM and when he clicks on the JE to review it, the Created By is set under his name ( Created by = Next Approver ) and therefore he can't Approve it.
My plan is
- Set up an employee record = Netsuite
- In the transaction workflow
Initiation stage, set field value Created By = Netsuite if condition is
{Createdby.id} = -4 . I have researched that apparently system user = -4 - set field value Created By = Current user if condition is {Createdby.id} != -4.
But this isn't sufficient. I want to also include a condition where if " condition is
{Createdby.id} = -4 AND context = bulk processing " then set field value created by = Netsuite.
Open to any other suggestions you might have.
Thank you
Liz