![\"alt\"](\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1253_Changedispl1.jpg\")
<\/p>\nGoal:\u00a0Change the LOV in “Supplier Name” field in the Find “Invoice Form (AP_APXINWKB)”<\/p>\n
Navigation: Payables Manager > Entry > Invoices<\/p>\n
<\/p>\n
Double Click it to open<\/p>\n
![\"alt\"](\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1253_Changedispl2.jpg\")
<\/p>\n
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.<\/p>\n
![\"alt\"](\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1253_Changedispl3.jpg\")
<\/p>\n
Navigation: Help Menu >> Diagnostics >> Custom Code >> Personalize<\/p>\n
![\"alt\"](\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1253_Changedispl4.jpg\")
<\/p>\n
Enter the following information:<\/p>\n
Seq: 5<\/p>\n
Description:
\nDisable Tax Payer Id<\/p>\n
Level:
\nForm<\/p>\n
Enabled:
\nchecked<\/p>\n
Trigger Event:
\nWHEN-NEW-FORM-INSTANCE<\/p>\n
Condition:<\/p>\n
Processing Mode:
\nNot in Enter-Query Mode<\/p>\n
![\"alt\"](\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1253_Changedispl5.jpg\")
<\/p>\n
Click on Actions and enter the following.<\/p>\n
Seq: 10<\/p>\n
Type:
\nBuiltin<\/p>\n
Language:
\nall<\/p>\n
Builtin type:
\nCreate Record Group from Query<\/p>\n
Argument: Paste your new SQL statement here. In this case it would be<\/p>\n
SELECT vendor_name, vendor_number,<\/p>\n
DECODE (active_flag, ‘Y’, ‘Yes’, ‘N’, ‘No’, ‘Yes’) active, ‘***’ num_1099,vat_registration_num, vendor_id, ”, ”, ”, ”, hold_all_payments_flag<\/p>\n
FROM po_vendors_ap_v<\/p>\n
WHERE num_active_pay_sites > 0 OR num_inactive_pay_sites > 0<\/p>\n
ORDER BY UPPER (vendor_name)<\/p>\n
Group Name:
\nERP_SCHOOLS_ALL_VENDORS_NAME<\/p>\n
![\"alt\"](\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1253_Changedispl6.jpg\")
<\/p>\n
Now Create New Record with below information<\/p>\n
Seq:12<\/p>\n
Type:
\nProperty<\/p>\n
Language:
\nAll<\/p>\n
Enabled:
\nChecked<\/p>\n
Object Type:
\nLOV<\/p>\n
Target Object:
\nINV_ALL_VENDORS_NAME<\/p>\n
Property Name:
\nGROUP_NAME<\/p>\n
Value:
\nERP_SCHOOLS_ALL_VENDORS_NAME<\/p>\n
![\"alt\"](\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1253_Changedispl7.jpg\")
<\/p>\n
Save it.<\/p>\n
Click Validate<\/p>\n
Click Apply Now.<\/p>\n
Go to tools Menu >> click Validate All<\/p>\n
![\"alt\"](\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1253_Changedispl8.jpg\")
<\/p>\n
Once it is successfully validated you are ready to go.<\/p>\n
Click ok and close personalization form.<\/p>\n
Close your find invoices form and invoices form completely.<\/p>\n
Open it again and click on Supplier name field LOV<\/p>\n
Query any supplier. You will see your changes to the LOV as shown below.<\/p>\n
![\"alt\"](\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/041711_1253_Changedispl9.jpg\")
<\/p>\n
Now Taxpayer ID is shown as ***** instead of number<\/p>\n","protected":false},"excerpt":{"rendered":"
Goal:\u00a0Change 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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,15,11],"tags":[81,82,83],"class_list":["post-1639","post","type-post","status-publish","format-standard","hentry","category-articles","category-personalization","category-tools","tag-forms-2","tag-lov","tag-personalization-2"],"yoast_head":"\n