Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
3 Odpovědi
3224 Zobrazení

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
Zrušit
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.

Nejlepší odpověď

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
Zrušit
Autor Nejlepší odpověď

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
Zrušit
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.

Nejlepší odpověď

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
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
1
dub 25
469
3
lis 24
2302
0
lis 23
920
2
čvc 23
2604
2
úno 21
3218