Asset related invoices

[benny]

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[?]

[oteixeira]

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

[benny]

Thanks a lot Octavio