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

[Adrien Monteleone]

1) Try doing a Find Invoice using the customer’s name or account number as the search criteria.

If you re-used an invoice, (or customer even) you might find that extra entry that way.

1.a) Also, look over each invoice for that customer really well. If you re-used an invoice from another customer for this one, you might not have fully edited the invoice with a proper date. (the re-used invoice might have that pre-April date)

2) Another possibility might be an errant lot created as a result of unposting and reposting.

Open the A/R account, choose Actions > View Lots.

Look over each invoice on the right hand side. (select each one to view the splits)

You might find there is an extra split for an invoice there.

If you find the problem there, report back and someone here can help you clean it up.

Regards,
Adrien

> On Oct 18, 2018, at 6:16 AM, Graham Stoddart-Stones via gnucash-user <gnucash-user at gnucash.org> wrote:
> 
> 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.
> _______________________________________________
> 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.