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

Majid_Ejaz · December 7, 2019, 8:24am

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.

Akram_Mutaher · December 11, 2019, 4:59pm

Same Issue with me

Majid_Ejaz · December 11, 2019, 5:14pm

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.

Akram_Mutaher · December 11, 2019, 5:30pm

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

Frappe Framework: v12.0.20 (version-12)

Majid_Ejaz · December 12, 2019, 8:48am

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”)

Majid_Ejaz · December 13, 2019, 6:58pm

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

clarkej · December 13, 2019, 7:20pm

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

Majid_Ejaz · December 13, 2019, 7:28pm

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.

clarkej · December 13, 2019, 7:50pm

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?

Majid_Ejaz · December 13, 2019, 7:50pm

thanks, let me try.

Muzzy · December 14, 2019, 8:30am

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

Majid_Ejaz · December 14, 2019, 11:44am

Majid_Ejaz · December 19, 2019, 3:58pm

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.

Akram_Mutaher · December 19, 2019, 5:54pm

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

clarkej · December 19, 2019, 6:47pm

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

github.com

frappe/erpnext/blob/develop/erpnext/accounts/general_ledger.py#L228


      
          		.orderby(par.valid_from, order=frappe.qb.desc)
          	).run(as_dict=True)
          
          	cc_allocation = frappe._dict()
          	for d in records:
          		cc_allocation.setdefault(d.main_cost_center, frappe._dict()).setdefault(
          			d.cost_center, d.percentage
          		)
          
          	return cc_allocation
          
          
          def merge_similar_entries(gl_map, precision=None):
          	merged_gl_map = []
          	accounting_dimensions = get_accounting_dimensions()
          
          	for entry in gl_map:
          		# if there is already an entry in this account then just add it
          		# to that entry
          		same_head = check_if_in_list(entry, merged_gl_map, accounting_dimensions)
          		if same_head:

Majid_Ejaz · December 19, 2019, 7:07pm

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.

Create a purchase invoice
create a landed cost voucher and allocate it to that purchase invoice
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

clarkej · December 19, 2019, 7:25pm

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

Akram_Mutaher · December 19, 2019, 7:29pm

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)

Majid_Ejaz · December 20, 2019, 9:46am

I hope that I did it right

https://github.com/frappe/erpnext/issues/20031#issue-540895461