[GNC] Imbalance bug in credit note generation?

classic Classic list List threaded Threaded
10 messages Options
Reply | Threaded
Open this post in threaded view
|

[GNC] Imbalance bug in credit note generation?

Amish
Hello

I am trying to create a credit note for a customer, in exact same way as
Invoice except that type chosen is "Credit note".

But after posting the "credit note", Gnucash is "increasing" receivables
instead of decreasing.

It also increases "tax liability" - it should actually decrease it.

But it correctly "reduces" the Income.

Effectively this creates an "imbalance" entry too - because internally
the total does not balance.

Please find more details and screen shots in the following bug report
(filed 2 days back)

https://bugs.gnucash.org/show_bug.cgi?id=796766

I am posting here for two reasons:

1) To know if I am using "Credit note" incorrectly (which I doubt)
2) To highlight the bug (if it is indeed a bug) because it is a serious
"accounting" bug and probably needs addressing on priority.

So please check.

Thank you

Amish.

_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Imbalance bug in credit note generation?

David Cousens
Hi Amish'

I can also confirm that the credit note has a bug for GnuCash 3.2 running on
Linux Mint 19 from the flat pack. I have created an Invoice for $100 for a
dummy company  in a test file and then a credit note for the same dummy
company for $50. I have not used a tax table. After the two transactions,
A/R has a balance of $150 intead of $50.

The recorded transactions in the Accounts Receivable Register are as
follows:

Invoice Posted
                                                                         Dr                      
Cr
Assets:Accounts Receivable                          $100
Income:Sales                                                                          
$100

Credit Note Posted
                                                                        Dr                      
Cr
Income:Sales                                                 $50
Assets:Accounts Receivable                         $50
Imbalance                                                                              
$100

whereas the last transaction  should have been
                                                                      Dr                      
Cr
Icome:Sales                                                  $50
Assets:Accounts Receivable                                                  
$50

giving rise to a final balance in the Accounts receivable of $150 and the
unnecessary entry for $100 in the Imbalance account.

David Cousens





-----
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
David Cousens
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Imbalance bug in credit note generation?

Amish
Thank you for acknowledging.

I was wondering if my messages reach the list as my past 3-4 emails (on
different subjects) have gone unanswered. Although messages do appear in
mailing list archives.

Please add your report also to the following bug report so that it can
be tracked and also adds the weight to bug.

https://bugs.gnucash.org/show_bug.cgi?id=796766

Thank you.

Amish


On Friday 20 July 2018 08:02 AM, DaveC49 wrote:

> Hi Amish'
>
> I can also confirm that the credit note has a bug for GnuCash 3.2 running on
> Linux Mint 19 from the flat pack. I have created an Invoice for $100 for a
> dummy company  in a test file and then a credit note for the same dummy
> company for $50. I have not used a tax table. After the two transactions,
> A/R has a balance of $150 intead of $50.
>
> The recorded transactions in the Accounts Receivable Register are as
> follows:
>
> Invoice Posted
>                                                                           Dr
> Cr
> Assets:Accounts Receivable                          $100
> Income:Sales
> $100
>
> Credit Note Posted
>                                                                          Dr
> Cr
> Income:Sales                                                 $50
> Assets:Accounts Receivable                         $50
> Imbalance
> $100
>
> whereas the last transaction  should have been
>                                                                        Dr
> Cr
> Icome:Sales                                                  $50
> Assets:Accounts Receivable
> $50
>
> giving rise to a final balance in the Accounts receivable of $150 and the
> unnecessary entry for $100 in the Imbalance account.
>
> David Cousens
>
>
>
>
>
> -----
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> _______________________________________________
> gnucash-user mailing list
> [hidden email]
> 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.

_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Imbalance bug in credit note generation?

Amish
In reply to this post by David Cousens
Can someone using Gnucash for Business account please check credit note
creation?

I am wondering how come noone came across this bug. It is a serious bug
unless I am doing something wrong.

This bug is now affecting maintaining business account for me.

Without "correctly assigned / balanced" credit notes all figures come
out wrong.

Bug report:
https://bugs.gnucash.org/show_bug.cgi?id=796766

I am wondering if developers know this or not. As it has not been
assigned to anyone or acknowledged.

So please check.

Thank you.

Amish


