Project total costs

lawla

Hi
im pretty new to axapta and know nothing about accounting so forgive me if this sounds silly.

Recently i wrote a report for work detailing sales orders by invoice listing costs, amounts, margins etc

I would now like to replicate the same report for projects, my only problem is getting the total costs of each invoice for a project. As they seem to be divided up between many different tables, the structure of which i dont understand.

If anyone could suggest a way of doing this or how projects and their invoicing is divided up between all the tables would be great
thanks.