Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
3 Odpowiedzi
3927 Widoki

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?

 

 


Awatar
Odrzuć
Autor

@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.

Najlepsza odpowiedź

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

Awatar
Odrzuć
Autor Najlepsza odpowiedź

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.".

Awatar
Odrzuć
Autor

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.

Najlepsza odpowiedź

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?


Awatar
Odrzuć
Powiązane posty Odpowiedzi Widoki Czynność
3
cze 25
3366
1
kwi 25
1187
0
lis 23
1366
2
lip 23
3349
2
lut 21
3735