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

[Terry Morse]

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?

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