Refunds going the wrong way in customer account
Hello All,
I'm slowly working my way through customizing the reports for our use in Canada when I came across this little problem. It appears to me that refunds are going the wrong way within the customer accounts. Here is the actual example from the demo database that I have installed and been practicing on:
ID | Type | Amount |
113 | Opening Balance | 0.00 |
350 | Invoice | 35.00 |
375 | Invoice | 2066.03 |
414 | Invoice | 21.00 |
691 | Payment | -2000.00 |
693 | Refund | 100.00 |
696 | Payment - Reversal of 693 | -100.00 |
699 | Credit adjustment | -100.00 |
700 | Refund | 20.00 |
The account balance is given as $42.03 - incorrect.
The problem shows up in items 693 and 700 where the refunds are going in the same direction as a charge. It's not just a display problem here as the customers balance reflects the value as an additional amount owing. I thought that I might be making an error and should be inserting the refund as a negative amount, but a negative amount is not accepted. It also seems quite strange that when you reverse a refund, it shows up as a payment. So something is goofy.
I've seen in the forums that occasionally the refunds are going the wrong direction in some in reports... but the error here is actually within the customer account values as the displayed customer account balance increases after a refund is issued.
Is there a setting I'm missing or something as this seems pretty fundamental.
Thanks,
Sam Longiaru
Re: Refunds going the wrong way in customer account
OK... sorry for the noise...
In this case (I was imagining the client bringing something back) , I guess the proper thing would be to issue a credit adjustment... and only if that leaves us owing, issue the cash or credit refund to restore the balance to 0. Got it... I think.
Sam
Re: Refunds going the wrong way in customer account
The way I look at it is
A refund is money removed from the "till" and returned to the client
SO in effect it should appear as a debit on the customers bill.
A credit is an item that is returned by a customer and the value of which is creditted to the bill. So it appears as a credit.
An payment is the reverse of an refund becuase the client is giving you(the clinic) the money. and it is being placed in your till, thus it appears as a credit on the bill
A invoice is the reverse of the credit becaus you provide the owner with service or product and thus appears as a debit