Hi,
In Affiliate sales table I have canceled (I gues refunded is the same) order. But there is partner amount for sale. Not OK
I don't agree with you. Knowing whether a partner amount has been paid or not for a refunded order and how much is important. Plus, order statuses can be customized in System>Order statuses, so we don't necessarily know what status corresponds to what. So we decided to always displays the amount and whether it has been paid or not, regardless of the status of the order.
If I export all aff sales in mass actions from that partner, sales amount is there. Not OK
That's a problem with how you configured your mass action. You should add a filter on the order status to only take into account confirmed orders in your mass action if you don't want orders with another order status.