[GNC] Receivables Ageing report has a type "Balance", which is in error

[Graham Stoddart-Stones]

Ah, the point that I was trying to make is that the Receivables Ageing
Report shows a 2018-01-01 balance of ₤25 for a customer that did not exist
in the system on 01Jan18 - ie there are no entries for that customer before
09Apr18.  There are many entries for ₤25, both before and after either
date. I am at a bit of a loss to account for that!

Thank you

Graham

On Thu, 18 Oct 2018 at 05:47, prl <prl at ozemail.com.au> wrote:

> On 17/10/2018 02:09, Graham Stoddart-Stones via gnucash-user wrote:
> > Is there a way of narrowing down the search
> > that you are suggesting, please?
> > This is actually a new customer, who had not been in the system before
> > April 2018.........not sure if that is at all relevant?
> Doesn't that fact itself suggest a way of narrowing down the search:
> perhaps you have the customer name or other id information in a
> searchable field like Description or Memo?
>
> Peter
> >> Hi,
> >>
> >> gcstones52 <gcstones52 at gmail.com> writes:
> >>
> >>> Date Range: 2018-01-01 - 2018-10-16
> >>> Date Due Date Reference Type Description Credits Debits Amount
> >>> 2018-01-01                    Balance                         £25.00
> >>> 2018-04-05 2018-04-05 LSVH-2018-85 Invoice Quiz Night deposit, 9Nov18
> >>> £25.00
> >>> £25.00
> >>> 2018-04-10            2018-85 Payment Bank transfer           -£25.00
> >> -£25.00
> >>> Period Totals         £25.00  -£25.00 £0.00
> >>> Total Due     £25.00
> >>> Current       0-30 days       31-60 days      61-90 days      91+ days
> >>> £0.00 £0.00   £0.00   £0.00   £25.00
> >>>
> >>> The customer has paid all invoices, and should have a balance of zero
> >> (and
> >>> shows as zero in Accounts Receivable).  However, the report shows a
> >>> "balance" of £25 due from 2018-01-01, but I can find no entries
> anywhere
> >> in
> >>> the system (searching on client name, on transaction date, on amount)
> >> that
> >>> would generate this balance.  Note that the first entry for the
> customer
> >> was
> >>> 2018-04-01.  Could anyone please suggest how a balance may have been
> >> created
> >>> for this customer on 2018-01-01?
> >> This report is looking at Transaction Metadata which might not be
> >> searchable.  If there is a transaction tied to a Lot that is tied to the
> >> customer, that would be sufficient to get it listed.
> >>
> >> Is there a ₤25.00 transaction in A/R at all?
> >>
> >>> Thank you
> >>> Graham
> >>> Please remember to CC this list on all your replies.
> >>> You can do this by using Reply-To-List or Reply-All.
> >> -derek
> >> --
> >>         Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
> >>         Member, MIT Student Information Processing Board  (SIPB)
> >>         URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
> >>         warlord at MIT.EDU                        PGP key available
> >>
> > _______________________________________________
> > 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.
>
>
> _______________________________________________
> 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.