Page 1 of 1
Tables involved to find the status of the invoices
Posted: Fri May 15, 2009 6:33 pm
by komirelli
What are the tables involved to find the status of invoices generated by auto invoice program....idea is to write a view from all the tables the hold invoice details and build a report on it to find the status of all invoices generated.....
thanks,
csrk
Posted: Fri May 29, 2009 11:29 pm
by siva sankar
Hi,
In every invoice it should come to following tables.
AP_INVOICES_ALL ---->Invoice Header level details
AP_INVOICE_DISTRIBUTIONS_ALL ---->invoice Distribution details
AP_HOLDS_ALL ----->Inovoice Hold Details
Thanks & regards,
Siva
Posted: Sat Jun 06, 2009 11:19 am
by karthikeyanp1981
Please be more clear komirelli, when framing questions...
U said invoices which often resembles Payables module.
U said Autoinvoice, which is run in receivables module for importing AR transactions from Order management or any external systems...
Have you got the answer required ?