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

[Graham Stoddart-Stones]

Derek:

Thank you for your prompt response.

There are many transactions valued at £25, as that is the standard deposit
for renting the Village Hall.  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?

Thank you.

Graham

On Tue, 16 Oct 2018 at 16:03, Derek Atkins <warlord at mit.edu> wrote:

> 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
>