I have created a purchase agreement for specific vendor with specific items. Purchase Agreement is confirmed and is effective.
When creating purchase requisition having multiple line items, the items having effective purchase agreement get vendor, price and quantity information inherited from relevant agreement.
I have set the policy of Auto Purchase order creation from requisition & also set the parameter to keep the status of purchase orders generated from requisition to "Draft" status.
Requisition lines with reference to agreement or to which vendor have been added manually get their PO autogenerated.
Workflow
Workflow have been configured having a Approval with Automatic Action based on condition: "Purchase orders.Agreement header record ID" is field "Purchase orders.Agreement header record ID"
If condition is met then PO should get auto approved.
Otherwise, it should be submitted to the approval stage assigned user/role.
Issue:
Purchase orders with agreement reference do not get approved when submitted to workflow.
There is a column in Purchtable (All purchase orders grid) with the name "Purchase agreement". This column has a check mark against the orders having link to purchase agreement. its control name is "AgreementIsLinked" but it cannot be called in workflow condition.
Is there any other field I can use in workflow to get automatic action approve the PO when having effective purchase agreement reference.