Create Invoice Approval Rule based on Supplier Income Tax Reportable Flags Utilizing SQL based DFF

Summary:

Create Invoice Approval Rule based on Supplier Income Tax Reportable Flags utilizing DFF based on sql at Invoice Header Level

Content (please ensure you mask any confidential information):

We have a business requirement where we want to route all invoices of the supplier which has Federal Reportable 'Y' and State Reportable Flag 'Y' enabled at Supplier Income Tax Level. (Attached Screenshot)

Since, these fields are not available as attributes while creating approval rule we are exploring other attributes below:

1. Invoice Header DFF: Create a DFF on Invoice Header which can be SQL based. It can derive the flag values from Supplier and update the invoice header DFF upon selection of Supplier. (Preferable if possible)