Cancel expense claim error | IntegrityError: (1048, u"Column ‘claimed_amount’ cannot be null")

[M.Ashraf]

any update

[root13F]

@M.Ashraf

IntegrityError: (1048, u"Column ‘claimed_amount’ cannot be null")

There is some field called Claimed Amount and the traceback shows that this value cannot be empty, so feed the correct value. Just a simple entry error that’s all.

[rohit_w]

@M.Ashraf

IntegrityError: (1048, u"Column ‘claimed_amount’ cannot be null")

Can you share the version of your erpnext app

[M.Ashraf]

it is already had value

[M.Ashraf]

[trentmu]

As a temporary fix (although not ideal), you could try something similar to this

Bench upgrade error: _mysql_exceptions.OperationalError: (1048, "Column 'in_dialog' cannot be null")

Hi, You can try this: cd ~/frappe-bench bench --site sitename mysql ALTER TABLE tabDocType MODIFY COLUMN in_dialog int(1) NULL; Then run bench update. After that you can change the previous mysql command as before: ALTER TABLE tabDocType MODIFY COLUMN in_dialog int(1) NOT NULL DEFAULT 1;

[rohit_w]

Your erpnext app version is 10.1.37, where as current stable erpnext version is v10.1.54. You need to update your erpnext app to v10.1.54 to fix this issue

[wale]

Hi @rohit_w

Trust you’re doing great. We are encountering the same issue:

ERPNext: v10.1.64 (master)
Frappe Framework: v10.1.56 (master)

Please advise

Kind regards,

[rohit_w]

Hi @wale

Can you check the employee_advance.json file has the field claimed_amount or not, if the field is there then just changed the modified date to today’s date and run the “bench --site your_site_name migrate” command

[wale]

Hi @rohit_w

Thanks for your response. The claimed_amount field is present in the employee_advance.json

I updated the modified date and ran the bench migrate command as advised but the error persists!

Any suggestions pls?

[rohit_w]

Hi @wale

The same field is available in the doctype employee advance?

[wale]

Hi @rohit_w

Are you referring to js or py file? Please clarify

Thanks

[wale]

Hi @rohit_w

In case you were referring to the DocType list, yes the field is in Employee Advance. It is a Currency type field with options set as Company:company:default_currency

[wale]

Hi @rohit_w

Trust you’re doing great. Any update here please? We really need a fix

Thanks

[wale]

Still awaiting a response on this please!

Thanks

[wale]

Hi @rohit_w

Trust you’re doing well. Really need some feedback on this. It’s affecting our operations significantly!

Thanks

[rohit_w]

@wale

Trust you’re doing well. Really need some feedback on this. It’s affecting our operations significantly!

Sent fix for this issue

[wale]

Many thanks @rohit_w

I hope this gets merged asap

Kind regards,

[wale]

It’s been merged and the issue is resolved

Thanks again @rohit_w