Page 1 of 1

Invoice validation package

Posted: Tue May 19, 2009 10:54 am
by akumar.oracle
Hi

I need to develop a package that validates invoice information and load the invoices into AR by running auto invoice daily.

Please can anyone help how to implement this.

cheers
Arvin

Posted: Tue May 19, 2009 12:11 pm
by oteixeira
Hello.
You can schedule Autoinvoice to run in a daily basis. Non valid invoices will be rejected.

Octavio

Posted: Tue May 19, 2009 1:03 pm
by akumar.oracle
what flag to check to see if particular invoice is not valid.

Posted: Tue May 19, 2009 1:09 pm
by oteixeira
Hello.

Check INTERFACE_STATUS from RA_INTERFACE_LINES_ALL.
If Autoinvoice populated this column with 'P', then the invoice has been sucessfully imported.

Octavio