Help

Welcome!

This community is for professionals and enthusiasts of our products and services.
Share and discuss the best content and new marketing ideas, build your professional profile and become a better marketer together.

1

Form view shown in the UI different from the one in database

Avatar
Pol Ancochea
1
1
3,152

We have an implementation on sales.order that worked correctly until last week. Suddenly, some of the custom fields disappeared. If I check the FormView in debug, it shows the correct xml, but the UI is wrong.


Tests:

    - Recovered a Monday backup, the UI is OK (lets call it "working" DB). - Check modules: Although there where some differences, installing and/or removing them didn't change anything. Module Drop shipping was in the "fault" DB and not in the "working" and Sale_service module was in the "working" DB but not in the "fault" one. Once this differences were solved, the problem persists and the same modules are installed in both DB. - A diff between FormViews confirmed that they are exactly the same. Even select arch from ir_ui_view where id = 566; returns the same content in both DBs. - Checked all possible configuration issues (menu, views…) everything is the same.

There is a symptom which I can't relate to the problem. Although module Product & pricelist Module is installed. The menu Sales/Configuration/pricelist is not shown in the "faulty" database.

Changes prior to the error
The only change done on the database was activating the Manage multiple locations and warehouses and Manage advanced routes for your warehouse options to create a Quotation from a Sale order. As far as I know no other changes were applied (there's another user with admin rights, but he claims that no change was done).


A solution could be restoring the backup, but that will only cover the issue that could raise at any moment if I don't find it's source. And users would loose their job from monday.
Avatar
Pol Ancochea
Avatar
Discard
1 Answer
0
Best Answer

Solved. For the record: The problem was in the settings for the sales module, someone changed some options ("Use pricelists to adapt your price per customers", "Allow a different address for delivery and invoicing","Product properties on order lines"). From now on, we've set the module audit to know who changes settings.

Avatar
Pol Ancochea
Comment Share
Avatar
Pol Ancochea
Avatar
Discard

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

Q&A Forum Regulations

Forum Regulations

By using the FAQ Forum on ERPOnline.vn website, you unconditionally agree to the following terms:

    1. Q&A Forum is a discussion environment to support each other in Odoo/ERPOnline implementation, in the spirit of "community support community", with internet address at: https://www.erponline.vn/forum/hoi-dap-7

    2. You are thoroughly responsible for the content submitted by you.

    3. DO NOT use the Q&A Forum for any activities that violate Vietnamese law and International Conventions to which Vietnam is a participant.

    4. DO NOT post content that is offensive, defamatory, or discredits other individuals or legal entities.

    5. DO NOT post advertisements or advertising content.

    6. DO NOT post content that is not related to management software and ERP in general as well as OpenERP and ERPOnline.vn in particular.

    7. DO NOT post copyrighted content or content, materials, products protected by Intellectual Property law without the written consent of the author.

    8. DO NOT embed images from other websites.

    9. You agree that all options, solutions, answers in the Q&A section on ERPOnline.vn website are for reference only. ERPOnline.vn website will not be liable if you have any damage when applying the plans given in the Q&A section on ERPOnline.vn website.

These terms and conditions may be amended to suit reality at any time without prior notice.