I am trying to run an AP report that shows all of the transactions for a month.  It needs to show the item description, the quantity, the price per quantity, total per transaction, and a running balance per vendor.  It also needs to show the split detail.  I can get the report to do everything I want, but as soon as I tell it to show the split detail, it adds an extra line for each one that negates the transaction so that I don't get a total balance by customer.  I get a balance of the debits and credits, but that is not the same as the total amount owed.  Because of the reporting I have to do, it must include all this information.  And I have to do this report for multiple vendors every month, so exporting to Excel to "finish" is an unreasonable option.

Any help is appreciated.