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

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

Akram_Mutaher · December 20, 2019, 5:52pm

bench update

the last release solved this issue

Tufan_Kaynak2 · December 20, 2019, 6:12pm

Just ran
bench update --reset
Now at:
ERPNext: v12.3.1 (version-12)

Frappe Framework: v12.1.0 (version-12)

Cannot post LCV.

Majid_Ejaz · December 20, 2019, 6:59pm

This is a quick fix, at least we can move ahead. Why did I say this? We can create only one LCV per purchase document.

So temporarily, if you want to move ahead with your working, you can still move on. All you have to do is create an LCV e.g. “LCV001”. if you need to enter another LCV for the same purchase document, cancel LCV001, amend it and submit. This way at least your inventory valuation is maintained properly.

This will keep you going for now until there is a proper fix available for this problem i.e. multiple LCVs for the same purchase document.

I still have to check a few more things i.e. editing old LCVs where we have entered multiple LCVs for a purchase document and then come back with feedback.

In all honesty, this work well for now.

erpnext 12.3.1
frappe 12.1.0

Majid_Ejaz · December 20, 2019, 7:04pm

Are you able to create more than one LCVs for the same purchase document?