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 

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

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

Regards
 
Ben 
OpenVPMS Installer and Helper 
Ph: +61423044823 
Email: info[at]charltonit.com[dot]au
Syndicate content