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

prl prl at ozemail.com.au
Thu Oct 18 00:45:38 EDT 2018


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.




More information about the gnucash-user mailing list