Based on your description it sounds like there might be a better layout issue rather than a calculation issue. Perhaps the field you need is set to not show on the Invoice. 

I thought that might be the case. So, I reset the layout back to the default one from the "new" section and it still shows the wrong balance.

I think I would have to see it to try to help. 

Here is what the AR List says vs an invoice.

You might need to rebuild the AR for just that matter. Make a backup first and if the rebuild AR doesn't fix the issue restore the backup and get help from a consultant or Sage (if a supported version).

Looks like they overpaid and had a credit balance. Those can sometimes cause issues.  Not always, but sometimes.  Then if you've fought with it a bit, it can all sort of go downhill.

I agree with Caren that the balance may need to be rebuilt, but I would first make sure the applications of payments are correct. Make a backup, try it and if it doesn't work, RESTORE the backup as sometimes the rebuild will lock things down even tighter.

That's about all we are going to be able to suggest via the bulletin board as these things tend to be quite specific to a particular situation and one size does NOT fit all when chasing them.

Best of luck.

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 rebuild of the AR worked.

I'm a little worried there are other ones with this issue, that I just haven't stumbled across. Is there any reason not to run the AR rebuild on all the clients?

Thanks so much for your help.

Aside from the fact that it will prevent undoing bills, it is generally not advisable. The rebuild can sometimes cause issues if a matter has some damage or certain other circumstances. 

I suggest reviewing all balances with AR and prebill reports and only rebuild those you are sure have issues.