GC 2.6.3: Apparent inconsistency between reports for a single customer--Reopened

[Geert Janssens]

On Thursday 25 September 2014 13:43:26 Terry Morse wrote:
> The plot thickens:
> 
> With David Cousens's invaluable help,I solved my problem with
> inconsistencies between Receivable Aging, Customer, and Tax Invoice
> reports (for details, see below), but the solution appears to be
> temporary:
> 
> After unposting a customer invoice to add charges to it, then
> reposting the invoice, all the internal lot links disappear from A/R,
> and the payments no longer show up on the tax invoice. As the process
> of assigning the entries in A/R as payments is time consuming, I
> don't want to have to do it repeatedly, nor to have to go through the
> entire A/R register for the year, doing the assignments once the
> invoices are closed at the end of the tax year, which would be a
> similarly laborious process.
> 
> Is there any way to get these internal links between invoice and lots
> to persist when I unpost then repost the invoice?
> 
I realize this is very frustrating if you regularly have to unpost 
invoices to make changes.

Unfortunately this was a deliberate design decision during the 2.6 
development cycle. There are too many ways you can change an unposted 
invoice that would invalidate the associated payments. So to be on the 
safe side it was decided to separate payments from an invoice the moment 
it gets unposted.

On the other hand this choice was probably too restrictive and I have 
this on my list to revisit at some point and improve the situation. 
Until that time the only options you have is to either not unpost paid 
invoices or manually reassign the payments after you repost.

Sorry about that.

Geert

> Thank you,
> Terry Morse
> tmorse at teleport.com
> 
> >Problem solved:
> >
> >[Note: in my original message, shown below, I typed "accounts
> >payable," but I meant "accounts receivable."]
> >
> >Following off-list suggestions from David Cousens, I have solved the
> >problem.
> >
> >Examining the entries in Accounts Receivable, I notice that the ones
> >that appeared on the tax invoice consisted of three parts: one
> >marked "Payment" and two "Lot Link" entries with the description
> >"Internal link between invoice and payment lots." The payments that
> >were not on the tax invoice were single entries labeled either
> >"Payment" or "Pre-Payment." I think (but haven't verified yet) that
> >these came about when I unposted the customer's invoice to record
> >new accruals, then processed the payments before reposting the
> >invoice.
> >
> >David's suggested I right-click on each single part payment or
> >prepayment and choose "Assign as payment" from the ensuing drop-down
> >menu. This eliminated the discrepancy between the customer's
> >reports.
> >
> >Thanks to both David's (Cousens and Britton) who responded to my
> >request.
> >
> >Terry Morse
> >tmorse at teleport.com
> >http://home.teleport.com/~tmorse/index.html
> >*
> >
> >“Scientists have odious manners, except when you prop up their
> >theory; then you can borrow money of them.” – Mark Twain, 1835-1910
> >
> >
> >-----Original Message-----
> >
> >>From: Terry Morse <tmorse at teleport.com>
> >>Sent: Sep 3, 2014 2:05 PM
> >>To: GNUCash <gnucash-user at gnucash.org>
> >>Subject: GC 2.6.3: Apparent inconsistency between reports for a
> >>single customer
> >>
> >>I am using GnuCash 2.6.3 on a Windows 7 computer to keep records for
> >>a friend's business. She has a customer who accrues charges on a
> >>weekly basis, which I record on an invoice to Accounts Payable. The
> >>customer also pays on a regular basis. I record her payments using
> >>the Process Payments dialogue box.
> >>
> >>On the latest Receivable Aging report, it shows her owing $240 in
> >>the 0-30 days period. Her Customer Report shows all her payments on
> >>the dates she made them and her total due as $240 ($3,485.00 due
> >>minus $3,245.00 paid). However, it shows her owing $2845.00 in the
> >>0-30 day category and $0 for all other time periods.
> >>
> >>Her tax invoice for the current year to date (January through
> >>9/2/14) shows a subtotal of $3,485.00, but only 3 payments totaling
> >>$640.00 between July 1 and September 7, with an amount due of
> >>$2,845.00. (The September 7 payment was actually made on July 7 but
> >>persistently shows up on the tax invoice as on September 7, another
> >>inconsistency).
> >>
> >>Shouldn't all three reports be showing the same bottom line, $240
> >>owed in the 0-30 day aging period? Shouldn't all her payments show
> >>on the tax invoice on the date they were made? I am not an
> >>accountant, so the fault may be in my understanding of the
> >>different reports. I'd appreciate help resolving the apparent
> >>enigma.
> >>
> >>Thank you,
> >>Terry Morse
> >>tmorse at teleport.com
> 
> _______________________________________________
> 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.