Odoo tips of the Month : October 2019

Dear Reader,

Being an expert of ODOO Since 12+ years, we have been releasing some useful tips and news around Odoo every month. Here we go for October 2019. Please note down the ODOO tips coming out of Media around ODOO especially Twitter and Facebook. Let's thank to them.

Here are the tips.

• Odoo v13.0 is detecting sql-injection from pylint check #OdooExperience #OdooExperience2019 https://github.com/odoo/odoo/pull/36583 
•  #odoo ORM refactoring: compute as onchange -> just use readonly=False and you are able to write it (w/out inverse) -> works on forms, write, create, works w/ related fields as well #OdooExperience
• #odoo ORM refactoring: control computation by context using '@api.depends_context("key_foo'")' Tip: use "uid" special key to depend on user and "company" to depend on company #OdooExperience
• Odoo v13 is faster thanks to new ORM single cache #OdooExperience #odooExperience2019

• You can find the new project for the JS Framework in https://odoo.github.io/owl. This project is named Owl JavaScript Framework. #Odoo #OdooExperience
• Why Odoo is faster than last year https://odoo.github.io/owl/ #OdooExperience #Odoo #OdooExperience2019
• Odoo : Automatic transfer is another new tool in our accounting application! You can compute the transfer and post it in a click! #odoo #OdooExperience
•  sitspak: https://goo.gl/T8wMPh Odoo : New tax return system to be discovered in #Odoo V13 ! #OdooExperience
•  Odoo : The app will automatically compute the best price. No need to lost time in calculating it yourself #Rental #OdooExperience

• Odoo : You can sign directly the contract, create an invoice, get paid... Everything in one flow. #Rental #OdooExperience
• Manage multiple accounting standarts with #Odoo by using our new tool: Automatic transfer #OdooExperience

• Odoo : Automatic transfer - move all the balance from an account at once #odoo #OdooExperience
• Odoo : New tax return system to be discovered in #Odoo V13 !
• Odoo : In #Odoo V13 an invoice is just a view of journal entries, so great ! #OdooExperience
• Odoo : The quick export button is now available everywhere in Odoo: it takes the column currently displayed on the screen and export exactly what you see! How  

       efficient! #OdooExperience #odoo #awesomebutton

• Wrong information in an invoice? No problem! Just edit the wrong lines and apply them on any other record with #Odoo Accounting app. #OdooExperience
•  In Accounting app #Odoo reads PDF files for you. It also calculates depreciation. Correct and edit inline taxes right away #OdooExperience
•  Odoo : Fully integrated skills management system in #odoo 13. A great way to improve your HR efforts in your company. Now live at #OdooExperience
• Did you check the new @Odoo #javascript library ? Been working with it the last couple of months and it's very powerful and intuitive :) ! Try it, https://github.com/odoo/owl, don't be shy ! #Odoo #OdooExperience
• New@OdooCommunitymodule in server-ux "mass_action" for@odoo 13.0 to allow users to make mass action (defined by python) on any items of any model. Review welcome here : https://github.com/OCA/server-ux/pull/97
•  #Odoo #migration tip of the day: view_type has been removed from the window action. Source commit: https://bit.ly/30O6k0S @ERPHarborCS#Odoo13 #OdooExperience2019
• #odoo13 #odoo #tip all boolean fields will be set to "False" by default.
• If there are more than 1000 products, usually it takes a lot time to load the #pos session and hence the screen. By using this module you can load more products as well as customers in comparatively very less time. https://apps.odoo.com/apps/modules/12.0/pos_quick_load_data/ #pos #pointofsale #odoo #OpenSource
• In #Odoo13, You can directly create an Employee from User form view by clicking on the "Create Employee" button. The linked employee will also be visible in Smart Button. Follow now to get regular news & updates about #Odoo.

