You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Invoice Amount Calculation on Agreement Life Cycle

Received Response
21
Views
2
Comments
edited Mar 23, 2024 6:40AM in Payables, Payments & Cash Management 2 comments

Summary:

Does anyone know how the invoice amount on the Agreement Life Cycle is calculated?

Content (please ensure you mask any confidential information):

I am using the following query, which works in 99% of the cases. but in one BPA, the amount queried is incorrect - it's lower than what shows on the page.

select sum(aida.amount) as Invoiced_Amount

from 

  po_headers_all pha

  ,po_lines_all pla

  ,po_distributions_all pda

  ,ap_invoice_distributions_all aida

  ,ap_invoices_all aia


where pha.po_header_id = pla.po_header_id

and pha.po_header_id = pda.po_header_id

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!