Page 1 of 1

AP - Validation Date

Posted: Thu Oct 16, 2008 6:31 am
by rajib.banerjee
Dear All,
I have a requirement in AP. My client wants to have creation of Invoice and validation of such invoice on separate dates and wants to record the same. Where can i find the Invoice validation date either from the front end or from any back end table.
Please help

Posted: Mon Oct 27, 2008 2:31 pm
by karthikeyanp1981
I don't think it is possible, the only table which stores the validation details of an invoice is AP_INVOICE_DISTRIBUTIONS_ALL table, in that table if the column MATCH_STATUS_FLAG has values as A then invoice is said to be in validation status, however there is no date field available in the table to capture the same.
One can use the LAST_UPDATE_DATE, but it can be any, need not be invoice validation action alone.