Skip to Content
Menu
This question has been flagged
3 Replies
2375 Views

Issue:

Just upgraded from Odoo13 to Odoo14

In Odoo14, once I have “posted” a bank statement I can not reset it to new.

Pushing button “reset to new”, leads to error “You cannot modify a posted entry of this journal because it is in strict mode.”

In Odoo13 “resetting to new” does not pose such problem.

 

Modules used:

Odoo 14 Accounting by Odoo Mates, Odoo SA, version 14.0.8.0.0

 

Analysis done so far

Reinstall the module

Validate the configuration of the “bank” journal (although I am not sure what to look for)

 

Anyone have any ideas?

 

 


Avatar
Discard
Author

@Mohamed Rafeeq: I was able to resolve this by following the advise of Odoo Mates. However, as you experienced, the application does allow you to untick the tickbox "Lock Posted Entries with Hash". I was only able to change that field by directly accessing the odoo database. I used pgadmin to directly access the odoo database. The table name is account_journal and can be found in the database in "Schema's", "Public", "Tables", "account_journal". The field name is "restrict_mode_hash_table" and it needs to be filled with [null]. In fact I changed it to [null] for all entries. This is not a setting you should use in a big company (your auditor will definitely not like it), but I have experienced that having this box unticked has many small advantages. I am assuming most CE users have unticked this box.

Best Answer

Hi,

This error is raised when "Lock Posted Entries with Hash" in the journal is ticked. Can you untick the same from the corresponding journal and see.

Thanks

Avatar
Discard
Author Best Answer

Thanks for your kind answer. In the bank journal, there is no such tick box. The checkbox ís present in the journals for sales and purchasing journals and indeed there the "lock posted entries with hash" flag is ticked. I can untick the flag, but I cannot save: when trying to save, I get message " You cannot modify the field Lock Posted Entries with Hash of a journal that already has accounting entries.".

Avatar
Discard
Author

I sharpened my skills on pgadmin and succeeded to untick the "Lock Posted Entries with Hash" in all journals. Technically that resolved the problem. However I am not sure that this behavior is logical. It seems that I am doing just regular things that also should be possible when the "hash protection" is "on". I'd value a reaction from the odoo mates colleagues to help me understand why the system reacts this way.

Best Answer

Hi

I am also facing the same issue- I can't reset my Journals and whenever I am trying, I am getting the same message " You cannot modify the field Lock Posted Entries with Hash of a journal that already has accounting entries"

 Anyone can help?


Avatar
Discard
Related Posts Replies Views Activity
3
Nov 24
919
0
Nov 23
470
2
Jul 23
2132
2
Feb 21
2519
1
Jun 18
8542