OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » relation b/w purchase order and ap invoices

Home » Applications » Oracle Fusion Apps & E-Business Suite » relation b/w purchase order and ap invoices (11i, ebs)

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

relation b/w purchase order and ap invoices [message #314015]

Tue, 15 April 2008 09:21

annu-agi
Messages: 238
Registered: July 2005
Location: Karachi

Senior Member

hi experts

i am finding ap invoices payments against the Purchase orders. where i can get this informations stores ..can anybody tells me where should i focus .. and in which tables i can get this information combination stores.

In the depth explans that i create 1 po and against that po i have received goods ..and now i create ap_invoice and create my liability and finally i paid- off these dues .. now question is the payment i made is against which PO ? in the application you can see but easily but where these information stored in tables ...i search all the ap tables and po tables but i failed to findout the relation between po and payments.

any help and any idea would be appriciatable

regards

Anwer

Report message to a moderator

Re: relation b/w purchase order and ap invoices [message #314181 is a reply to message #314015]

Wed, 16 April 2008 00:00

annu-agi
Messages: 238
Registered: July 2005
Location: Karachi

Senior Member

hi experts

i m still tring to locate where this combination made .. plese help me out of this problem ..
for your ease see the attachment snapshot below . i findout where it is located in application ..but when i apply query on this table it shows null .. not a single record comes .. why is this ..

regards

anwer
/forum/fa/4146/0/

Attachment: po match inoice.JPG
(Size: 113.20KB, Downloaded 1931 times)

Report message to a moderator

Re: relation b/w purchase order and ap invoices [message #317160 is a reply to message #314181]

Tue, 29 April 2008 14:03

Steve Corey
Messages: 336
Registered: February 2005
Location: RI

Senior Member

Hi Anwer,

For database structure questions, your best bet to find these connections are located on the eTRM's on metalink.oracle.com (requires registration). If you log into metalink, click the Knowledge tab, scroll down to the bottom of the page, under the heading ONLINE DOCUMENTATION you can find the eTRM link: Applications Electronic Technical Reference Manuals (eTRM). You simply provide your version of E-Business Suite, search under DBA Data for the schema (AP, PO, HR, etc.) in question.

To answer your question:

Invoices and PO's are matched at the distribution level of the respective documents. Here is a query you may find useful:

SELECT
 ai.invoice_num,
 ai.vendor_id,
 ph.segment1,                -- if this is your PO NUMBER field, depends on setup 
 pl.line_num,
 ps.shipment_num,
 pd.distribution_num  
FROM
 ap_invoices_all                    ai,
 ap_invoice_distributions_all       ad,
 po_distributions_all               pd,
 po_line_locations_all              ps,
 po_lines_all                       pl,
 po_headers_all                     ph
WHERE
 ai.invoice_id = ad.invoice_id
 AND ad.po_distribution_id = pd.po_distribution_id -- here is the link you are searching for 
 AND pd.line_location_id = ps.line_location_id
 AND ps.po_line_id = pl.po_line_id
 AND pl.po_header_id = ph.po_header_id
 AND ai.invoice_num = :invoice_number

Of course, you can play around with the selected fields and provide the necessary amount of information needed for whatever it is that you are doing. Cool

Report message to a moderator

Previous Topic:	error while applying receipts
Next Topic:	OM Step related to its interface!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 18:27:53 CST 2024