Invoice Data From Account
Payables To General Ledger
Once we transfer the invoice data from Account Payables
to General Ledger, in which column we can find the data is transfered or
not on back end?
Once the data is transfered to GL how to identify
the data that has come from AP module and how to find invoive number in
GL table?
About invoices, you can look at column POSTED_FLAG
on table AP_INVOICE_DISTRIBUTIONS_ALL.
In GL, you will know that data came from AP because
column JE_SOURCE on table GL_JE_HEADERS will be ‘Payables’
You can find the invoice number in table GL_JE_LINES,
column REFERENCE_2
Do you know of a view or sql query that can tie back
from GL to Payables at a detail transaction level. We are unable to do
this currently. We have an urgent request from management to provide this.
Solution:
This query gives you back supplier name and the invoice
accounting for a certain invoice:
select l.reference_1, cc.segment2,
l.reference_2, l.accounted_dr, l.accounted_cr
from gl_je_lines l, gl_code_combinations cc
where cc.code_combination_id = l.code_combination_id
and l.reference_5 = '<your invoice_num'
and l.period_name = '<your period_name>'
and l.set_of_books_id = <your set_of_books_id>
PS:
ap_invoice_distributions_all.posted_flag only tells you
whether the invoice is accounted in AP or not.
ap_ae_headers.gl_transfer_flag tells you whether the invoice
transferred to GL or not.
If AX is installed then you need to look for ax_sle_headers.gl_transfer_flag
Have a Oracle Question
Do
you have an Oracle Question?
Oracle Books
Oracle Certification,
Database Administration, SQL, Application, Programming Reference Books
Oracle Application
Oracle
Application Hints and Tips
Oracle Home
Oracle
Database, SQL, Application, Programming Tips
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
All product names are trademarks of their respective
companies.
The site www.erpgreat.com is not affiliated with or endorsed
by any company listed at this site.
Every effort is made to ensure the content integrity.
Information used on this site is at your own risk.
The content on this site may not be reproduced
or redistributed without the express written permission of
www.erpgreat.com or the content authors.
|