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.muruganan...@hotmail.com> Sent: Thursday, December 22, 2022 3:01 PM To: Alaa Zeineldine <a...@expertwell.com> Cc: gnucash-user@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 <a...@expertwell.com <mailto:a...@expertwell.com> > Sent: Wednesday, December 21, 2022 5:05 PM To: 'Murugan Muruganandam' <m.muruganan...@hotmail.com <mailto:m.muruganan...@hotmail.com> > Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> <gnucash-user@gnucash.org <mailto:gnucash-user@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....@gnucash.org <mailto:gnucash-user-bounces+alaa=expertwell....@gnucash.org> > On Behalf Of Alaa Zeineldine Sent: Wednesday, December 21, 2022 4:28 PM To: 'Murugan Muruganandam' <m.muruganan...@hotmail.com <mailto:m.muruganan...@hotmail.com> > Cc: gnucash-user@gnucash.org <mailto:gnucash-user@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.muruganan...@hotmail.com <mailto:m.muruganan...@hotmail.com> > Sent: Wednesday, December 21, 2022 3:41 PM To: Alaa Zeineldine <a...@expertwell.com <mailto:a...@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 <a...@expertwell.com <mailto:a...@expertwell.com> > Sent: Tuesday, December 20, 2022 9:27 PM To: 'Murugan Muruganandam' <m.muruganan...@hotmail.com <mailto:m.muruganan...@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.muruganan...@hotmail.com <mailto:m.muruganan...@hotmail.com> > Sent: Wednesday, December 21, 2022 1:58 AM To: Alaa Zeineldine <a...@expertwell.com <mailto:a...@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 <a...@expertwell.com <mailto:a...@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.muruganan...@hotmail.com <mailto:m.muruganan...@hotmail.com> > Sent: Tuesday, December 20, 2022 9:25 PM To: Alaa Zeineldine <a...@expertwell.com <mailto:a...@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....@gnucash.org <mailto:gnucash-user-bounces+m.muruganandam=hotmail....@gnucash.org> > on behalf of Alaa Zeineldine <a...@expertwell.com <mailto:a...@expertwell.com> > Sent: Tuesday, December 20, 2022 8:21 AM To: 'Dr. David Kirkby' <drkir...@kirkbymicrowave.co.uk <mailto:drkir...@kirkbymicrowave.co.uk> > Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> <mailto:gnucash-user@gnucash.org> <gnucash-user@gnucash.org <mailto:gnucash-user@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 <drkir...@kirkbymicrowave.co.uk <mailto:drkir...@kirkbymicrowave.co.uk> > Sent: Tuesday, December 20, 2022 4:38 AM To: Alaa Zeineldine <a...@expertwell.com <mailto:a...@expertwell.com> > Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> <mailto:gnucash-user@gnucash.org> Subject: Re: [GNC] Rounding discrepancy in payment processing On Tue, 20 Dec 2022 at 01:04, Alaa Zeineldine <a...@expertwell.com <mailto:a...@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, drkir...@kirkbymicrowave.co.uk <mailto:drkir...@kirkbymicrowave.co.uk> <mailto:drkir...@kirkbymicrowave.co.uk> <mailto:drkir...@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@gnucash.org <mailto:gnucash-user@gnucash.org> <mailto:gnucash-user@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@gnucash.org <mailto:gnucash-user@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@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.
