I want to set up an event to automatically add an Approval template every time a Budget is created on a Work Order.I have an event I’ve used before, but looking at the key reference, I have two questions: Approval template links to the individual cost type, rather than the Work Order Budget total - is there a way to change this?If answer to above is approval can only be linked to cost type - WORKORDERBUDGET when selected in an event is missing the ‘WORK_ORDER_BUDGET_COST_TYPE_DB’ field which is used in the key reference - what is the best way to get this into the event - is there a SQL expression that can be added?i.e. Key Reference for approval template is - WO_NO=20287^WORK_ORDER_COST_TYPE_DB=E:

Question

Work Order - Budget Approval

Userlevel 3

+5

I want to set up an event to automatically add an Approval template every time a Budget is created on a Work Order.

I have an event I’ve used before, but looking at the key reference, I have two questions:

Approval template links to the individual cost type, rather than the Work Order Budget total - is there a way to change this?

If answer to above is approval can only be linked to cost type - WORKORDERBUDGET when selected in an event is missing the ‘WORK_ORDER_BUDGET_COST_TYPE_DB’ field which is used in the key reference - what is the best way to get this into the event - is there a SQL expression that can be added?

i.e. Key Reference for approval template is - WO_NO=20287^WORK_ORDER_COST_TYPE_DB=E:

Be the first to reply!