GNOME Bugzilla – Bug 449672
customer appears in account aging with $0 balance
Last modified: 2018-06-29 21:39:52 UTC
Please describe the problem: I created an invoice to a customer but sometimes I'm a little slow about getting the invoices out. Once of my customers was a little impatient and just sent me a payment for what he estimated. So my invoice was for $X amount, and he sent me $X + $Y amount. I "received" the payment of $X + $Y into the system (which created a balance of -$Y for the customer, which also appears in the aging report). When asked about the extra, the customer just responded to just keep it. So I adjusted the invoice (unposted and edited to add $Y amount to it) and reposted. The created a $0 balance for the customer, but now the customer appears on the aging report even though he owes nothing. Steps to reproduce: 1. Create invoice for $X amount. 2. Accept payment for $X + $Y. 3. Unpost invoice and adjust adding $Y to invoice. 4. Repost invoice. 5. Notice customer balance is now $0, but customer appears in aging report anyway. Actual results: Report is incorrect (only in the sense that it shows a customer with $0 balance - the number are correct). Expected results: Customer should not be listed with a $0 balance. Does this happen every time? Yes Other information:
Created attachment 90377 [details] example of bug where X=$1000 and Y=$1
Interesting. I can still reproduce this in the current unstable release (2.3.15). What triggers this bug is the particular payment transaction. Looking at the Checkings Account in your example, you can see one transaction with 3 splits: - One for the total in the Checkings Account - Two in the Accounts Receivable Account If I change this to two separate payments in two separate transactions, the customer suddenly disappears from the Receivable Aging report. So clearly the report code to determine whether a customer still owes you something is confused by a split transaction.
The logic to handle payments has been reworked substantially in gnucash 2.6. I have just tried and can't reproduce this issue anymore in gnucash 2.6.5. The steps to do this are now slightly changed: 1. Create invoice for $X amount. 2. Accept payment for $X + $Y. 3. Unpost invoice and adjust adding $Y to invoice. 4. Repost invoice. 4b. Since 2.6 payments are decoupled from the invoice on unposting, so reapply the prepayment(s) to the invoice 5. Notice customer balance is now $0, and customer no longer appears in aging report. If you can still reproduce this, feel free to reopen the report.
This still happens with credit notes. 1. Add invoice 2. Add credit note Customer balance is 0, still in the list.
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=449672. Please update any external references or bookmarks.