i have items more than 15000 …now i need to add ‘Default Material Request Type’ and ‘Valuation Method’ to all my items.
after importing excel using update records …it shows error with ‘Valuation Method’
error log:
Traceback (most recent call last):
File “/home/umoms/moms-bench/apps/frappe/frappe/core/doctype/data_import/importer.py”, line 396, in upload
original.save()
File “/home/umoms/moms-bench/apps/frappe/frappe/model/document.py”, line 260, in save
return self._save(*args, **kwargs)
File “/home/umoms/moms-bench/apps/frappe/frappe/model/document.py”, line 299, in _save
self._validate()
File “/home/umoms/moms-bench/apps/frappe/frappe/model/document.py”, line 466, in _validate
self.validate_set_only_once()
File “/home/umoms/moms-bench/apps/frappe/frappe/model/document.py”, line 493, in validate_set_only_once
frappe.CannotChangeConstantError)
File “/home/umoms/moms-bench/apps/frappe/frappe/init.py”, line 353, in throw
msgprint(msg, raise_exception=exc, title=title, indicator=‘red’)
File “/home/umoms/moms-bench/apps/frappe/frappe/init.py”, line 339, in msgprint
_raise_exception()
File “/home/umoms/moms-bench/apps/frappe/frappe/init.py”, line 312, in _raise_exception
raise raise_exception(msg)
CannotChangeConstantError: Value cannot be changed for Valuation Method
Have you created stock transactions for those items already? If so, you cannot change the Valuation method.
There is no stock transaction for those items. the fact is
i created an item without selecting as ‘Maintatin Stock’. Now i want to make it as stock item and also need to set
Default Material Request = “material transfer”
Valuation Method = “moving average”
here i able to select default material request. but text box for Valuation Method not displaying
Did you check the valuation method in stock settings?