AP to GL Transfer [message #237493] |
Mon, 14 May 2007 11:37 |
world.apps
Messages: 70 Registered: January 2007 Location: Hyderabad
|
Member |
|
|
Hi,
Once we transfer the invoice data from Account Paybles 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?
Thanks in advance
|
|
|
Re: AP to GL Transfer [message #237616 is a reply to message #237493] |
Tue, 15 May 2007 04:02 |
oteixeira
Messages: 33 Registered: May 2007
|
Member |
|
|
Hi,
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
Hope this helps
Octavio
|
|
|
|
|
Re: TIE BACK FROM GL TO AP [message #386364 is a reply to message #237616] |
Sat, 14 February 2009 00:26 |
bharatt19
Messages: 7 Registered: February 2009 Location: banglore
|
Junior Member |
|
|
HYE FRND NICE ANSWER AND I DO HAVE A QUESTION
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. Any help you can offer would be appreciated.
THIS IS MY CUSTOMER REQUIREMENT ND ITS AP SUPPORT.
THANKS IN ADVANCE:
REGARDS
BHASKAR
|
|
|
Re: TIE BACK FROM GL TO AP [message #386599 is a reply to message #386364] |
Mon, 16 February 2009 03:52 |
oteixeira
Messages: 33 Registered: May 2007
|
Member |
|
|
Hello.
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>
Octavio
|
|
|
|
Re: TIE BACK FROM GL TO AP [message #427052 is a reply to message #386599] |
Tue, 20 October 2009 15:55 |
japaricio
Messages: 1 Registered: October 2009 Location: Mexico City
|
Junior Member |
|
|
Hi everyone.
This does same one also apply for the R12 version?
I want to make the Link between GL and AP.
I am preparing a report of taxes, and I need the number of the invoice and the supplier.
You say, when Source is Payable then reference_5 of GL_JE_LINES table is the invoice Number and reference_2 is the invoice_id and Ref3 is the check_id, but I do not have values in those fields.
Tks.
|
|
|
|