On Friday 20 July 2018 08:02 AM, DaveC49 wrote:

> Hi Amish'
>
> I can also confirm that the credit note has a bug for GnuCash 3.2 running on
> Linux Mint 19 from the flat pack. I have created an Invoice for $100 for a
> dummy company  in a test file and then a credit note for the same dummy
> company for $50. I have not used a tax table. After the two transactions,
> A/R has a balance of $150 intead of $50.
>
> The recorded transactions in the Accounts Receivable Register are as
> follows:
>
> Invoice Posted
>                                                                           Dr
> Cr
> Assets:Accounts Receivable                          $100
> Income:Sales
> $100
>
> Credit Note Posted
>                                                                          Dr
> Cr
> Income:Sales                                                 $50
> Assets:Accounts Receivable                         $50
> Imbalance
> $100
>
> whereas the last transaction  should have been
>                                                                        Dr
> Cr
> Icome:Sales                                                  $50
> Assets:Accounts Receivable
> $50
>
> giving rise to a final balance in the Accounts receivable of $150 and the
> unnecessary entry for $100 in the Imbalance account.
>
> David Cousens
>
>
>
>
>
> -----
> David Cousens
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> _______________________________________________
> gnucash-user mailing list
> [hidden email]
> 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.

_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Imbalance bug in credit note generation?

Geert Janssens-4
Op dinsdag 31 juli 2018 08:56:15 CEST schreef Amish:

> Can someone using Gnucash for Business account please check credit note
> creation?
>
> I am wondering how come noone came across this bug. It is a serious bug
> unless I am doing something wrong.
>
> This bug is now affecting maintaining business account for me.
>
> Without "correctly assigned / balanced" credit notes all figures come
> out wrong.
>
> Bug report:
> https://bugs.gnucash.org/show_bug.cgi?id=796766
>
> I am wondering if developers know this or not. As it has not been
> assigned to anyone or acknowledged.

The impatience... ;)

It's holiday season so expect replies to have a longer delay. I have only
returned from vacation today and have a huge backlog to process.

I have seen your bug report but haven't had time to verify. As this is my area
I will do so soon and if I can reproduce I will for sure put it on my priority
list for 3,3.

Regards,

Geert


_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Imbalance bug in credit note generation?

GnuCashAtSRQ
Thanks, Geert, for acknowledging this and do have a good holiday.

I have the same problem (Gnucash 3.2 on Windows 10, using Sqlite3) but one
other that may be related.  When the credit note I created for $279 had the
backwards result I thought I'd entered something wrong so I unposted the
Credit Note, deleted the old transaction, entered a new transaction with a
$0 value and re-posted the same Credit Note.  But then the Customer Report
showed TWO Credit Notes -- one for $279 and one for $0.  Again, then I had 3
Credit Notes.  I went to Accounts Receivable and found entries for all
three.  Gnucash let me delete 1 of the transactions from the Accounts
Receivable Register, but trying to delete either of the other 2 gave me an
error saying the transaction was from and invoice and to delete the invoice
first.

Then the Customer Report showed me the 2 credit notes, $279, and $0.  I
clicked the link to the $279 credit note and what displayed was a credit
note with the transaction being $0, not $279.

 [AN ASIDE, and a complaint (suggestion ):  There seems no way to delete an
invoice, which is a problem if one makes a mistake and there should really
not be any invoice at all.]

This is of some urgency for us so can you estimate when 3.3 might be
available?

Many thanks.





--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Imbalance bug in credit note generation?

Amish
In reply to this post by Geert Janssens-4
On Tuesday 31 July 2018 08:34 PM, Geert Janssens wrote:

> Op dinsdag 31 juli 2018 08:56:15 CEST schreef Amish:
>> Can someone using Gnucash for Business account please check credit note
>> creation?
>>
>> I am wondering how come noone came across this bug. It is a serious bug
>> unless I am doing something wrong.
>>
>> This bug is now affecting maintaining business account for me.
>>
>> Without "correctly assigned / balanced" credit notes all figures come
>> out wrong.
>>
>> Bug report:
>> https://bugs.gnucash.org/show_bug.cgi?id=796766
>>
>> I am wondering if developers know this or not. As it has not been
>> assigned to anyone or acknowledged.
> The impatience... ;)
Thank you for your reply. But I did wait about 2 weeks after bug report.
> It's holiday season so expect replies to have a longer delay. I have only
> returned from vacation today and have a huge backlog to process.
>
> I have seen your bug report but haven't had time to verify. As this is my area
> I will do so soon and if I can reproduce I will for sure put it on my priority
> list for 3,3.

