• From: USA, CA, Valencia
  • Registered: 12/31/2017
  • Posts: 84

Topic: Client balance inconsistency in FA 2.4.1 w/ journal entry

Hello,

I have noticed if you debit a clients account receivables directly from a journal entry that there seems to be an error. when you check the client under Customer Transaction Inquiry all looks well but when creating a new invoice under Current Credit the calculation will be incorrect showing they have more credit available to them.

for Example

Sales Invoice    2/21/18 Debit 65.00
Sales Invoice  4/18/18 Debit 65.00
Customer Payment 4/20/18 Credit 65.00
Journal Entry 4/26/18 Debit 65.00 (Customer cheque was returned)

Client's balance should be 120.00 and it shows that in Customer Transaction Inquiry
but in enter direct invoice it shows 0.00 so it calculates the debit to A/R as a credit

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

Re: Client balance inconsistency in FA 2.4.1 w/ journal entry

You have run into an earlier bug. Please upgrade to the latest version, 2.4.4.

Joe

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

Re: Client balance inconsistency in FA 2.4.1 w/ journal entry

Yes, it was fixed a year ago:
Commit
Fix to above commit

Commit

Will also include a change in primary key for multiple debtors as well. Check the sql/en_US-new.sql file for differences with your chart.

apmuthu's Website

  • From: USA, CA, Valencia
  • Registered: 12/31/2017
  • Posts: 84

Re: Client balance inconsistency in FA 2.4.1 w/ journal entry

Sorry to delay on this response I've just been very busy.

I just wanted a question about the upgrade and this transaction.

Should I just do the update with the transaction how it is or should I void the transaction update then redo the transaction.

Basically, is it a problem how the transaction was written to the ledgers or just how it was interpreted / read from them.

Thank you.