What do you see when you double click on the payment in terms of applying it to an invoice? Does it show an application? or is it set to apply to a future invoice? Because the invoice above it does show Paid in Full all the way to the left.  So that is pretty odd.

Nancy Duhon, Esq.

Duhon Technology Solutions, LLC

Master Certified Consultant for Sage Timeslips

Providing individual Consultations and Third Party Remote Desktop Support - including older/unsupported versions.

404-325-9779

[email protected] 

What do you see when you double click on the payment in terms of applying it to an invoice? Does it show an application? or is it set to apply to a future invoice? Because the invoice above it does show Paid in Full all the way to the left.  So that is pretty odd.

Nancy Duhon, Esq.

Duhon Technology Solutions, LLC

Master Certified Consultant for Sage Timeslips

Providing individual Consultations and Third Party Remote Desktop Support - including older/unsupported versions.

404-325-9779

[email protected] 

The Accounts Receivable Entry window shows that the payment was made against the invoice. See screen show below.

Okay, then I don't think it is a payment application issue.  

My next suggestion would be to rebuild THAT PARTICULAR client's A/R balance, but you said you did that already?

Nancy Duhon, Esq.

Duhon Technology Solutions, LLC

Master Certified Consultant for Sage Timeslips

Providing individual Consultations and Third Party Remote Desktop Support - including older/unsupported versions.

404-325-9779

[email protected] 

Hi Nancy,

Yes, I already searched the forum for answers and tried to rebuild that client's A/R balance per other recommendations. But it still shows a balance on the A/R list and in reports, as well as when I create a new bill. But the A/R balance within the client's information window box and the client's fund balance are all correct. This has me stumped.

We might be able to "put the pieces together" in the back end. It is something I would want to test on a copy of the database as it is somewhat risky.

The plot thickens. It looks like it may be a payment application issue. I decided to try and pull every "canned" report to see if any one of them pulled different or conflicting data. The "A/R Transaction Listing" report shows the payment, but applied to, what looks like, a corrupted invoice number.

Is there a way to purge this entry in order to reapply the payment correctly?

This may or may not fix the problem but see if you can clear the applies on the payment and then apply it to the correct invoice.

Nothing happens when I try to clear the applies.

I also tried to create a bogus credit to offset the AR balance, but when I create a new invoice, the credit reduces the amount of the new bill rather than clearing out the AR balance.

Going through and generating all conceivable reports, no where can I find in any of the system's reports does it show the client with an AR balance. It seems that it may only appear in the client's AR list window. Does just "ignoring" the corrupted entry pose any problems in the long run? Or do you think I should try to purge the transaction in some way?

Thanks.