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
AP - Validation Date
-
- Posts: 463
- Joined: Thu Nov 09, 2006 4:50 pm
- Location: India
- Contact:
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.
One can use the LAST_UPDATE_DATE, but it can be any, need not be invoice validation action alone.
Who is online
Users browsing this forum: No registered users and 2 guests