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 <gcstone...@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
warl...@mit.edu PGP key available
_______________________________________________
gnucash-user mailing list
gnucash-user@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@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.
