consignment payout issue
I just tripped over a silly issue: we have a few customers that have consignment items with us and once they sell I need to reimburse the customer for their portion of the sale. Most of these customers have multiple items that have sold for them over a number of separate transactions. Today I went to pay out a consignment customer for what we sold and the only way to do it is to refund each individual on account transaction from each payment on account separately. so if I have 10 separate payments to that customers account for consignment sales then I have to do 10 separate refunds with payment as "cheque" to get him his money??? If I was paying them cash from the till that would be horrendous!! this is a ton of extra unnecessary work!
Any solutions or work arounds?