Till Balance

Submitted by Guest on Thu, 13/08/2009 - 15:48

General User's Discussion

Was just wonering if anyone else has notice a problem with the Total Till Balance not equaling. I will explain. TOTAL CASH + TOTAL CHQS + TOTAL EFTPOS + TOTAL CREDIT CARD do not equal TOTAL BALANCE. It seems that this only occurs when their have been refunds processed during the till balancing period. (i.e. if any refunds have been processed during the till balancing period then TOTAL CASH + TOTAL CHQS + TOTAL EFTPOS + TOTAL CREDIT CARD do not equal TOTAL BALANCE.) However for periods where there were no refunds during the till balancing period then the problem doesn't occur. It is interesting to note however that the discrepancy does not always sum to the total refunds. Does anyone have any suggestion as to why this is occuring or is this occuring with anyone else.

Re: Till Balance

Submitted by Tony De Keizer (not verified) on Thu, 13/08/2009 - 18:00.

Hi ???,

I have to say I have not heard of this before. One thing to note though is the balance as shown in the table in the Till Balance workspace will be different to the balance shown on the printout as the former does not include the Cash Float amount.

Any other discrepancies would need to be investigated by seeing the actual printout and then working through the individual payments associated with the till balance and hopefully ascertaining why the discrepancy has occurred. This may be best worked through with your local implementer ?

Cheers Tony

On 13/08/09 3:48 PM, "kingswayvet@bigpond.com" :

> Was just wonering if anyone else has notice a problem with the Total Till > Balance not equaling. I will explain. TOTAL CASH + TOTAL CHQS + TOTAL EFTPOS

> + TOTAL CREDIT CARD do not equal TOTAL BALANCE. It seems that this only occurs

> when their have been refunds processed during the till balancing period. (i.e. > if any refunds have been processed during the till balancing period then TOTAL > CASH + TOTAL CHQS + TOTAL EFTPOS + TOTAL CREDIT CARD do not equal TOTAL > BALANCE.) However for periods where there were no refunds during the till > balancing period then the problem doesn't occur. It is interesting to note > however that the discrepancy does not always sum to the total > refunds.

_______________________________________________

OpenVPMS User

> Mailing List

users@lists.openvpms.org

To unsubscribe or change your

> subscription visit:

http://lists.openvpms.org/listinfo/users

Posts from this

> mailing list can be viewed online and replied to in the OpenVPMS User's forum- > http://tinyurl.com/openvfu

_______________________________________________ OpenVPMS User Mailing List users@lists.openvpms.org To unsubscribe or change your subscription visit: http://lists.openvpms.org/listinfo/users Posts from this mailing list can be viewed online and replied to in the OpenVPMS User's forum- http://tinyurl.com/openvfu

Till Balancing

Submitted by kingswayvet (not verified) on Tue, 25/08/2009 - 17:39.

Hi Tony

Just an update on the till balancing problem. I have also notice that sometime the end of transaction list total does not match the total till summary. Do you know why this happens

thanks

Jocelyn

Re: Till Balancing

Submitted by Tony De Keizer (not verified) on Wed, 26/08/2009 - 08:00.

Hi Jocelyn,

As mentioned in the previous post I have not seen this and cannot replicate so if you could provide me with a till balance listing noting the errors you found (email scanned printout with notes to me directly) then I am happy to investigate further.

Cheers Tony

On 25/08/09 5:39 PM, "kingswayvet@bigpond.com" :

> Hi Tony Just an update on the till balancing problem. I have also notice that

> sometime the end of transaction list total does not match the total till > summary. Do you know why this > happens

thanks Jocelyn _______________________________________________

OpenV

> PMS User Mailing List

users@lists.openvpms.org

To unsubscribe or change your

> subscription visit:

http://lists.openvpms.org/listinfo/users

Posts from this

> mailing list can be viewed online and replied to in the OpenVPMS User's forum- > http://tinyurl.com/openvfu

Till Balance

Submitted by tony on Sat, 29/08/2009 - 11:28.

Hi Jocelyn,

Thanks for the information on the Till Balancing issue you are experiencing. I managed to work out what is happening and it is related to when refunds are used to refund credits. The allocation between the credit and the refund is being displayed in the Till Blance report when it shouldn't be and thsi is causing the total on the printout to be out of balance with the sums of the individual payment type totals. You can see these incorrect entries listed as Refund - Credit and they have a +ve value.

Please noet they donot effect the on screen display of the balance or transactions, just the till balance report.

I have attached a modified till balance report that resolves this issue. I suggest users load this report using the following steps:

Save the attached new till balance report to a location on your system.
Goto Administration -> templates
Select the Till balance template (should have attached content tillBalance.jrxml)
Edit the template
Click on Content button and browse to location of saved report from 1. above
Select the new report and click Send
Click OK to Save the template

I suggest you test the printout just to make sure everything stills works OK.

Cheers

Tony

Attachment	Size
tillbalance 270809 fix.jrxml	39.38 KB

Re: Till Balance

Submitted by Matt C on Sat, 29/08/2009 - 16:00.

Thanks Tony and Jocelyn for fixing and finding this bug. It hasn't been detected on our system but have applied the fixed template no problems. Will see how it runs this afternoon!

Matt C

On Sat, 29 Aug 2009 01:28:05 +0000 (UTC), tony@openvpms.org wrote:

> Hi Jocelyn, > Thanks for the information on the Till Balancing issue you are > experiencing. I managed to work out what is happening and it is related

> to when refunds are used to refund credits. The allocation between the > credit and the refund is being displayed in the Till Blance report when it

> shouldn't be and thsi is causing the total on the printout to be out of > balance with the sums of the individual payment type totals. You can see

> these incorrect entries listed as Refund - Credit and they have a +ve > value. > Please noet they donot effect the on screen display of the balance or > transactions, just the till balance report. > I have attached a modified till balance report that resolves this issue.

> I suggest users load this report using the following steps: > > Save the attached new till balance report to a location on your system.

> Goto Administration -> templates > Select the Till balance template (should have attached content > tillBalance.jrxml) > Edit the template > Click on Content button and browse to location of saved report from 1.

> above > Select the new report and click Send > Click OK to Save the template > > I suggest you test the printout just to make sure everything stills works

> OK. > Cheers > Tony > > > File attachments: > > [tillbalance 270809 fix.jrxml]: > http://www.openvpms.org/fileuploads/tillbalance%20270809%20fix.jrxml > ---------- > Original attachments can be found at: > http://www.openvpms.org/forum/till-balance > _______________________________________________ > OpenVPMS User Mailing List > users@lists.openvpms.org > To unsubscribe or change your subscription visit: > http://lists.openvpms.org/listinfo/users > Posts from this mailing list can be viewed online and replied to in the > OpenVPMS User's forum- http://tinyurl.com/openvfu >

Re: New or updated comment for General User's Discussion Forum t

Submitted by kingswayvet (not verified) on Sat, 05/09/2009 - 09:28.

Hi Tony

Have you already loaded this report on to our system?

Thank Joss

----- Original Message -----
From: "tony"
To:
Sent: Saturday, August 29, 2009 9:28 AM
Subject: New or updated comment for General User's Discussion Forum topic:
Till Balance

Hi Joss, Yes. Cheers Tony

Submitted by tony on Sat, 05/09/2009 - 09:56.

Hi Joss,

Yes.

Cheers

Tony

Till Balance

Comment viewing options