OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » AP to GL Transfer

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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

Report message to a moderator

Re: AP to GL Transfer [message #237751 is a reply to message #237493]

Tue, 15 May 2007 10:33

world.apps
Messages: 70
Registered: January 2007
Location: Hyderabad

Member

Thanks

Report message to a moderator

Re: AP to GL Transfer [message #284468 is a reply to message #237493]

Thu, 29 November 2007 15:10

moon.golla
Messages: 2
Registered: November 2007
Location: india

Junior Member

it is very execllent answer

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

Re: AP to GL Transfer [message #387958 is a reply to message #237616]

Sun, 22 February 2009 12:13

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

Report message to a moderator

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.

Report message to a moderator

Re: TIE BACK FROM GL TO AP [message #427074 is a reply to message #427052]

Tue, 20 October 2009 23:20

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Have a look at this.

By
Vamsi

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 14:02:23 CDT 2025