Mailing list was reasonably active so I was just wondering and also
worried about my issue.

My business depends on Gnucash credit notes working properly so you can
understand that for me it would become a priority.

Ofcourse I completely understand that its an open source software by
volunteers around the world.

I tried my best to report the bug in best possible way.

Do let me know if you need more information.

> Regards,
>
> Geert
Thanks and regards,

Amish

_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Imbalance bug in credit note generation?

Adrien Monteleone-2
In reply to this post by GnuCashAtSRQ
No, you cannot delete invoices/bills/credit notes.

Simply edit them, remove all lines and info in them that you can, and perhaps change their number to ‘use next’ so they’ll stand out next time you need one.

Regards,
Adrien

> On Aug 1, 2018, at 11:40 AM, GnuCashAtSRQ <[hidden email]> wrote:
>
> Thanks, Geert, for acknowledging this and do have a good holiday.
>
> I have the same problem (Gnucash 3.2 on Windows 10, using Sqlite3) but one
> other that may be related.  When the credit note I created for $279 had the
> backwards result I thought I'd entered something wrong so I unposted the
> Credit Note, deleted the old transaction, entered a new transaction with a
> $0 value and re-posted the same Credit Note.  But then the Customer Report
> showed TWO Credit Notes -- one for $279 and one for $0.  Again, then I had 3
> Credit Notes.  I went to Accounts Receivable and found entries for all
> three.  Gnucash let me delete 1 of the transactions from the Accounts
> Receivable Register, but trying to delete either of the other 2 gave me an
> error saying the transaction was from and invoice and to delete the invoice
> first.
>
> Then the Customer Report showed me the 2 credit notes, $279, and $0.  I
> clicked the link to the $279 credit note and what displayed was a credit
> note with the transaction being $0, not $279.
>
> [AN ASIDE, and a complaint (suggestion ):  There seems no way to delete an
> invoice, which is a problem if one makes a mistake and there should really
> not be any invoice at all.]
>
> This is of some urgency for us so can you estimate when 3.3 might be
> available?
>
> Many thanks.
>
>
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> _______________________________________________
> gnucash-user mailing list
> [hidden email]
> 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.
>


_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Imbalance bug in credit note generation?

Amish
In reply to this post by Geert Janssens-4
On Tuesday 31 July 2018 08:34 PM, Geert Janssens wrote:

> Op dinsdag 31 juli 2018 08:56:15 CEST schreef Amish:
>> Can someone using Gnucash for Business account please check credit note
>> creation?
> I have seen your bug report but haven't had time to verify. As this is my area
> I will do so soon and if I can reproduce I will for sure put it on my priority
> list for 3,3.
>
> Regards,
>
> Geert

Just for the record, the fix has been pushed to git maint branch.

https://github.com/Gnucash/gnucash/commit/d87fa3a5bed0b948f28651bf8b0897373cc7110e

Thank you Geert for quick fix.

Amish.
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] Imbalance bug in credit note generation?

Geert Janssens-4
Op woensdag 8 augustus 2018 08:24:57 CEST schreef Amish:

> On Tuesday 31 July 2018 08:34 PM, Geert Janssens wrote:
> > Op dinsdag 31 juli 2018 08:56:15 CEST schreef Amish:
> >> Can someone using Gnucash for Business account please check credit note
> >> creation?
> >
> > I have seen your bug report but haven't had time to verify. As this is my
> > area I will do so soon and if I can reproduce I will for sure put it on
> > my priority list for 3,3.
> >
> > Regards,
> >
> > Geert
>
> Just for the record, the fix has been pushed to git maint branch.
>
> https://github.com/Gnucash/gnucash/commit/d87fa3a5bed0b948f28651bf8b0897373c
> c7110e
>
> Thank you Geert for quick fix.

You're welcome and thanks for sharing this here (I forgot).

Geert


_______________________________________________
gnucash-user mailing list
[hidden email]
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.