I managed to fix the problem! Yay! The only place I could see the zero amount credit note was when I listed customer balances. It didn't show up in their transaction history or anywhere else. So I looked up the credit note number (which I still have no idea where it came from), went to "void transactions" and voided that zero credit note. It now displays the correct amount on the statement when I select both "yes" or "not" for "show also allocated". I am so relieved. Thanks so much for all your help.

Thank you. Done... However it did not fix the problem. The only thing I can think of to do now is to create a new customer account for this customer and to redo all their transactions?

I am sorry but I have no idea how to do that. Please could you give me detailed instructions. I'm just a bookkeeper, don't know anything about coding, forgive the ignorance. Haha...

apmuthu wrote:

Yes. Overwrite the existing file.

Thank you. Should I download this? And then should I upload it to my FA somehow?

joe wrote:

This has been committed to stable.

The fixed file, rep108.php, can be downloaded here.

Joe

Hi, thanks a lot. I have not voided any transactions that I am aware of. Could I have done this accidentally without following the steps of: Setup > Maintenance > Void a transaction? I use version 2.4.4

poncho1234 wrote:

@hannelie can you please confirm if you void transactions and if there is any relation between voided transactions and customer balances; i.e. customer balances that are wrong - were any of their transactions voided.

Can you also state what version of FA you are using.

@Joe? Please I need urgent help

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.