A/R question

Cam Ellison cam at ellisonet.ca
Thu Aug 27 19:01:09 EDT 2009


Derek Atkins wrote:
>
> First, what do you mean by "the credits don't match the debits"?  In
> what way is the Aging Report incorrect?
>   
The report shows the invoiced totals for each period (30, 60, etc.), 
each customer, and overall - as though they had never been paid.  In 
that sense, the credits and debits (invoice and payment amounts) don't 
match.  It occurred to me that there must be something in the code for 
each transaction that matches corresponding invoices and payments.  
Though there are a fair number of them (perhaps 200 or thereabout), it 
might be easier to change the transaction codes so they match up, than 
to delete and re-enter them all.

As I think about it, though, if you delete a child account and allow the 
transactions to move to the parent, any information regarding 
transaction pairs - that is, the invoice and corresponding payment(s) - 
ought to move with them.  The resulting total should be 0 if the invoice 
has been paid in full, and the report should reflect that - unless I'm 
missing the point of the report.  As I understand it, it should be 
showing outstanding invoice totals by age.  Perhaps what I am seeing is 
a bug in the report script.
> Unfortunately, depending on the errors, it might mean going in
> and deleting and re-creating the payments.  You should look for some
> auto-payment-forward transactions.  Most likely you'll need to delete
> those and a bunch of payments and then re-run the Process Payments.
>
> Don't worry about the fact that transactions are reconciled.  It's easy
> to re-reconcile them after the fact.  Just ignore the starting balance
> and include them as if they were on the statement.
>
>
>   
I think I'll hold off on this until it's clear it's not the report 
script (and until I have time to do it).

Thanks, Derek

Cam




More information about the gnucash-user mailing list