[GNC] Rounding discrepancy in payment processing

[David Cousens]

Hi Alaa,
I have tried duplicating what you report experiencing in GnuCash 4.12 running on
Linux Mint 21.0 (Vanessa) and do not get any of the behaviour you are reporting.
Invoice amounts are exactly as entered as are payment amounts in the payment
window and they are the same as the entered values  both in the register and in
the Customer report and both that and the A/R ageing report have the correct
totals. I don't use the business features routinely, but I have a test account
that has a dummy customer and vendor in which I tried duplicating your entries

We are going to need a bit more detail to try and identify  what may be causing
the behaviour you are experiencing. 

What operating system are you using?
Are you up to date with all OS updates?
How are you installing 4.12 on your computer( downloaded image , flatpak, built
from source)? 
Is the rounding occurring as you enter the amount in the invoice?
Is the rounding occurring in the payment window on entry
Is the amount shown in the A/R account register correct or rounded after posting
the invoice or making a payment?

As much detail as possible will help in identifying what is causing the problem.

David Cousens


On Mon, 2022-12-19 at 16:29 +0200, Alaa Zeineldine wrote:
> Hello,
> 
>  
> 
> This problem has been keeping me from upgrading from V 4.6 for some time,
> but I would like to move on to newer versions.
> 
>  
> 
> When I receive payment for an invoice amount that is not a whole number,
> (say $140.16), the Process Payment window rounds the fraction part of the
> amount. In this case the invoice value will show as $140.00. But the payment
> I receive is the exact amount. 
> 
>  
> 
> Until GC V4.6, I used to enter the correct amount in the payment field
> (140.16 here). GC seemed to handle this internally somehow and my books
> would appear balanced. Also, the A/R Aging report would show no outstanding
> balance for that customer. 
> 
>  
> 
> When I decided to upgrade to V4.8, the A/R Aging report showed many
> prepayments that did not actually exist in reality. These seemed to
> correspond to the fractional difference between the actual entered payment
> and the invoice amount after rounding for all previously settled invoices
> whose amounts were not whole numbers.
> 
> For example:
> 
>  
> 
> Invoice amount (rounded)           | Entered payment amount         |
> Prepayment
> 
> 140.16 (140.00)                                 | 140.16
> > 0.16
> 
> 450.78 (451.00)                                 | 450.78
> > (0.12)                 
> 
>  
> 
> Consequently, there was a cumulative prepayment for each customer equal to
> the net sum of these individual prepayments. Unless all of that customer's
> invoice amounts were whole numbers.
> 
>  
> 
> I reverted to V4.6, which did not exhibit this discrepancy in reporting,
> thinking that there will eventually be a release where this issue is
> resolved, but the releases I tried until now still had this issue.
> 
>  
> 
> Now, I upgraded to V4.12 and thought maybe I should do things differently.
> In the Process Payment window, instead of forcing the exact payment amount,
> I accepted the amount GC displays in the payment field by default, which
> matches the displayed (rounded) value of the invoice. I was hoping that
> since it keeps the correct value of the invoice internally, it may also do
> that for the default payment amount it computes. The result of this approach
> was OK for A/R reporting, but it led to an imbalance in the bank accounts
> where the payments are deposited, resulting from the difference between the
> real payment and the rounded value I accepted in the Process Payment window.
> 
>  
> 
> I prefer not to revert back to V4.6. So, is there something I am missing or
> perhaps doing wrong here. Any ideas?
> 
>  
> 
> Thanks.
> 
>  
> 
> Alaa Zeineldine
> 
>  
> 
>  
> 
>  
> 
>  
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.