• #Odoo #Developers To make the field optional in tree view you can set "optional" attribute to hide/show. For eg. <field name="state" optional="show"/> <field name="invoice_payment_state" optional="hide"/> A field without optional tag is mandatory shown in the tree view.
• In #Odoo13 users can select the columns they wish to see on the tree view. It also applies to O2M tree views. The selection is user-specific hence each user can have their own set of columns for display.
• #Odoo #migration tip of the day: track_visibility attribute removed in odoo 13.0, instead use tracking with sequence. i.e tracking=5. To track field value change.
• In #Odoo13, the access warnings are more informative. It directly shows the Record Rule name which triggered the warning, including the record name and username. Follow now to get regular news & updates about #Odoo.

• #Odoov13 #migration tip: Key must be of type string in selection fields. Ex: Allowed: [('0', 'Zero'), ('1', 'One')] Not allowed: [(0, 'Zero'), (1, 'One')] See discussion and source commit: https://github.com/odoo/odoo/pull/28891 @ERPHarborCS #Odoov13improvements #Odoomigration
• The Auto Enroll Groups M2M field allows you to automatically add members to a course. You'll need to manually remove them if needed. #eLearning #tips #odoo

• In #odoo13 @ api.multi is deletedhttps://github.com/odoo/odoo/commit/a8767716cfd14abc7f87204d4d180811f663b648
• #Odoo13 TIP: Make sure to add "readonly=1" on the tree view as well if you want to disable "Quick Mass editing". (Till v12 it has no effect on Non-editable views)
•  #Odoo 13 includes an easy way to export the current list view as an XLS file. Commit: https://github.com/odoo/odoo/commit/ac00548b28c0c384b5b1423f65405e4918101872

• Tip: In #Odoo 13 the activity view has a lot more options! You can add fields, show all activity types and even add images. See https://github.com/odoo/odoo/blob/ca9a733b27a1680403961eaa13cc62e5aa58a8fb/addons/project/views/project_views.xml#L702-L719

for example

• Using execute_values method of #Psycopg2 Insert multiple records in #PostgreSQL It will help to import/insert #Bulk records in #database. #Psycopg2 #Python https://bit.ly/31Zgld3
• In #Odoo13, "Add Shipping" section has been moved to the bottom of the screen and is now managed through a wizard. The "Get rate" button is removed and rates are automatically fetched upon onchange of Shipping method. Same for Coupons/Promotions.

•  In #Odoo13, New modules are added for "Subcontracting". A new option for "Subcontracting" is available under BOM Type. You can also select the Subcontractor location on the customer profile and enable "Resupply Subcontractors" under Warehouse config.

• Just released a python lib to automate migration of @odoo modules code : https://pypi.org/project/odoo-migrate/ @OdooCommunity thread : https://odoo-community.org/groups/contributors-15/contributors-147819 Still WIP. Reviews welcome.
•  #Odoo13, In Quotation view, while entering a stockable product, the salesperson can easily see the available and forecasted quantities of that product via the "info icon". Quite a handy feature for the end-users. #Odoo #Futurelens #Tips #Updates #News #ERP #Sales #Programming

• We have already migrated the most popular #OCA  @OdooCommunity module: the responsive backend web client for Odoo Community! https://github.com/OCA/web/tree/13.0/web_responsive
•  I notice that the Odoo official style guide states that Recordset Python variables should not have a _id/_ids suffix: "Don’t use partner_id to contain a record of res.partner" https://odoo.com/documentation/12.0/reference/guidelines.html#symbols-and-conventions
•  In #Odoo13, Landed Cost is now available for products with the Average Costing method(AVCO). System will automatically update the average cost price of the product when landed costs are validated. Moreover, users can now directly manage it through Vendor Bills. #Awaited #feature

•  #Odoo13 allows the calls and SMS directly from the contact form. Click the buttons to initiate them. Click here to know the SMS pricing in your country: https://iap-services.odoo.com/iap/sms/pricing #Odoo #Odoo13 #Futurelens #Contacts #Calls #Sms #ERP #Implementation #Developments #Customization
• #Odoo13Accounting Download the Free Module: https://apps.odoo.com/loempia/download/om_account_accountant/13.0.1.0.0/75NdL6UK9kIEGGQ5AcLaiJ.zip?deps
•  Tip: #Odoo 14 will come with a whole new JS framework named Owl. The first PR's are already landing in master (at https://github.com/odoo/odoo/pull/38423). The roadmap for Owl can be found at https://github.com/odoo/owl/blob/master/roadmap.md and all the code at #Odoo #Odoo14 #Futurelens #Owl #javascript
• #Odoo Font awesome 5.x will most likely come in V14. See https://github.com/odoo/odoo/pull/35826 Contact for Odoo Development

