Thursday, August 5, 2010

Invoice Tracking from GL

Invoice back tracking from GL. some important tables are as under:

  • GL_JE_HEADERS
  • GL_HE_LINES
  • GL_IMPORT_REFERENCES
  • XLA_AE_LINES
  • XLA_AE_HEADERS
  • XLA_EVENTS
  • XLA_TRASACTION_ENTITIES_UPG
  • AP_INVOICES_ALL
  • AP_INVOICE_LINES_ALL
  • AP_INVOICE_DISTRIBUTIONS_ALL
A graphical relationship view is given below:



I hope diagram is very helpful to understand flow of invoice to GL.

1 comment:

  1. Assalamalaikum brother do u have any documents regarding rev/rec..revenue recognition...it ll b v helpful for me

    ReplyDelete