Changing LOV using Forms Personalization

 

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:

Seq:5

Description: Disable Tax Payer Id

Level: Form

Enabled: checked

 

Trigger Event: WHEN-NEW-FORM-INSTANCE

Condition:

Processing Mode: Not in Enter-Query Mode

 

 

 

 

 

Click on Actions and enter the following.

 

Seq:10

Type: Builtin

Language: all

Builtin type: 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

FROM po_vendors_ap_v

WHERE num_active_pay_sites > 0 OR num_inactive_pay_sites > 0

ORDER BY UPPER (vendor_name)

 

Group Name: ERP_SCHOOLS_ALL_VENDORS_NAME

 

 

 

Now Create New Record with below information

 

Seq:12

Type: Property

Language: All

Enabled: Checked

 

Object Type: LOV

Target Object: INV_ALL_VENDORS_NAME

Property Name: GROUP_NAME

Value: ERP_SCHOOLS_ALL_VENDORS_NAME

 

 

Save it.

 

Click Validate

 

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