@thefuturelens #Odoo #Odoo14 #FontAwesome #New #Features #Tips #Programming #Updates #News #Development #Implements #Customization #ERP #TuesdayThoughts

• TIL Don't put a try / except inside a savepoint, goes double if it is also inside an api.Environment. Put it outside and save yourself my pain.
• In #Odoo13, You can add a Video URL to your Product which is visible on the WebStore. #Odoo #Ecommerce #Product #Video #Developers A new widget="video_preview" is available to preview the video in backend. #Follow now, #Comment to share your views on it & RT.
• Currently, #Odoo supports Video URLs from #Youtube, #Vimeo, #DailyMotion, #Instagram and #Youku.
• With each release, #Odoo improves a lot in system usability. In #Odoo13, when you make any change in the Settings of any module, the system notifies you about unsaved changes. The user should save first and then move. A small but important improvement. #LeverageOdoo

• #Odoo13, has a #cool new #progressbar to visualize the upload progress of a file in the #Documents module. This was missing in v12 which now makes it more #UserFriendly. #Odoo #Documents #Follow now to get regular tips & updates. #Comment to share your views on it & RT.
• No more Paid state on Invoice & Bills in #Odoo13. If the Invoices(Bills) are paid, there will be a ribbon 'Paid'. On the list view, you have the Payment state field though. #Odoo #ERP #CloudERP #LeverageOdoo

• #Python #Tips You can use #pandas str methods to rename the columns of your dataframe: 

>>> df.colums = df.columns.str.replace(' ', '-') 

>>> df = pd.DataFrame({'John Doe': [1, 2, 3], 'Jim Smith': [4, 5, 6]}) 

>>> df.columns = df.columns.str.split().str.get(-1)

 #Odoo #Futurelens

•  #odoo : New@OdooCommunityV12.0 module for @odoo that adds code in http://res.company (usefull in multi company context) Review available here : https://github.com/OCA/multi-company/pull/166
• SerpentCS Showcases the #Paytm #payment #gateway #integration - Paytm to #Odoo. Easy #Transaction #environment https://apps.odoo.com/apps/modules/12.0/payment_paytm_scs/ @Paytm #payments #Paytmcare #PaytmMoney #PaytmBank #ecommerce #system #paytmkaro #PaytmMall #PaytmApp #ERP #OpenSource #SerpentCS
• github.com/odoo/odoo/pull/39048 Full refactor pricelists in @Odoo for v14.0
•  #Odoo13, Education and Skills in Employee Form shows better UI representation of One2many data rather than conventional tabular view. This gives us an idea of UI  level customization which can be done for O2M. #Odoo #Developers You can study 2 widgets "hr_resume" & "hr_skills".
•  #Odoo commits to see : Raspberry Pi4 will be supported :https://github.com/odoo-dev/odoo/commits/master-iot-support-rpi4-qle
• Understanding Odoo Module Structure #erp #odoo http://www.getodootraining.com/understand-odoo-module-structure/
• Decorators are overkill for such use cases, and bloat the stacktrace. @api .one and@api.multi have been removed in #odoo 13. In my opinion, ensure_one() should be replaced by "assert" expressions: it's what it is. You could even save the CPU cost on production DB (-O)

What are the new features in Odoo 13 - Functional

What are the new features in Odoo 13 - Technical

Also check out our series of live webinars.

Serpent Consulting Services Pvt. Ltd. is providing various ODOO services in more than 173 countries. Our services includes Training, Support, Migration, Implementation, Development and offshore. We are a team of 82+ full time OpenERP/ODOO experts and having 12+ years of experience in Odoo/OpenERP. We have conducted 99+ local and international functional and technical training on OpenERP with 97% satisfaction ratio.

Look at the events and customer feedback.
Thanks.