PO Form personalization for recoverable tick

Dear Team,

We have put PO form persanalization that, for all recoverable Taxes, recoverable tick should appear for all PO lines, otherwise we are not allowing PO to get approved.

For this we have checked data in jai_tax_lines_v and jai_tax_types view for concern PO.

But what we observed ,in some cases there is recoverable tick and rec amount in these views, but it is found unticked and rec tax amount 0 in Form/screen.

So our personalization is getting failed becuase of some form level coding.

We developed following script to check recoverable tick

            select jtl.RECOVERABLE_FLAG transaction_recoverable_flag, jtt.RECOVERABLE_FLAG tax_type_recoverable_flag, JTL.REC_TAX_AMT_TRX_CURR