[GNC-dev] [GNC] Customer Report versus Receivables Aging

Christopher Lam christopher.lck at gmail.com
Thu Nov 7 00:44:19 EST 2019

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, <johnjeff at 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-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.

More information about the gnucash-devel mailing list