GC 2.6.3: Apparent inconsistency between reports for a single customer

[Terry Morse]

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