David, I just stumbled through this issue as well. I was able to get a $2,000 customer credit to show as a payment on a new invoice by doing the following steps:
1) create new invoice and post to A/R. 2) select new invoice and make payment. 3) when the payment window opens select the outstanding credit plus the new invoice amount. 4) in the payment amount section enter $0.00. This should apply the credit to the new invoice. 5) print new invoice. When printing new invoice select the Options tab then Diplay tab and make sure "payments" are selected to print. 6) print new invoice as PDF and verify the customer credit was applied Hope this helps. -Ryan -----Original Message----- From: gnucash-user <gnucash-user-bounces+ryan=6040design....@gnucash.org> On Behalf Of gnucash-user-requ...@gnucash.org Sent: Friday, June 3, 2022 1:49 AM To: gnucash-user@gnucash.org Subject: gnucash-user Digest, Vol 231, Issue 4 Send gnucash-user mailing list submissions to gnucash-user@gnucash.org To subscribe or unsubscribe via the World Wide Web, visit https://lists.gnucash.org/mailman/listinfo/gnucash-user or, via email, send a message with subject or body 'help' to gnucash-user-requ...@gnucash.org You can reach the person managing the list at gnucash-user-ow...@gnucash.org When replying, please edit your Subject line so it is more specific than "Re: Contents of gnucash-user digest..." Today's Topics: 1. Re: Invoice showing balance due (Derek Atkins) 2. Re: Invoice showing balance due (David Burleigh) 3. Re: Invoice showing balance due (Derek Atkins) 4. Re: Invoice showing balance due (David Burleigh) 5. Re: Strange incorrect due date calculated on a duplicated bill (Adrien Monteleone) 6. Re: Strange incorrect due date calculated on a duplicated bill (Geert Janssens) 7. Re: Strange incorrect due date calculated on a duplicated bill (Geert Janssens) 8. Re: Invoice showing balance due (Geert Janssens) 9. Re: Invoice showing balance due (Adrien Monteleone) 10. Re: Strange incorrect due date calculated on a duplicated bill (Adrien Monteleone) 11. Switching from Quickbooks and getting started (Christine McSweeney) 12. Re: Switching from Quickbooks and getting started (Jim DeLaHunt) 13. Re: Balance Sheet mismatch (Fred Tydeman) 14. Re: Balance Sheet mismatch (davidcousen...@gmail.com) ---------------------------------------------------------------------- Message: 1 Date: Thu, 2 Jun 2022 12:05:13 -0400 From: "Derek Atkins" <de...@ihtfp.com> To: "David Burleigh" <david.burle...@saphar.net> Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Invoice showing balance due Message-ID: <b704ccfcea0af1ea0188e3cbf28ee89e.squir...@mail2.ihtfp.org> Content-Type: text/plain;charset=utf-8 On Thu, June 2, 2022 11:49 am, David Burleigh wrote: > On Thu, 2022-06-02 at 11:44 -0400, Derek Atkins wrote: [snip] >> So you're not actually telling GnuCash to *add* existing credits. >> You need to do that so GnuCash knows you want to apply them to *this* >> invoice (instead of waiting to apply them to another invoice). >> >> Do that, and then turn on "Show Payments" in the report options. >> >> -derek > > But how do you tell it to add existing credits to a new invoice? I > don't see that option anywhere in the interface. After you post you need to Process Payment to attach the credit. Unfortunately GnuCash no longer auto-applies credits. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ------------------------------ Message: 2 Date: Thu, 02 Jun 2022 12:07:26 -0400 From: David Burleigh <david.burle...@saphar.net> To: Derek Atkins <de...@ihtfp.com> Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Invoice showing balance due Message-ID: <b29496278af2ed3e82b0f49bff451a6db76c4410.ca...@saphar.net> Content-Type: text/plain; charset="UTF-8" On Thu, 2022-06-02 at 12:05 -0400, Derek Atkins wrote: > > On Thu, June 2, 2022 11:49 am, David Burleigh wrote: > > On Thu, 2022-06-02 at 11:44 -0400, Derek Atkins wrote: > [snip] > > > So you're not actually telling GnuCash to *add* existing credits. > > > You need to do that so GnuCash knows you want to apply them to > > > *this* > > > invoice (instead of waiting to apply them to another invoice). > > > > > > Do that, and then turn on "Show Payments" in the report options. > > > > > > -derek > > > > But how do you tell it to add existing credits to a new invoice? I > > don't see that option anywhere in the interface. > > After you post you need to Process Payment to attach the credit. > Unfortunately GnuCash no longer auto-applies credits. > > -derek > Too bad. So I have to edit the printed invoice manually to indicate the account balance. Well, thanks for your time.? ------------------------------ Message: 3 Date: Thu, 2 Jun 2022 12:17:18 -0400 From: "Derek Atkins" <de...@ihtfp.com> To: "David Burleigh" <david.burle...@saphar.net> Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Invoice showing balance due Message-ID: <a7f2133554cd6ea74d69964bfce0bf63.squir...@mail2.ihtfp.org> Content-Type: text/plain;charset=utf-8 Hi, On Thu, June 2, 2022 12:07 pm, David Burleigh wrote: > On Thu, 2022-06-02 at 12:05 -0400, Derek Atkins wrote: >> >> > But how do you tell it to add existing credits to a new invoice? I >> > don't see that option anywhere in the interface. >> >> After you post you need to Process Payment to attach the credit. >> Unfortunately GnuCash no longer auto-applies credits. >> >> -derek >> > > Too bad. So I have to edit the printed invoice manually to indicate > the account balance. Well, thanks for your time.? No, that's not at all what I said. I said you have to tell GnuCash to apply the outstanding credit to the new invoice by using Process Payment. And then you need to go into the Report Options and tell GnuCash to display the payments attached to the invoice. You do NOT need to edit the printed invoice manually. By the way, there is another option that may suit you. Your other option is to use the Customer Report, which will list all the invoices and payments and provide an account balance. -derek -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ------------------------------ Message: 4 Date: Thu, 02 Jun 2022 12:18:47 -0400 From: David Burleigh <david.burle...@saphar.net> To: Derek Atkins <de...@ihtfp.com> Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Invoice showing balance due Message-ID: <7287aab6a455a755e41f0f7e5277d19add4aa4dc.ca...@saphar.net> Content-Type: text/plain; charset="UTF-8" On Thu, 2022-06-02 at 12:17 -0400, Derek Atkins wrote: > Hi, > > On Thu, June 2, 2022 12:07 pm, David Burleigh wrote: > > On Thu, 2022-06-02 at 12:05 -0400, Derek Atkins wrote: > > > > > > > But how do you tell it to add existing credits to a new invoice? > > > > I don't see that option anywhere in the interface. > > > > > > After you post you need to Process Payment to attach the credit. > > > Unfortunately GnuCash no longer auto-applies credits. > > > > > > -derek > > > > > > > Too bad. So I have to edit the printed invoice manually to indicate > > the account balance. Well, thanks for your time.? > > No, that's not at all what I said. > > I said you have to tell GnuCash to apply the outstanding credit to the > new invoice by using Process Payment.? And then you need to go into > the Report Options and tell GnuCash to display the payments attached > to the invoice. > > You do NOT need to edit the printed invoice manually. > > By the way, there is another option that may suit you.? Your other > option is to use the Customer Report, which will list all the invoices > and payments and provide an account balance. > > -derek > Oh, ok. Thank you! ------------------------------ Message: 5 Date: Thu, 2 Jun 2022 11:22:40 -0500 From: Adrien Monteleone <adrien.montele...@lusfiber.net> To: gnucash-u...@lists.gnucash.org Subject: Re: [GNC] Strange incorrect due date calculated on a duplicated bill Message-ID: <t7ao4g$j66$1...@ciao.gmane.io> Content-Type: text/plain; charset=UTF-8; format=flowed Indeed, testing both 2020 and 2022 November dates result in a 19day due date rather than 20. I also tested the March dates for moving from standard to daylight time and those worked correctly. (they didn't add a day) Should I go ahead and file a bug? Regards, Adrien On 6/2/22 1:14 AM, Geert Janssens wrote: > A quick test would be to post an invoice on such a date in other years, for example on the day summer time switched to standard time in 2020 or will change in 2022. ------------------------------ Message: 6 Date: Thu, 02 Jun 2022 18:48:31 +0200 From: Geert Janssens <geert.gnuc...@kobaltwit.be> To: gnucash-u...@lists.gnucash.org, gnucash-user@gnucash.org Cc: adrien.montele...@lusfiber.net Subject: Re: [GNC] Strange incorrect due date calculated on a duplicated bill Message-ID: <4717020.gxafrqv...@legolas.kobaltwit.lan> Content-Type: text/plain; charset="us-ascii" Op donderdag 2 juni 2022 18:22:40 CEST schreef Adrien Monteleone: > Indeed, testing both 2020 and 2022 November dates result in a 19day > due date rather than 20. > > I also tested the March dates for moving from standard to daylight > time and those worked correctly. (they didn't add a day) > > Should I go ahead and file a bug? > Please do. It looks like the due date calculation is doing something wrong when daylight saving time gets reverted. Regards, Geert ------------------------------ Message: 7 Date: Thu, 02 Jun 2022 18:48:31 +0200 From: Geert Janssens <geert.gnuc...@kobaltwit.be> To: gnucash-u...@lists.gnucash.org, gnucash-user@gnucash.org Cc: adrien.montele...@lusfiber.net Subject: Re: [GNC] Strange incorrect due date calculated on a duplicated bill Message-ID: <4717020.gxafrqv...@legolas.kobaltwit.lan> Content-Type: text/plain; charset="us-ascii" Op donderdag 2 juni 2022 18:22:40 CEST schreef Adrien Monteleone: > Indeed, testing both 2020 and 2022 November dates result in a 19day > due date rather than 20. > > I also tested the March dates for moving from standard to daylight > time and those worked correctly. (they didn't add a day) > > Should I go ahead and file a bug? > Please do. It looks like the due date calculation is doing something wrong when daylight saving time gets reverted. Regards, Geert ------------------------------ Message: 8 Date: Thu, 02 Jun 2022 18:50:15 +0200 From: Geert Janssens <geert.gnuc...@kobaltwit.be> To: David Burleigh <david.burle...@saphar.net>, gnucash-user@gnucash.org, Derek Atkins <de...@ihtfp.com> Subject: Re: [GNC] Invoice showing balance due Message-ID: <2831905.e9j7nak...@legolas.kobaltwit.lan> Content-Type: text/plain; charset="us-ascii" Op donderdag 2 juni 2022 18:05:13 CEST schreef Derek Atkins: > On Thu, June 2, 2022 11:49 am, David Burleigh wrote: > > On Thu, 2022-06-02 at 11:44 -0400, Derek Atkins wrote: > [snip] > > >> So you're not actually telling GnuCash to *add* existing credits. > >> You need to do that so GnuCash knows you want to apply them to > >> *this* invoice (instead of waiting to apply them to another invoice). > >> > >> Do that, and then turn on "Show Payments" in the report options. > >> > >> -derek > > > > But how do you tell it to add existing credits to a new invoice? I > > don't see that option anywhere in the interface. > > After you post you need to Process Payment to attach the credit. > Unfortunately GnuCash no longer auto-applies credits. I thought that was still an option. But perhaps disabled by default ? Regards, Geert ------------------------------ Message: 9 Date: Thu, 2 Jun 2022 12:14:27 -0500 From: Adrien Monteleone <adrien.montele...@lusfiber.net> To: gnucash-u...@lists.gnucash.org Subject: Re: [GNC] Invoice showing balance due Message-ID: <t7ar5k$ir2$1...@ciao.gmane.io> Content-Type: text/plain; charset=UTF-8; format=flowed Yes, it is Preferences > Business > Invoices/Bills > 'Process payments on posting'. I use it and it auto-applies outstanding pre-payment/over-payment credit situations. Of course, one has to have already 'processed payment' for that vendor/customer for the feature to 'see' the amount to apply towards the current invoice/bill. Regards, Adrien On 6/2/22 11:50 AM, Geert Janssens wrote: > Op donderdag 2 juni 2022 18:05:13 CEST schreef Derek Atkins: >> On Thu, June 2, 2022 11:49 am, David Burleigh wrote: >>> On Thu, 2022-06-02 at 11:44 -0400, Derek Atkins wrote: >> [snip] ------------------------------ Message: 10 Date: Thu, 2 Jun 2022 12:22:45 -0500 From: Adrien Monteleone <adrien.montele...@lusfiber.net> To: gnucash-u...@lists.gnucash.org Subject: Re: [GNC] Strange incorrect due date calculated on a duplicated bill Message-ID: <t7arl6$q58$1...@ciao.gmane.io> Content-Type: text/plain; charset=UTF-8; format=flowed Thanks, done: https://bugs.gnucash.org/show_bug.cgi?id=798547 Regards, Adrien On 6/2/22 11:48 AM, Geert Janssens via gnucash-user wrote: > Op donderdag 2 juni 2022 18:22:40 CEST schreef Adrien Monteleone: >> Indeed, testing both 2020 and 2022 November dates result in a 19day >> due date rather than 20. >> >> I also tested the March dates for moving from standard to daylight >> time and those worked correctly. (they didn't add a day) >> >> Should I go ahead and file a bug? >> > Please do. It looks like the due date calculation is doing something > wrong when daylight saving time gets reverted. ------------------------------ Message: 11 Date: Thu, 2 Jun 2022 15:13:49 -0400 From: Christine McSweeney <jazzygirl...@gmail.com> To: gnucash-user@gnucash.org Subject: [GNC] Switching from Quickbooks and getting started Message-ID: <canqxysqvpyol2rhv_ycyucd2qbo14xfbdnzww7s-vmmwgwn...@mail.gmail.com> Content-Type: text/plain; charset="UTF-8" I have been using Quickbooks for personal finances and a small business for which I generate invoices. Haven't a clue for how to set up gnuchash *Christine* ------------------------------ Message: 12 Date: Thu, 2 Jun 2022 12:27:54 -0700 From: Jim DeLaHunt <list+gnuc...@jdlh.com> To: gnucash-user@gnucash.org Subject: Re: [GNC] Switching from Quickbooks and getting started Message-ID: <81464666-a355-3881-8fc3-eab9d0c3e...@jdlh.com> Content-Type: text/plain; charset=UTF-8; format=flowed Hello, Christine, and welcome to GnuCash! One way to get started is: 1. Read through GnuCash's Tutorial and Concepts Guide <https://www.gnucash.org/viewdoc.phtml?rev=4&lang=C&doc=guide>, 2. Download the GnuCash app <https://www.gnucash.org/download.phtml> 3. Install the GnuCash app: do the usual thing on Windows and macOS, and read <https://wiki.gnucash.org/wiki/Installation> for Linux or if you encounter problems 4. Run GnuCash, create a simple new account hierarchy and new book, purely for experimentation. Import data. Try things out. Make mistakes. It's only a test book, not your real data. 5. Now start over and make your real account hierarchy and new real book. Start importing data for real. 6. As needed, read the GnuCash Help manual <https://www.gnucash.org/viewdoc.phtml?rev=4&lang=C&doc=help>. 7. As needed, get help from the community. Send mail to this list, follow suggestions at <https://wiki.gnucash.org/wiki/Getting_Help>. 8. Consider how well you understand the fundamentals of double-entry bookkeeping. GnuCash requires you to use double-entry concepts, it does not attempt to hide them from you. If double-entry bookkeeping is new to you, maybe read an introductory accounting textbook. Are those clues helpful? Best regards, ??? ?Jim DeLaHunt On 2022-06-02 12:13, Christine McSweeney wrote: > I have been using Quickbooks for personal finances and a small > business for which I generate invoices. Haven't a clue for how to set > up gnuchash > > *Christine* > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please seehttps://wiki.gnucash.org/wiki/Mailing_Lists for more information. > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ------------------------------ Message: 13 Date: Thu, 2 Jun 2022 21:50:05 -0700 From: Fred Tydeman <tydeman.f...@gmail.com> To: Geoff <cleanoutmys...@gmail.com> Cc: Gnucash Users <gnucash-user@gnucash.org> Subject: Re: [GNC] Balance Sheet mismatch Message-ID: <cak1r+o3nfsxyhrkwz_2gxtb7ztdtltqpc3hxpwmhenvfw7l...@mail.gmail.com> Content-Type: text/plain; charset="UTF-8" I have made a test file with just two transactions: Opening Balance in GBP on 3/13/2011 xfer and convert to USD 1/1/2016 So, those two transactions put two entries in the Price database for GBP. I then added a third price between those two dates on 1/11/2013 The Balance Sheet shows a mismatch if run on 1/11/2013 or any date after that date but is OK if run on 1/10/2013 or any date earlier The value of the GBP (reported in USD) is changing in the Assets section of the report, but the Equity section is remaining constant. Should the Equity section show an Unrealized gain/loss? This looks like a bug to me. I am not sure how to report, or what is needed. The test2.gnucash file is around 5000 bytes small Now sure where the Price history is kept, nor the Report options. On Wed, Jun 1, 2022 at 7:56 AM Fred Tydeman <tydeman.f...@gmail.com> wrote: > > > On Wed, Jun 1, 2022 at 6:45 AM Fred Tydeman <tydeman.f...@gmail.com> > wrote: > >> I am now trying going back in time to see when the first imbalance starts. >> How do I get a list of transactions in a specific date range? >> Is there a way to find stock/mutual fund prices of zero(0)? >> > > First mismatch happens back in 2012. > It appears that using Report Options / Commodities / Price Source of > Closest to report date is a problem when the date of the report > is between two dates of a Foreign currency exchange rate in Price Database. > However, that is not the only problem, as now using Last up through > report date for Commodities, I get a mismatch when the Balance sheet > report is the same date as a Price Database entry of a foreign > currency. > ------------------------------ Message: 14 Date: Fri, 03 Jun 2022 15:49:15 +1000 From: davidcousen...@gmail.com To: gnucash-user@gnucash.org Subject: Re: [GNC] Balance Sheet mismatch Message-ID: <62b7bc6e72d3b22dd7db9a65105ab1e5d82e730a.ca...@gmail.com> Content-Type: text/plain; charset="UTF-8" Fred, The price database is stored in your main datafile for the set of books. You can edit it from the Tools->Price Database in the menu. David Cousens On Thu, 2022-06-02 at 21:50 -0700, Fred Tydeman wrote: > I have made a test file with just two transactions: > Opening Balance in GBP on 3/13/2011 > xfer and convert to USD 1/1/2016 > So, those two transactions put two entries in the Price database for GBP. > I then added a third price between those two dates on 1/11/2013 The > Balance Sheet shows a mismatch if run on 1/11/2013 or any date after > that date but is OK if run on 1/10/2013 or any date earlier The value > of the GBP (reported in USD) is changing in the Assets section of the > report, but the Equity section is remaining constant. > Should the Equity section show an Unrealized gain/loss? > This looks like a bug to me. I am not sure how to report, or what is > needed. > The test2.gnucash file is around 5000 bytes small Now sure where the > Price history is kept, nor the Report options. > > > > On Wed, Jun 1, 2022 at 7:56 AM Fred Tydeman <tydeman.f...@gmail.com> wrote: > > > > > On Wed, Jun 1, 2022 at 6:45 AM Fred Tydeman <tydeman.f...@gmail.com> > > wrote: > > > > > I am now trying going back in time to see when the first imbalance starts. > > > How do I get a list of transactions in a specific date range? > > > Is there a way to find stock/mutual fund prices of zero(0)? > > > > > > > First mismatch happens back in 2012. > > It appears that using Report Options / Commodities / Price Source of > > Closest to report date is a problem when the date of the report > > is between two dates of a Foreign currency exchange rate in Price Database. > > However, that is not the only problem, as now using Last up through > > report date for Commodities, I get a mismatch when the Balance sheet > > report is the same date as a Price Database entry of a foreign > > currency. > > > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ------------------------------ Subject: Digest Footer _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. ------------------------------ End of gnucash-user Digest, Vol 231, Issue 4 ******************************************** _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.