ERPstuff - Oracle EBS Community

Hi Members,

I have a requirement from the client to see all the invoices that were created to become assets through Mass Additions in AP.

Is there any report that could give us all the invoices that have been tracked as assets?

Appreciate your assistance.

Rgrds
Ben[?]

Hello Ben.

I don't think there is such report.
You can retrieve those records through the following query:

SELECT i.invoice_num, v.vendor_name, d.amount
FROM ap_invoices_all i, po_vendors v, ap_invoice_distributions_all d
WHERE i.vendor_id = v.vendor_id
AND i.invoice_id = d.invoice_id
AND d.assets_addition_flag = 'Y'

Hope this helps.

Octavio

Thanks a lot Octavio