Receivables Aging Misreporting
Pablo Francesca
rshgeneral at yahoo.com
Wed Mar 17 12:15:14 EDT 2010
Okay, so I see the auto pay forwards. I read the bug report. My understanding is that payments and invoices are grouped in lots by invoice owner. Each lot can contain either 1 invoice and any number of payments, or a lot can contain any number of payments or "saved payments" (over-payments, pre-payments). and no invoices.
So I start looking through A/R transactions for this customer. The first transaction "lot" indicates a payment and an invoice for 850. Well, this customer has never made a payment for 850. On the date in question, an invoice was created for 100. Doesn't make sense.
I deleted the payment transaction for 850 and the invoice disappeared as well. I reran the receivables aging report and there was no change. Makes sense.
The next lot for the customer indicated a payment for 750 and an invoice for 750. Again this customer has never made a payment for 750. On the date in question, an invoice for 100 was created.
I deleted the payment transaction for 750 and the invoice disappeared
as well. I reran the receivables aging report and it now showed a change of 750 debited to the customer.
I'm thoroughly confused. Why are these "lots" even in existence?
--- On Wed, 3/17/10, Derek Atkins <warlord at MIT.EDU> wrote:
From: Derek Atkins <warlord at MIT.EDU>
Subject: Re: Receivables Aging Misreporting
To: "Pablo Francesca" <rshgeneral at yahoo.com>
Cc: "trythis" <grahamlane at gmail.com>, gnucash-user at gnucash.org
Date: Wednesday, March 17, 2010, 8:05 AM
Hi,
Pablo Francesca <rshgeneral at yahoo.com> writes:
> We'll, doing a manual calculation of the customer's invoices and payments
> yields equal amounts; 5k in debits and 5k in credits. So it's the receivables
> aging report that is wrong.
>
> Not sure what an auto-payment-forward transaction, but this customer does
> prepay for service, so most, if not all A/R transactions for this client are
> split transactions.
Take a look in your A/R account and you'll see them.
> How do I got about fixing this?
Sounds like https://bugzilla.gnome.org/show_bug.cgi?id=488035 or
https://bugzilla.gnome.org/show_bug.cgi?id=143418
-derek
> --- On Tue, 3/16/10, Derek Atkins <warlord at MIT.EDU> wrote:
>
> From: Derek Atkins <warlord at MIT.EDU>
> Subject: Re: Receivables Aging Misreporting
> To: "trythis" <grahamlane at gmail.com>
> Cc: gnucash-user at gnucash.org
> Date: Tuesday, March 16, 2010, 9:10 AM
>
> Another possibility is that you hit the bug where GnuCash thinks
> the invoices weren't paid properly and you've got lots of
> auto-payment-forward transactions in your A/R account throwing
> off all your balances.
>
> -derek
>
> trythis <grahamlane at gmail.com> writes:
>
> > The only thing that comes to mind is the possibility of dates being
> different
> > in the two reports.
> > Could it also be possible that one of the payments is not applied
> properly
> > within an invoice? I am only guessing here, but maybe one of the
> payments
> > has been entered many days past the due date of the invoice as because
> you
> > made the payment entry a year after the actual payment was made and
> forgot
> > to backdate the payment and the aging report added the interest. I am
> also
> > guessing that a regular report might also show such a debt so that idea
> is
> > probably terrible.
> >
> >
> > Pablo Francesca wrote:
> >>
> >> When I run a receivables aging report, one of my clients shows an
> >> outstanding debit balance of $125. When I run a customer report for
> this
> >> same customer, the report shows a $0 balance.
> >>
> >> How could this be possible?
> >>
> >>
> >>
> >>
> >> _______________________________________________
> >> gnucash-user mailing list
> >> gnucash-user at gnucash.org
> >> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >> -----
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >>
> >>
>
> --
> 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
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>
--
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
More information about the gnucash-user
mailing list