Hi John You're in luck... If you're willing to beta test the new versions of customer-report and aging-report, you can download the nightly at https://code.gnucash.org/builds/win32/maint/ and try the new versions in the Experimental reports submenu. Choose a build after 2-November. There's only one such build so far dated 3-November.
The new customer report (beta) will have option to display all invoice->payments and payment->invoice links. Both will also handle prepayments in the aging table separately. Please report any bugs in https://bugs.gnucash.org The old customer and aging reports are otherwise unchanged and will hopefully be mothballed. Please report any unwanted discrepancies between old and new. On Thu, 7 Nov 2019, 13:01 John Morris, <johnj...@editide.us> wrote: > Hi All, > > Having recently upgraded from GnuCash 2.6.something to 3.7, we are > having trouble with the some of the customer features. Specifically, > two reports help us see the amounts we are owed and what we owe our > clients. Those reports are Reports -> Business -> Receiveable Aging > and Reports -> Business -> Customer Report. The first report gives us > a handy list of all the clients who have a balance (positive or > negative). The second report gives us details (invoices and payments) > about a particular customer and can be accessed from the first report. > > The problem we are having is that in version 2.6, Receivable Aging > included all invoices and all payments in its assessment of each > client's balance. Thus, if a client has overpaid by $100 but that > payment has not been applied to any invoices, it would show that the > client had a $100 negative balance. In version 3.7, no payments that > have not been applied to any invoices are included in the calculations > for this report. Thus, if a client completely pays all past invoices > and then sends another check for $100 to be applied to future work, > that client does not show up in the Receivable Aging report because it > thinks the client has a zero balance. As soon as I use even one penny > from that payment to pay an invoice, the entire $100 shows up in the > report. > > In contrast, the Customer Report shows all invoices and all payments > for a particular client, so we know if we owe the client or the client > owes us. Unfortunately, with over 1,700 customers, this is not a > practical way to track our receivables. > > Is there any way around this problem? We don't have many, but we do > have a few clients who regularly prepay their projects, so it is very > important for us to know who they are and where we stand with them. If > there is no way around this new functionality, how else do other > people keep track of prepaying clients? > > Thanks, > John > _______________________________________________ > gnucash-user mailing list > gnucash-u...@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. > _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
