Form Personalization - Check Duplicate AP Invoice in R12
Form Personalization - Check Duplicate Invoice
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.
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.
0