Goal: Change the LOV in “Supplier Name” field in the Find “Invoice Form (AP_APXINWKB)”
Navigation: Payables Manager > Entry > Invoices
Double Click it to open
In the first filed, Supplier Name change LOV In such a way that no one can see the TaxPayerID in LOV. It should be masked with *’s.
Navigation: Help Menu >> Diagnostics >> Custom Code >> Personalize
Enter the following information:
Disable Tax Payer Id
Not in Enter-Query Mode
Click on Actions and enter the following.
Create Record Group from Query
Argument: Paste your new SQL statement here. In this case it would be
SELECT vendor_name, vendor_number,
DECODE (active_flag, ‘Y’, ‘Yes’, ‘N’, ‘No’, ‘Yes’) active, ‘***’ num_1099,vat_registration_num, vendor_id, ”, ”, ”, ”, hold_all_payments_flag
WHERE num_active_pay_sites > 0 OR num_inactive_pay_sites > 0
ORDER BY UPPER (vendor_name)
Now Create New Record with below information
Click Apply Now.
Go to tools Menu >> click Validate All
Once it is successfully validated you are ready to go.
Click ok and close personalization form.
Close your find invoices form and invoices form completely.
Open it again and click on Supplier name field LOV
Query any supplier. You will see your changes to the LOV as shown below.
Now Taxpayer ID is shown as ***** instead of number