Skip to Content
Odoo Menu
  • Prijavi
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Knjigovodstvo
  • Zaloga
  • PoS
  • Projekt
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
Pomoč

[14.0] Can not reset “posted” bank statement to “new” | error “You cannot modify a posted entry of this journal because it is in strict mode”

Naroči se

Get notified when there's activity on this post

This question has been flagged
bank_statement
3 Odgovori
5005 Prikazi
Avatar
Bx6MbVtUu1uFbjAI5fwE

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?

 

 


0
Avatar
Opusti
Bx6MbVtUu1uFbjAI5fwE
Avtor

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

Avatar
Odoo Mates
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

0
Avatar
Opusti
Avatar
Bx6MbVtUu1uFbjAI5fwE
Avtor 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.".

0
Avatar
Opusti
Bx6MbVtUu1uFbjAI5fwE
Avtor

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.

Avatar
Mohamed Rafeeq
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?


0
Avatar
Opusti
Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Prijavi
Related Posts Odgovori Prikazi Aktivnost
bank statement import
bank_statement
Avatar
Avatar
Avatar
2
avg. 25
1982
Bank Statement in Odoo Solved
bank_statement
Avatar
Avatar
Avatar
Avatar
3
jun. 25
4487
Bank Statement Odoo OnLine.
bank_statement
Avatar
0
nov. 23
1945
Bank statement and reconciliation
bank_statement
Avatar
Avatar
Avatar
2
jul. 23
4021
Starting - Ending Balance Solved
bank_statement
Avatar
Avatar
2
feb. 21
4419
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now