• From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,195

Topic: Customer Balance Showing wrong Outstanding balance

@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

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Customer Balance Showing wrong Outstanding balance

@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

3 Reply by kvvaradha (edited by kvvaradha 11/22/2018 09:00:36 am)

  • From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,195

Re: Customer Balance Showing wrong Outstanding balance

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.

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Customer Balance Showing wrong Outstanding balance

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

/Joe

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Customer Balance Showing wrong Outstanding balance

You are right, your solution fixes the problem.

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

/Joe

  • From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,195

Re: Customer Balance Showing wrong Outstanding balance

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

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Customer Balance Showing wrong Outstanding balance

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

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Customer Balance Showing wrong Outstanding balance

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

apmuthu's Website