Topic: Customer statement reflecting wrong balance
I have got a problem with one customer's account. This customer's balance is correct in "customer balances", however, it does not reflect the same on the statement. I send out bulk statements to all our customers at once. When sending I select "no" for "show also allocated", because I only want it to show what is outstanding and I also don't want to send out zero statements. We have many old clients on the system with zero balances and they don't want to receive a monthly statement. Also when I do select "yes" for "show also allocated" then it shows the complete history of all the customers' transactions which means every customer will get a statement of like 5 or more pages. Which I don't want.
This is the first time I've had the problem with a customer's account where the balance differs when selecting "yes" and "no". All other customers have the exact same balance it is just the list of transactions showing that is different. I have reallocated the payments several times, but nothing helps. I've noticed that a zero credit note shows on the customer balance, however I cannot find that credit note on the system anywhere. I don't know if that could be causing the problem.
To summarise, when I select YES for "show also allocated" the amount is correct, when I select NO, it shows the customer has a credit with us which is not correct. When I go to "add and manage customers" and select their transaction history, everything there is perfect, total at the top is correct. It is only on the statement where I have the problem.