Deltek , Wind2 report , Microsoft SQL 2005

A trial balance shows the balance of all the accounts during a period The total is always 0 I need this at a trnsactional level with the following fields Account number and name Project number and name Profit and Loss Grouping Supplier name Customer name User ID Entry ID Period Date Amount We need to build this query or report the easiest possible way