I see the problem with GnuCash 4.12 on Linux. My GnuCash is configured for a default of GBP. It's *very* weird. I have never seen this problem, but have accounts in Euro, GBP and USD.
On Wed, 21 Dec 2022 at 20:05, Alaa Zeineldine <a...@expertwell.com> wrote: > 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> > On Behalf Of Alaa Zeineldine > Sent: Wednesday, December 21, 2022 4:28 PM > To: 'Murugan Muruganandam' <m.muruganan...@hotmail.com> > Cc: 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> > Sent: Wednesday, December 21, 2022 3:41 PM > To: Alaa Zeineldine <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> < > 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> > 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> > 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> > 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. > _______________________________________________ > 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. > _______________________________________________ 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.
