[GNC] Rounding discrepancy in payment processing

Alaa Zeineldine alaa at expertwell.com
Thu Dec 22 18:37:00 EST 2022


Hello Murugan,

On my live setup rounding happens for all currencies, including the default currency. That is the problem for which I started this thread in the beginning. In addition, this rounding leads to discrepancies in payment processing.

Regards,

Alaa

 

From: Murugan Muruganandam <m.muruganandam at hotmail.com> 
Sent: Thursday, December 22, 2022 3:01 PM
To: Alaa Zeineldine <alaa at expertwell.com>
Cc: gnucash-user at gnucash.org
Subject: Re: [GNC] Rounding discrepancy in payment processing

 

hi Alaa

this is the behaviour i also observerd, so the rounding is controlled by the currency of the customer. so probably you can try a new customer in your existing install and check

 

 

 

Saludos Cordiales

 

Murugan

  _____  

From: Alaa Zeineldine <alaa at expertwell.com <mailto:alaa at expertwell.com> >
Sent: Wednesday, December 21, 2022 5:05 PM
To: 'Murugan Muruganandam' <m.muruganandam at hotmail.com <mailto:m.muruganandam at hotmail.com> >
Cc: gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>  <gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> >
Subject: RE: [GNC] Rounding discrepancy in payment processing 

 

Hello Murugan,
I went ahead and created a Yen A/R account under the default A/R account. I then added an invoice for your Yen based Customer 1, with a value of 236.78. The value of this invoice is rounded up in the totals and the A/R Aging report. On the other hand, values of the dollar-based customers are not affected. 
I also added an invoice to a dollar client. No rounding or discrepancies exhibited in this case.
This is closer to the behavior of my actual live setup, except that in my setup rounding happens for all clients, including dollar clients.
The resulting test .gnucash file is attached for your perusal.

Regards,

Alaa
-----Original Message-----
From: gnucash-user <gnucash-user-bounces+alaa=expertwell.com at gnucash.org <mailto:gnucash-user-bounces+alaa=expertwell.com at gnucash.org> > On Behalf Of Alaa Zeineldine
Sent: Wednesday, December 21, 2022 4:28 PM
To: 'Murugan Muruganandam' <m.muruganandam at hotmail.com <mailto:m.muruganandam at hotmail.com> >
Cc: gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> 
Subject: Re: [GNC] Rounding discrepancy in payment processing

Hello Murugan,

Thanks. I opened the file you sent and saw the new customer with the new invoice you created, which seems to be empty. 

I think the problems begin when an invoice with an amount is created. In this case, GC will require an A/R account with the same currency as the customer. That is when discrepancies begin to appear.

I have a question before I proceed with adding test invoices. In my original live setup, I have the non-dollar A/R accounts as children of the dollar (default) A/R account, so that the parent account always shows the total A/R amount.

• My question is whether this is the correct setup, and if not, where should the A/R accounts for the secondary currencies be placed?

Regards,

 

Alaa

 

From: Murugan Muruganandam <m.muruganandam at hotmail.com <mailto:m.muruganandam at hotmail.com> > 
Sent: Wednesday, December 21, 2022 3:41 PM
To: Alaa Zeineldine <alaa at expertwell.com <mailto:alaa at expertwell.com> >
Subject: Re: [GNC] Rounding discrepancy in payment processing

 

hi Alaa

 

i have created a customer called customer 1 with their currency as Yen.  i have created a invoice also for your reference. you can try creating new invoices with franctions for them and you can see the rounding

 

 

 

Saludos Cordiales

 

Murugan

  _____  

From: Alaa Zeineldine <alaa at expertwell.com <mailto:alaa at expertwell.com> >
Sent: Tuesday, December 20, 2022 9:27 PM
To: 'Murugan Muruganandam' <m.muruganandam at hotmail.com <mailto:m.muruganandam at hotmail.com> >
Subject: RE: [GNC] Rounding discrepancy in payment processing 

 

Hello Murugan,

 

I did lookup a number of customers, each of which had a USD currency, and their invoices were also USD, but rounding still occurs for them.

 

Can you elaborate on what you mean by “a customer currency with no fractions”?

 

Regards,

 

Alaa

 

