Capital projects - link between AP and FA

Hi,

We have capital projects where all costs are coming from AP invoices. Audit team is looking for a report where it can link AP invoice line to an Asset. I looked at pa_project_asset_lines_all table and i see columns invoice_id and invoice_line_num. But i found for some invoice_id there are multiple assets and at the same time, few assets have lines belonging to multiple invoice_ids. And many invoice_line_number fields are NULL. Is it even worth to explore this option?

Other option is to split this into two - ap invoice to project/task links which any std report will provide. And write sql to get asset details by project/task and  merge these two.