FrontAccounting forum — Customer statement reflecting wrong balance

Re: Customer statement reflecting wrong balance

null@example.com (poncho1234) — Thu, 11 Oct 2018 13:57:35 +0000

Go to Banking and General Ledger -> General Ledger Reports -> Audit Trail...It may give you a clue how the CN was created

Re: Customer statement reflecting wrong balance

null@example.com (hannelie) — Thu, 11 Oct 2018 06:49:46 +0000

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.

Re: Customer statement reflecting wrong balance

null@example.com (hannelie) — Thu, 11 Oct 2018 06:28:52 +0000

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?

Re: Customer statement reflecting wrong balance

null@example.com (poncho1234) — Tue, 09 Oct 2018 12:34:56 +0000

In /reporting rename the existing rep108.php to something like rep108OLD.php, then copy the new file into the /reporting directory/folder

Re: Customer statement reflecting wrong balance

null@example.com (hannelie) — Tue, 09 Oct 2018 06:59:13 +0000

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.

Re: Customer statement reflecting wrong balance

null@example.com (apmuthu) — Mon, 08 Oct 2018 16:02:13 +0000

Yes. Overwrite the existing file.

Re: Customer statement reflecting wrong balance

null@example.com (hannelie) — Mon, 08 Oct 2018 07:17:35 +0000

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

Re: Customer statement reflecting wrong balance

null@example.com (hannelie) — Mon, 08 Oct 2018 07:09:27 +0000

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.

Re: Customer statement reflecting wrong balance

null@example.com (joe) — Sat, 06 Oct 2018 10:55:00 +0000

This has been committed to stable.

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

Joe

Re: Customer statement reflecting wrong balance

null@example.com (joe) — Fri, 05 Oct 2018 08:19:52 +0000

@apmuthu

Just waiting for a response from @hannelie. I guess we should make this change anyhow, but it would be nice if it also helps @hannelie.

/Joe

Re: Customer statement reflecting wrong balance

null@example.com (apmuthu) — Fri, 05 Oct 2018 03:19:00 +0000

@joe: see if you want to implement @braathwaate's version of rep108.php, diff attached.

Re: Customer statement reflecting wrong balance

null@example.com (Braath Waate) — Thu, 04 Oct 2018 21:57:42 +0000

@hanneli

When the customer balance of the specific customer in question is incorrect on the statements, does the statement add up correctly? If not, the problem is a arithmetic error; otherwise, if the statement does add up, the problem is either missing or additional transactions, given that the balance is correct when viewed in other ways.

When you said that the customer statement shows an additional credit that is not correct, it made me suspect the latter case. If the problem is indeed an extra transaction (i.e. credit) that should not be there, and cannot be found elsewhere in the system, then I am guessing that this is a voided transaction, although I do not have a theory why the "show also allocated" would make any difference. In any case, it would suggest that the sql to locate transactions on the customer statement report is in error, if those transactions are not the same as shown in other parts of the system.

If you can isolate the problematic transaction, which perhaps you already have, then you can examine the database for more clues, using the data from this transaction to find it using the mysql client.

I also added void screening to the customer statement in https://github.com/braathwaate/frontac24/blob/master/rep108.php. You could try replacing your core/rep/rep108.php with this file. However, it is just a wild guess at this point that it would work.

Re: Customer statement reflecting wrong balance

null@example.com (poncho1234) — Thu, 04 Oct 2018 20:55:49 +0000

@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.

Re: Customer statement reflecting wrong balance

null@example.com (joe) — Thu, 04 Oct 2018 20:37:11 +0000

Hello again Guys.

I have made some investigations into this and I cannot find anything wrong. Please help me. It might be an old bug belonging to the voiding history.

@Braate Wathe, if you have a possible solution, please provide it, so we can help @hanneli.

Joe

Re: Customer statement reflecting wrong balance

null@example.com (joe) — Thu, 04 Oct 2018 14:15:25 +0000

@Braathwaate, your wild guess used to be good

Joe