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 <p...@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 <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. _______________________________________________ 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.
