[GNC] Rounding discrepancy in payment processing

Wed Dec 21 15:05:07 EST 2022

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> On Behalf Of Alaa Zeineldine
Sent: Wednesday, December 21, 2022 4:28 PM
To: 'Murugan Muruganandam' <m.muruganandam at hotmail.com>
Cc: 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> 
Sent: Wednesday, December 21, 2022 3:41 PM
To: Alaa Zeineldine <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>  <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> 
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> 
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> 
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
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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: gcRoundingTest.gnucash
Type: application/x-gnucash
Size: 9000 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20221221/619c48b7/attachment.bin>