From: Murugan Muruganandam <m.muruganandam at hotmail.com <mailto:m.muruganandam at hotmail.com> > 
Sent: Wednesday, December 21, 2022 1:58 AM
To: Alaa Zeineldine <alaa at expertwell.com <mailto:alaa at expertwell.com> >
Subject: Re: [GNC] Rounding discrepancy in payment processing

 

Alaa 

 

The rounding occurs based on the customer currency , so if your base currency and customer currency are USD , it will not have any problem , but in case you have a customer currency with no fractions , even when you create USD invoice it will round it , 

 

Can you look up one customer and tell me the currency of the customer and invoice currency 

 

 

Regard

 

Murugan

 

 

On 20-12-2022, at 18:22, Alaa Zeineldine <alaa at expertwell.com <mailto:alaa at expertwell.com> > wrote:

 

Hello Murugan,

 

Thanks for looking into this. I checked a number of customers, and each shows the currency that was entered when I created the customer initially. I also checked a number of invoices and found that the currency for the invoice was consistent with that of the customer.

 

Please note the reply to David Kirkby that I sent to the list. I created a minimal test .gnucash file with only one currency and tried a number of experiments with it. This did not exhibit the problem. This of course is much simpler than my real setup where I have clients with different currencies, and also bank accounts with different currencies.

 

Regards,

 

Alaa

 

From: Murugan Muruganandam <m.muruganandam at hotmail.com <mailto:m.muruganandam at hotmail.com> > 
Sent: Tuesday, December 20, 2022 9:25 PM
To: Alaa Zeineldine <alaa at expertwell.com <mailto:alaa at expertwell.com> >
Subject: Re: [GNC] Rounding discrepancy in payment processing

 

hi Alaa

 

Can you please do a quick check

 

1.      find customer
2.      view/edit
3.      Billing information 
4.      What currency is being shown in this .  

i was able to recreate the issue in a test file and i think this could be the issue.  

 

 

 

Saludos Cordiales

 

Murugan

  _____  

From: gnucash-user <gnucash-user-bounces+m.muruganandam=hotmail.com at gnucash.org <mailto:gnucash-user-bounces+m.muruganandam=hotmail.com at gnucash.org> > on behalf of Alaa Zeineldine <alaa at expertwell.com <mailto:alaa at expertwell.com> >
Sent: Tuesday, December 20, 2022 8:21 AM
To: 'Dr. David Kirkby' <drkirkby at kirkbymicrowave.co.uk <mailto:drkirkby at kirkbymicrowave.co.uk> >
Cc: gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>  <mailto:gnucash-user at gnucash.org>  <gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> >
Subject: Re: [GNC] Rounding discrepancy in payment processing 

 

Hello Dave,

 

Sounds reasonable. I will do this as soon as I get some free time this evening.

 

Regards,

 

Alaa

 

From: Dr. David Kirkby <drkirkby at kirkbymicrowave.co.uk <mailto:drkirkby at kirkbymicrowave.co.uk> > 
Sent: Tuesday, December 20, 2022 4:38 AM
To: Alaa Zeineldine <alaa at expertwell.com <mailto:alaa at expertwell.com> >
Cc: gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>  <mailto:gnucash-user at gnucash.org> 
Subject: Re: [GNC] Rounding discrepancy in payment processing

 

On Tue, 20 Dec 2022 at 01:04, Alaa Zeineldine <alaa at expertwell.com <mailto:alaa at expertwell.com> > wrote:

This is the first time I email to the list. So, I don't know if screenshots
will show up, but I am including below a succession of screenshots for a
fake customer invoice to demonstrate the problem.

 

 

Yes they do show up. It would probably be worth your while creating a test .gnucash file, emailing that, and let people see if they get the problem with your file. 



Thanks for your help.

 

Dave 

-- 

Dr. David Kirkby,
Kirkby Microwave Ltd, 
drkirkby at kirkbymicrowave.co.uk <mailto:drkirkby at kirkbymicrowave.co.uk>  <mailto:drkirkby at kirkbymicrowave.co.uk>  <mailto:drkirkby at kirkbymicrowave.co.uk> 
https://www.kirkbymicrowave.co.uk/
Telephone 01621-680100./ +44 1621 680100

Registered in England & Wales, company number 08914892. 
Registered office:
Stokes Hall Lodge, Burnham Rd, Althorne, Chelmsford, Essex, CM3 6DT, United Kingdom

_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>  <mailto: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.

_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org <mailto: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.



More information about the gnucash-user mailing list