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[?]
Asset related invoices
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
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
Who is online
Users browsing this forum: No registered users and 6 guests