Approval records not being created by Workflow

[andysummers]

Hi,

I've been trying to get workflow approvals running on a custom table in my instance but I'm a little stuck at the moment with the approval records not being generated. Basically, on the custom table record I have a UI Action button that sets the Approval field to 'Requested'   - this table is extended from task.

The workflow I have created is simple, it just has a Start --> Approval - User (with just my name mentioned as the user and no conditions --> Set Values ---> End

The workflow runs when the record's approval field is set to Requested - it shows in the Active Contexts list. If I view the workflow though it's gone from Start to Approval User but there is no approval record generated in the sysapproval_approver table. There are no emails generated, nothing. The context list now has many of my workflows running but there are no approval records to approve or reject. What am I missing ?

Thanks for the help

[andysummers · Accepted solution]

Found it - there was a business rule that has been created on our sysapproval_approver table to prevent manual approvals being created by checking whether the current.sysapproval.state = 30 or not.

I'm not sure why our supplier built this rule but I have added an exception to it so it allows the approvals to be generated on the custom tables I am working with.