Invoices and Credit Note Reports

Our finance team currently use an Invoice Items for Period Report (Saved Report ID 2554) (Invoice Line Items) as well as Credit Note reports to be able to accurately export details of all invoices and credit notes generated for a period.

The need to do this as it has been identified that the Invoice Line items report does not identify invoices where they have been partially adjusted with a credit note, and will not show where a credit note has been created to refund a customer as you are unable to apply that to an invoice that has already been paid.

Is there a report that we can run that will do all this or is there a way that one can be created in consultation with the requirements of our Finance Team.