Is there any query available to get the GL Transfer Date of a given AP Invoice
SummaryIs there any query available to get the GL Transfer Date of a given AP Invoice
We are developing a custom report in which I have to get following two information:
- Accounting Date, which is recorded in AP invoice header
- Actual GL Transfer Date
Is there any simple query available to get GL Transfer Date of a given invoice, without referring to subledger tables(xla_ae_headers)?
I am looking for something like:
Select get_gl_transfer_Date(invoice_id) from ap_invoices_all where invoice_num='INV-001'