currently this uses the Sales Order header table, which only uses Sales orders data only. If a customer places an order, then has it credited, in Sales transactions table this balances, but as Sales Order Headers just uses Sales Orders, it looks like that order has not been credited, which means summarised values for this report are incorrect.