[GNC] Invoice showing balance due
Ryan Carver
ryan at 6040design.com
Fri Jun 3 09:40:55 EDT 2022
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.com at gnucash.org>
On Behalf Of gnucash-user-request at gnucash.org
Sent: Friday, June 3, 2022 1:49 AM
To: gnucash-user at gnucash.org
Subject: gnucash-user Digest, Vol 231, Issue 4
Send gnucash-user mailing list submissions to
gnucash-user at 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-request at gnucash.org
You can reach the person managing the list at
gnucash-user-owner at 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 (davidcousens49 at gmail.com)
----------------------------------------------------------------------
Message: 1
Date: Thu, 2 Jun 2022 12:05:13 -0400
From: "Derek Atkins" <derek at ihtfp.com>
To: "David Burleigh" <david.burleigh at saphar.net>
Cc: gnucash-user at gnucash.org
Subject: Re: [GNC] Invoice showing balance due
Message-ID:
<b704ccfcea0af1ea0188e3cbf28ee89e.squirrel at 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
derek at 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.burleigh at saphar.net>
To: Derek Atkins <derek at ihtfp.com>
Cc: gnucash-user at gnucash.org
Subject: Re: [GNC] Invoice showing balance due
Message-ID:
<b29496278af2ed3e82b0f49bff451a6db76c4410.camel at 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" <derek at ihtfp.com>
To: "David Burleigh" <david.burleigh at saphar.net>
Cc: gnucash-user at gnucash.org
Subject: Re: [GNC] Invoice showing balance due
Message-ID:
<a7f2133554cd6ea74d69964bfce0bf63.squirrel at 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
derek at 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.burleigh at saphar.net>
To: Derek Atkins <derek at ihtfp.com>
Cc: gnucash-user at gnucash.org
Subject: Re: [GNC] Invoice showing balance due
Message-ID:
<7287aab6a455a755e41f0f7e5277d19add4aa4dc.camel at 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.monteleone at lusfiber.net>
To: gnucash-user at lists.gnucash.org
Subject: Re: [GNC] Strange incorrect due date calculated on a
duplicated bill
Message-ID: <t7ao4g$j66$1 at 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.gnucash at kobaltwit.be>
To: gnucash-user at lists.gnucash.org, gnucash-user at gnucash.org
Cc: adrien.monteleone at lusfiber.net
Subject: Re: [GNC] Strange incorrect due date calculated on a
duplicated bill
Message-ID: <4717020.GXAFRqVoOG at 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.gnucash at kobaltwit.be>
To: gnucash-user at lists.gnucash.org, gnucash-user at gnucash.org
Cc: adrien.monteleone at lusfiber.net
Subject: Re: [GNC] Strange incorrect due date calculated on a
duplicated bill
Message-ID: <4717020.GXAFRqVoOG at 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.gnucash at kobaltwit.be>
To: David Burleigh <david.burleigh at saphar.net>,
gnucash-user at gnucash.org, Derek Atkins <derek at ihtfp.com>
Subject: Re: [GNC] Invoice showing balance due
Message-ID: <2831905.e9J7NaK4W3 at 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.monteleone at lusfiber.net>
To: gnucash-user at lists.gnucash.org
Subject: Re: [GNC] Invoice showing balance due
Message-ID: <t7ar5k$ir2$1 at 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.monteleone at lusfiber.net>
To: gnucash-user at lists.gnucash.org
Subject: Re: [GNC] Strange incorrect due date calculated on a
duplicated bill
Message-ID: <t7arl6$q58$1 at 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.cm at gmail.com>
To: gnucash-user at gnucash.org
Subject: [GNC] Switching from Quickbooks and getting started
Message-ID:
<CANQXYsqvpYOL2rhV_yCyucd2qbo14XFBdNZWw7S-vmmwgwNtfw at 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+gnucash at jdlh.com>
To: gnucash-user at gnucash.org
Subject: Re: [GNC] Switching from Quickbooks and getting started
Message-ID: <81464666-a355-3881-8fc3-eab9d0c3e83c at 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 at 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.fred at gmail.com>
To: Geoff <cleanoutmyshed at gmail.com>
Cc: Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] Balance Sheet mismatch
Message-ID:
<CAK1r+o3nfSXYhrkWZ_2gXTb7ZTDtLTQpC3HXPwmHEnVFw7LKWg at 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.fred at gmail.com>
wrote:
>
>
> On Wed, Jun 1, 2022 at 6:45 AM Fred Tydeman <tydeman.fred at 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: davidcousens49 at gmail.com
To: gnucash-user at gnucash.org
Subject: Re: [GNC] Balance Sheet mismatch
Message-ID: <62b7bc6e72d3b22dd7db9a65105ab1e5d82e730a.camel at 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.fred at gmail.com>
wrote:
>
> >
> > On Wed, Jun 1, 2022 at 6:45 AM Fred Tydeman <tydeman.fred at 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 at 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 at 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
********************************************
More information about the gnucash-user
mailing list