Total and current balance vary

Hi,

I am wondering if others have noticed when printing a client Invoice that the total and the current balance sometimes vary by 1c.

I know 1c is not a huge thing but it looks a bit strange.

Thanks

Bernie

Comment viewing options

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

Re: Total and current balance vary

They should be the same. What happens if you go to Customers -> Account, and click Check for the customer where the balances disagree?

You'll need to be logged in as an administrator to do this.

-Tim

Re: Total and current balance vary

Hi Tim,

I have checked one and it says customer balance ok.

This is an invoice that has been paid but you can see balance and amount paid vary by 1c and they are not in credit. The items add up to $83.41 being the current balance and amount paid but the Total is rounded to $83.40

         TOTAL                           $ 83.40

         AMOUNT PAID                $ 83.41

         CURRENT BALANCE         $ 0.00          

 

Bernie

Re: Total and current balance vary

Just to be clear, is it only the invoice report that prints the incorrect total, or does the invoice total on screen also show $83.40?

If its just the report, then it sounds as though the report is doing some rounding.

 

-Tim

Re: Total and current balance vary

Hi Tim,

I had one yesterday.

I had not finalised the invoice so when I printed the invoice it only had the total amount ending in 88c, when I went to pay off the invoice the balance was 89c.

When I added up the items on the invoice they totaled 89c.

All a bit strange to the client when explaining the different amounts.

Bernie

Re: Total and current balance vary

Hi,

I believe the issue may be the invoiceitems template sums the individual entries printed on the invoice to display the total figure so it can do running totals for multi page invoices.  The Total is displayed to 2 decimal places on the invoice sub report which may display differently then the rounded figure for the invoice if some of the individual invoice items have totals not rounded to 2 decimal places ?

Cheers

Tony

Re: Total and current balance vary

Thanks Tony,

Is this something we can fix?

Bernie

Re: Total and current balance vary

This problem might occur if you have product prices in the database that go to 3 decimal places.

As far as I can tell, OpenVPMS rounds prices to 2 decimal places. However if they have been migrated from another system, they could go to 3 decimal places, and cause rounding errors.

-Tim

Re: Total and current balance vary

Hi Tim,

I have run a stock valuation report and the cost of product has many decimals but the total only has 2 decimals. I guess this is where the problem has come from when we migrated. Do you know if I would need to change the product price of every individual product or if there is any process that can be run to change the structure of multiple products back to 2 decimals.

Thanks

Bernie

Re: Total and current balance vary

Your implementer should be able to write some SQL to round product prices to 2 decimal places.

Invoices that used the old prices will have to remain unchanged.

-Tim

Syndicate content