"Landed Cost Voucher on submit" Debit and Credit not equal for Purchase Invoice #PINV-01267-1. Difference is 420.0

Previously, we were running V12.1.6 of ERPNext on another VM

Purchase invoice was booked with a Landed Cost Vouchers (2x) allocated in sum of AED 420.

We installed V12.2.2 to another VM and upon submitting a new landed cost voucher in the new VM it gave the message “Debit and Credit not equal for Purchase Invoice #PINV-01267-1. Difference is 420.0.”

Now we cannot create Landed Cost Vouchers.

Same Issue with me

i just recieved a notification of a patch “Release v12.2.3”:

  • fix: Rounding Adjustment GL entry fix
  • fix: NULL issue while generating packed item

I don’t know if it will resolve the issue.

By the way it has nothing to do with rounding adjustment, I exported transactions to see if there is anything like rounding difference there was nothing.

So in my opinion unless we get a word from ERPNext team, we cannot be sure what could be the reason of that.

I run bench update but i still in
ERPNext: v12.2.2 (version-12)

Frappe Framework: v12.0.20 (version-12)

you may try this, but take the backup before you this

cd frappe-bench (you have done it already)
bench update (you have done it already)
bench reinstall (try this after “bench update”)

Here is the link to the screen recording. We really need the help

See also here Release v12.2.3 not fetched when update bench - #11 by clarkej

Hi @clarkej thank you for your input.

I have not run the patch yet, but do you think that this problem is linked with some patch?

My problem is Landed Cost Voucher please refer to the screen recording.

Some trial and error analysis in a test environment would probably help?

edit: A given patch may change the code, a database schema definition, and migrate database data too if required. So yes that might introduce and explain say a data conflict in your case?

thanks, let me try.

Please post GIF here of the recording. Its easy for anyone to view it and maybe give a suggestion.

com-video-to-gif%20(1) com-video-to-gif com-video-to-gif%20(2) com-crop

I installed the newer version in another server 12.2.3 the problem persists.

I entered one Landed cost voucher, at the time of adding another one it is giving this error.

so even though we update version to 12.2.3 the problem will not be resolved until we get an update to solve this issue.

The same issue with me, I have created Landed Cost voucher in the past that was everything good then after update tried to cancel it and git this error
Debit and Credit not equal for Purchase Invoice ".........". Difference is ".........".

actually that Difference amount is the Additional Cost that we added to Purchase Invoice

1 Like

The Difference message aim is to notify users of data precision issues, but in your case the data is clearly invalid

Which version are you using?

If you use the latest version you will know exactly what we are talking about.

If you use the newer version please perform following steps and you will get to know what we are talking about here.

  1. Create a purchase invoice
  2. create a landed cost voucher and allocate it to that purchase invoice
  3. create another landed cost voucher, you will not be able to do that as the system will through this message and you will be stuck. The difference it shows you is exactly the same amount on the landed cost voucher, that was entered first.

you cannot cancel any landed cost voucher neither can you create another one.

All data entered validated through normal process without any loss of its integrity.

So here we are stuck and cannot proceed.

Really appreciate your support. Thanks

Your steps to reproduce the error are a big help, please report this Issues · frappe/erpnext · GitHub

When we Submitted Landed Cost voucher for Purchase Invoice that make update in GL entrery for that invoice when I need to cancel that Landed Cost Voucher method not calculate the additional cost in debit so showing that error message

Please try it in
ERPNext: v12.2.2 (version-12)

Frappe Framework: v12.0.20 (version-12)

I hope that I did it right


1 Like