| Form Personalization-Check Duplicate AP Invoice [message #390929] |
Tue, 10 March 2009 06:23  |
yuni
Messages: 1
Registered: March 2009
|
Junior Member |
|
|
Hi,
I have created a table (invoice_test) which consist of 3 important fields namely: Vendor_ID, Invoice_Num, Invoice_Amt
In the AP invoice screen, when the user enter the Supplier Number and Invoice Number, the system would be able to check this invoice from the invoice_test table. If the the Vendor_ID and Invoice_Num is matched to what they have entered, prompt the msg: Invoice was previously entered in the Old system'.
How can I use Form Personalization to customize this function? Appreciate if someone can guide me. Thanks in advance.
|
|
|
|
| Re: Form Personalization-Check Duplicate AP Invoice [message #393813 is a reply to message #390929] |
Tue, 24 March 2009 08:14  |
SSGKK
Messages: 19
Registered: March 2009
|
Junior Member |
|
|
Follow the below steps
1. Open the Invoice Entry screen.
2. Choose from the menu, Help-> Diagnostics -> Custom Code -> Personalize. The personalization window will appear
3. Enter seq (any seq number), Description (Description about this customization), Level (choose function), Enabled (Checked).
4. On the Condition tab, choose, Trigger Event -> WHEN-VALIDATE-RECORD. Trigger Object -> INV_SUM_FOLDER (Invoice Block).
5. Enter the below text on the condition text field.
:system.record_status != 'QUERY'
AND (1 = (SELECT 1
FROM dual
WHERE EXISTS (SELECT 1
FROM invoice_test invtst
WHERE invtst.vendor_id = :inv_sum_folder.VENDOR_NUMBER
AND invtst.invoice_num = :inv_sum_folder.invoice_num
)))
The above code checks, if the form is not in query mode, then check if the vendor details already exists in the invoice_test table.
6. Choose processing mode -> "Not in Enter-Query Mode".
7. On the Action Tab, Enter Seq (Any seq number), Type -> Message, Description (Any meaninful description), Languages -> All, Enabled -. Checked.
8. On the Message Type, choose "Error", Message Text -> <Enter any message that you want to display>.
9. Save the changes.
The form has now be personalized to check for vendor and invoice details from the invoice_test table.
HTH
Cheers
SSGKK
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
