Invoice Number Check
Dear All,
As there is seeded functionality in Oracle Payables to control duplication of Invoice Number and will not allow to enter an invoice with same details.
Normally users commit some mistakes then cancel the initial invoice and by specifying some special characters like giving dot,space they reenter invoice but this practice is needs to be controlled in proper way.
Please suggest how can we achieve by which some alert goes to Manager that similar details are re-entered.For eg:-
Normally users commit some mistakes then cancel the initial invoice and by specifying some special characters like giving dot,space they reenter invoice but this practice is needs to be controlled in proper way.
Please suggest how can we achieve by which some alert goes to Manager that similar details are re-entered.For eg:-
select * from ap_invoices_all
where invoice_num like '%105794%'
and vendor_id=2034
10006 2/11/2003 9:35:59 PM 1026 2034 105794
10000 2/11/2003 9:35:59 PM 1026 2034 105794
10004 2/11/2003 9:35:59 PM 1026 2034 CHQ NO. 105794
Tagged:
0