FrontAccounting forum — Customer Balance Showing wrong Outstanding balance

Re: Customer Balance Showing wrong Outstanding balance

null@example.com (apmuthu) — Fri, 23 Nov 2018 01:49:14 +0000

This commit can also be backported to FA 2.3.x as well by those on that branch still.

Re: Customer Balance Showing wrong Outstanding balance

null@example.com (joe) — Thu, 22 Nov 2018 09:31:33 +0000

The problem was fixed on the supplier side in another way.

This issue has been fixed and committed to stable. You can download the fixed file here. Thanks @kvvaradha.

/Joe

Re: Customer Balance Showing wrong Outstanding balance

null@example.com (kvvaradha) — Thu, 22 Nov 2018 09:22:42 +0000

I didnt check supplier balances. Please test it and apply the fix if necessary.

Re: Customer Balance Showing wrong Outstanding balance

null@example.com (joe) — Thu, 22 Nov 2018 09:17:10 +0000

You are right, your solution fixes the problem.

I will just check if we have the same problem on the supplier side.

/Joe

Re: Customer Balance Showing wrong Outstanding balance

null@example.com (joe) — Thu, 22 Nov 2018 09:09:25 +0000

Ok, I didn't try the allocation of the Journal Entry. Just a minute.

/Joe

Re: Customer Balance Showing wrong Outstanding balance

null@example.com (kvvaradha) — Thu, 22 Nov 2018 08:59:28 +0000

I have tried both official stable and unstable recent snapshot. Both gives the same error,

For Your understanding i have a screenshot of both journal entry. and the customer payment. What happens is in the screenshot

Screenshot

check the last column(Outstanding) and due to it the grand total is also affecting.

Re: Customer Balance Showing wrong Outstanding balance

null@example.com (joe) — Thu, 22 Nov 2018 08:21:28 +0000

@kvvaradha

Are you sure you are operating on the latest stable repo? We have fixed a lot of bugs here, includeing the Journal Entries.
If you have entered the Journal Entry before the bugs were fixed, then you get the wrong balances.

With the latest repo, I cannot reproduce your issue. Everything is ok here.

/Joe

Customer Balance Showing wrong Outstanding balance

null@example.com (kvvaradha) — Thu, 22 Nov 2018 04:28:20 +0000

@joe - Review and feedback it.

When we create a journal entry for customer opening balance. and when i open the customer balances report. The outstanding is not added there. And than i made payment to the journal entry through customer payments page. After that i see, that the outstanding balance is increased wth the payment amount. So i had a look into rep101.php

And i found one things, which is showing the wrong data there.

if ( $trans['type'] == ST_SALESINVOICE || $trans['type'] == ST_BANKPAYMENT)

which should be like this

if ($trans['type'] == ST_JOURNAL || $trans['type'] == ST_SALESINVOICE || $trans['type'] == ST_BANKPAYMENT)

I mean include the journal passing entries to be here.

Hope it fixes the issue