We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Is there any query available to get the GL Transfer Date of a given AP Invoice

Received Response
19
Views
3
Comments
edited Feb 1, 2021 7:33AM in Payables, Payments & Cash Management 3 comments

Summary

Is there any query available to get the GL Transfer Date of a given AP Invoice

Content

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'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!