1 Topic by DrCard (edited by DrCard 01/13/2022 03:15:05 pm)

  • From: Bahrain, Manama
  • Registered: 12/24/2019
  • Posts: 34

Topic: Incorrect Journal Balance (sales invoice)

The journal entries that was made automatically from the sales invoice is Dr ≠ Cr


The sales invoice amount is 5.060 and there is a tax included (0.847116%)

https://ibb.co/6JCLX9k

The Journal entry here as you can see the total of Dr ≠ the total of Cr as front accounting shouldn't allow unbalanced amounts but in this transaction it did.

Look at the following:

https://ibb.co/kB0tDwV

This is our company setup:

https://ibb.co/fpF4sjL

This is the tax setup:

https://ibb.co/L08LSKs

Display setup:

https://ibb.co/R3PN5j3

Post's attachments

IncorrectJournal_Entries.zip 145.5 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.
  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,159

Re: Incorrect Journal Balance (sales invoice)

Check the order of the entries. Looks okay except for the order.

apmuthu's Website

  • From: Bahrain, Manama
  • Registered: 12/24/2019
  • Posts: 34

Re: Incorrect Journal Balance (sales invoice)

apmuthu wrote:

Check the order of the entries. Looks okay except for the order.

I checked the orders and the entries but it still gives me the same problem.
I think this is a bug.

Thanks for the reply.

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

Re: Incorrect Journal Balance (sales invoice)

I think this bug was fixed short after the 2.4.12 release.

We have fixed some more PHP 8 bugs as well.

Vi are planning a minor release next week so hopefully you will be satisfied then.

Joe

5 Reply by DrCard (edited by DrCard 09/07/2022 11:35:14 am)

  • From: Bahrain, Manama
  • Registered: 12/24/2019
  • Posts: 34

Re: Incorrect Journal Balance (sales invoice)

joe wrote:

I think this bug was fixed short after the 2.4.12 release.

We have fixed some more PHP 8 bugs as well.

Vi are planning a minor release next week so hopefully you will be satisfied then.

Joe

I'm running Version 2.4.12 Build 27.08.2022
and its not fixed

I'm still facing the same problem

you can duplicate the transaction and setting that are in the pictures, you will get the same result

ill will check the next release

thanks Joe

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

Re: Incorrect Journal Balance (sales invoice)

Hello again @DrCard,

Yes, I can reproduce your error.

Something has been changed internal that has caused this rounding error. We will investigate and fix this asap.

Joe

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

Re: Incorrect Journal Balance (sales invoice)

The problem has now been solved. In certain cases you will get an extra line with a rounding error, when this happens.

This way the journal vouchers will always balance.

It has been committed to stable repo.

You can download the fixed /gl/includes/db/gl_db_trans.inc from here,

Joe