Unable to submit purchase invoice: Debit and Credit not equal for this voucher

Hi Everyone,

I am having a problem submitting a purchase invoice. I keep on getting the error. 

Debit and Credit not equal for this voucher: Diff (Debit) is -0.0449999980628

It may be some rounding issue in the code. Was hoping someone can give some advice on how to get around this. 

Thanks,
Nadim



You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/7d0b1fb8-87c4-454b-acec-011a3ff2391c%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

Try setting decimal accuracy to 6 decimals under Setup

On Saturday, May 10, 2014 1:02:15 PM UTC+8, Nadim Bacho wrote:
Hi Everyone,

I am having a problem submitting a purchase invoice. I keep on getting the error. 

Debit and Credit not equal for this voucher: Diff (Debit) is -0.0449999980628

It may be some rounding issue in the code. Was hoping someone can give some advice on how to get around this. 

Thanks,
Nadim



You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/f4423a7f-08cf-4c7f-98a9-9073e114ecd8%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

Which version of erpnext uou are using? This problem was there in v2.0 but fixed in v3.0.

On 10 May 2014 10:32, "Nadim Bacho" <nb...@gmail.com> wrote:
Hi Everyone,

I am having a problem submitting a purchase invoice. I keep on getting the error.

Debit and Credit not equal for this voucher: Diff (Debit) is -0.0449999980628

It may be some rounding issue in the code. Was hoping someone can give some advice on how to get around this.

Thanks,
Nadim



You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/7d0b1fb8-87c4-454b-acec-011a3ff2391c%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.



You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAMfNnThgEwz35TT9TrYDSqHJcQpaxaqDqygK20q811gK6hYpQw%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

Lxnow - I changed the float precision to 6 decimals and I was finally able to submit it. This seems like a good work around, but some problem still exists.  

Thanks a lot for your response!

On Saturday, May 10, 2014 6:51:14 AM UTC, lxnow wrote:
Try setting decimal accuracy to 6 decimals under Setup

On Saturday, May 10, 2014 1:02:15 PM UTC+8, Nadim Bacho wrote:
Hi Everyone,

I am having a problem submitting a purchase invoice. I keep on getting the error. 

Debit and Credit not equal for this voucher: Diff (Debit) is -0.0449999980628

It may be some rounding issue in the code. Was hoping someone can give some advice on how to get around this. 

Thanks,
Nadim



You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/3563e051-7aba-4dc0-ad0b-9c8406e7b6d8%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

Hello,

I’m getting the exact same error message “Debit and Credit not equal for Purchase Invoice #PINV-00025. Difference is 0.06”. Is there a permanent fix for this problem or do I have to increase the float precision as workaround solution?

Please advice.

Thanks,
Wee Nee

Which version?

@rmehta i’m on version 5.1.2.

@rmehta Any feedback on this?

This should have been updated. Floating point differences are automatically rounded off.

I’m also having this problem.

Hello ERPNXT experts i’m also getting same problem .
error is following
“Debit and Credit not equal for purchase invoice #PINV-00001. Differance is 0.08”
i try all logic’s which discuss early but still not moving ahead.
please suggest me how to solve this issue .
m using
ERPNext: v6.21.0
Frappe Framework: v6.22.0

Please check image which attached here.

Regards
vishal

This is weird, do you have a customization?

Hello @rmehta , sir i didn’t make any customization in this
why don’t you check directly from my account …
please find my id = 1worldguru@gmail.com
as per my little knowledge i try my best to find solution on this
but sir i’m failure to find correct solutions … this problem not finding in
purchase order or purchase receipt … in this both docs system have auto rounding facility
but in purchase invoice i didn’t find this options .
check below images for reference.

Regards
vishal

I’m also having this problem.
My actual Erpnext version is v6.21.6, updated yesterday.
The error message is “Debit and Credit not equal for Purchase Invoice #URA-3-2016. Difference is 0.05.”
I changed the float precision from 2 to 6 decimals but nothing.

CC @nabinhait

@1worldguru and @Mladen_Jelavic please create a record in the demo.erpnext.com. It will help to analyse the case and to fix it.

Pushed a fix [fix] GLE for Rounding loss allowed upto 1 for all transactions except JE by nabinhait · Pull Request #4838 · frappe/erpnext · GitHub

Hello,

i have the same problem after updating to latest version. I am not able to cancel document created from POS. This is the error

How could i cancel this document?

Should i create issue on github for this?

Can you replicate the issue? If yes, then please create a record in demo.erpnext.com and add the link of the record in the github issue.