Reversing Cash Refund

Submitted by wespenhil on Wed, 30/08/2017 - 21:05

General User's Discussion

Would appreciate any help with this one to balance the books for the end of the month.

A staff member processed a credit incorrectly today. A client returned food and a credit invoice was generated for the product. A refund payment was then processed. The staff member accidently processed that refund as CASH when it should have been credit VISA. Our Till Balancing Report does not match our EFTPOS terminal. I have tried reversing the refund payment but get the following error message "Failed to validate Tendered of Cash: The tendered amount must be >= the amount".

Is there a way I can reverse the cash refund and re-issue it as a credit VISA refund so that OpenVPMS correlates with the EFTPOS terminal ?

Thanks,

Stephen

Re: Reversing Cash Refund

Submitted by tgething (not verified) on Thu, 31/08/2017 - 07:06.

Shephen - what version of OpenVPMS are you running. I have 1.9.2 running on one of my test systems. On that I can happily issue a cash refund and then reverse it - ie

The 4 relevant transactions are highlighted - the bottom one (3948284) is the original credit issued. The next up (3948286) is the [wrong] payment in cash. The next up (3948289) is its reversal, and the top one is the new payment via credit card.

You can also see that the two transactions 86 and 89 are hidden so that they don't show on the customer's statement.

So what version are you running?

NOTE: you say " Our Till Balancing Report does not match our EFTPOS terminal." The payments I did were cash and credit card - no EFTPOS transactions. I know that there are problems with reversing EFTPOS payments that include cash out - but this does not appear to fit your narrative.

Regards, Tim G

Re: Reversing Cash Refund

Submitted by wespenhil on Mon, 04/09/2017 - 11:45.

Hi Tim,

Thanks for your reply.

We are using OpenVPMS 1.8.

I have tried reversing the refund (922245) in multiple ways but always get the following error.

Regarding my comment about the EFTPOS terminal. When we run end of day we print a summary of all electronic payments from the terminal. We match that with the Till Balancing report. If a credit has gone through as cash on OpenVPMS but has been processed back onto the clients credit card through the EFTPOS terminal then the two will not match. OpenVPMS will be telling us to take less cash out from the register for banking than we should. Hope that makes sense.

Could this just be a glitch in version 1.8 ? Not sure how to correct this in the short term. In the long term upgrading to 1.9.2 would be the solution.

Thanks

Re: Reversing Cash Refund

Submitted by tgething (not verified) on Mon, 04/09/2017 - 12:44.

Stephen - I am away from home for a few days. When I get home I will fire up a 1.8 system on a spare machine and see if I can duplicate the problem.

I did run a comparison of the archetypes between 1.8 and 1.9.2 but the relevant ones have not changed (so I cannot say 'tweak this in the xxx archetype and this will fix it').

Upgrade to current release: I would strongly recommend a read of the 'new in release xxx' pages: http://www.openvpms.org/documentation/csh/1.9/new-features and http://www.openvpms.org/documentation/csh/2.0/new-features

1.9.2 is the current release; 1.9.3 is due out in the next month or so; and 2.0 maybe by Christmas. The 2.0 new features list is what the alpha test release currently includes and is NOT a final list of 2.0 new features.

In your place, I would be tempted to await the 1.9.3 release unless a) we can prove that your refund reversal problem is fixed in 1.9; or b) you look through the 'new in 1.9' list and see something that you have just got to have NOW.

Regards, Tim G

Re: Reversing Cash Refund

Submitted by wespenhil on Mon, 04/09/2017 - 12:56.

As an interesting aside I just tried the same purchase, refund, reversal of refund and re-issue of refund on our demo OpenVPMS (version 1.7.1). This worked fine. I was able to reverse a cash refund and re-issue it as a credit refund.

So I tried it with our practice account. Again was able to purchase, return for credit, issue a cash refund, reverse the cash refund and re-issue it as a credit card refund. See below.

So it may not be a version 1.8 problem at all. It could just be something with this patient file. I am not sure what. The reversal of transaction 922241 for the problem patient was done after I could not reverse the refund. Whether that now is interfering with the ability to change the refund I don't know.

I was planning to upgrade to 1.9.2 soon but yes I think I will hold off for 1.9.3.

Thanks Tim

Re: Reversing Cash Refund

Submitted by tgething (not verified) on Tue, 05/09/2017 - 08:10.

AHAH - found the problem (after staring at your 2nd post and thinking that $41.54 was a funny amount). It is a bug - see https://openvpms.atlassian.net/projects/OVPMS/issues/OVPMS-1947

Note that I cannot see how to fix the problem in your system (apart from some crude hacking of the database). Tim A may have a suggestion.

Regards, Tim G

Re: Reversing Cash Refund

Submitted by tgething (not verified) on Wed, 06/09/2017 - 16:20.

Stephen:

a) if you follow the above link to OVPMS-1947 you will see that Tim A has fixed this and the fix will be in the 1.9.3 release

b) you will also see that the workaround is to create the reversal of the refund MANUALLY - ie just create a cash payment for $41.54. You then manually hide both transactions this ending up with what the reversal of the refund would have done.

Regards, Tim G