Customer bal. is zero but customer open balance shows a balance - why?

Rafi

Hi Rav

We created a new file in reckon as the old file size was too big.

We had a credit balance for this customer $220.00 as this was overpaid. We started with inputting the credit opening balance. During the year there was an invoice to the customer for $3491.80 & when he made the payment, he paid $3271.80 - short by $220.

Now when we check under the customer center for the customer it shows the balance as 0.00 as shown above in the snapshot above, but when we look at the customer open balance it shows some amounts and a balance is $220.00

Also, when i go to receive payments this shows that the invoice for $3491.80 is open, but we have already closed this invoice. Screenshot attached

Please advice how to get rid of this, so that the customer payment window does not show this invoice and also the customer balance report is cleared.

Kris_Williams

I would click on the invoice line and then apply the credits, see where that leaves you to start with.

Rafi

When you apply the credits on the invoice, it does something at the background and ends us showing some new figure and the balance in the customer open balance remains with some new figures appearing. But the final $220 balance still remains there.

Kris_Williams

I would look at the customer balance detail report for more info

Rafi

Hi Kris,

Even the customer balance detail report shows 0 balance. You can see that it started with a negative balance of $220 and got cleared when the payment for inv 166062 was made.

Kris_Williams

I am happy to have a look for you but I’m away until Saturday night, there's always a reason but sometimes a little elusive. And sometimes I find that you have to delete an entry and put it back in.

I’m available on Sunday if you want to call 0415940843

Rafi

Thanks Kris. But i don't work on Sunday. So if you want i can all you on Monday.

Kris_Williams

That’s fine no problem

Datarec_ReckonLtd

Look for any NEGATIVE lines in any invoices.