Home » Applications » Oracle Fusion Apps & E-Business Suite » AP to GL Transfer
AP to GL Transfer [message #237493] Mon, 14 May 2007 11:37 Go to next message
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 Go to previous messageGo to next message
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: AP to GL Transfer [message #237751 is a reply to message #237493] Tue, 15 May 2007 10:33 Go to previous messageGo to next message
world.apps
Messages: 70
Registered: January 2007
Location: Hyderabad
Member
Thanks
icon9.gif  Re: AP to GL Transfer [message #284468 is a reply to message #237493] Thu, 29 November 2007 15:10 Go to previous messageGo to next message
moon.golla
Messages: 2
Registered: November 2007
Location: india
Junior Member
it is very execllent answer
Re: TIE BACK FROM GL TO AP [message #386364 is a reply to message #237616] Sat, 14 February 2009 00:26 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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: AP to GL Transfer [message #387958 is a reply to message #237616] Sun, 22 February 2009 12:13 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
@world.apps
Small correction in Octavio's answer:
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

By
Vamsi
Re: TIE BACK FROM GL TO AP [message #427052 is a reply to message #386599] Tue, 20 October 2009 15:55 Go to previous messageGo to next message
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.
Re: TIE BACK FROM GL TO AP [message #427074 is a reply to message #427052] Tue, 20 October 2009 23:20 Go to previous message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Have a look at this.

By
Vamsi
Previous Topic: Unable to attach libraries to template.fmb
Next Topic: export apps output file to excel format
Goto Forum:
  


Current Time: Mon Dec 23 19:12:05 CST 2024