Sunday, 10 September 2017

New in V11

Coming soon.. with detail...

Tuesday, 5 September 2017

How to use profile in Odoo ?


How to use profile in Odoo ?


If you want to know number of queries, calls and time of each method you can use @profile in Odoo.

You can simply use profile by importing profile

from odoo.tools.profiler import profile

after importing you can add it in any method. Suppose If I want to know the executing time of partner creation, I can simply write the following code in file,

    @api.model
    @profile
    def create(self, vals):


Now, restart your server.

Here, I had added @profile on res.partner creation. So When I create contact(res.partner) in Odoo the system logs entries.


calls     queries   ms
res.partner ------------------------- /home/XYZ/workspace/master/odoo/addons/base/res/res_partner.py, 489

1         0         0.02          @api.model
                                  @profile
                                  def create(self, vals):
1         0         0.01              if vals.get('website'):
                                          vals['website'] = self._clean_website(vals['website'])
1         0         0.01              if vals.get('parent_id'):
                                          vals['company_name'] = False
1         0         0.02              tools.image_resize_images(vals)
1         20        97.75             partner = super(Partner, self).create(vals)
1         2         5.21              partner._fields_sync(vals)
1         0         0.18              partner._handle_first_contact_creation()
1         0         0.01              return partner

Total:
1         22        103.19  


Here, total 103.19 milliseconds time taken to create new partner..

There are more parameter you can pass in profile.


all methods for all odoo models by applying the optional filters.

1. param whitelist: None or list of model names to display in the log        
    ex.  @profile(whitelist=['sale.order', 'ir.model.data'])

2. param files: None or list of filenames to display in the log
    ex. @profile(files=['/home/openerp/odoo/odoo/addons/sale/models/sale.py'])

3. param list blacklist: list model names to remove from the log

4. param int minimum_time: minimum time (ms) to display a method
5. param int minimum_queries: minimum sql queries to display a method

..Enjoy..

Tuesday, 27 June 2017

How to import products with their initial inventory ?


In some cases we need to import products with their inventory. 


There are several ways to do this,

either,
- We can do manually by adding products and their qty
- for each product and its qty create stock moves either manually or import CSV
- or any complex way

The easiest way to do this, is import inventory adjustment through Odoo import functionality.

Here are some steps :

- First create test inventory adjustment,
- add few products and then export that inventory adjustment(just for export template purpose).
- Just cancel/delete that inventory adjustment.

Now, in exported csv you can add your products(database ids) and qty.

That's it ,

After adding your inventory products in CSV, you can import that CSV in Odoo.

Note : At the time of validate CSV if you got any error related to products, then just select product database Id from list.

Here attached sample csv which you can import easily, => Click Here

Video : https://youtu.be/K1UrDPjpJr4

..Thanks..

Use of different location type in Odoo

Vendor Location: Virtual location representing the source location for products coming from your vendors

- This is the locaction you can set on your vendor, may this will be generic or supplier specific.
- This location will be considered when you are purchase something, in your incoming recipt "Source Location Zone".


View: Virtual location used to create a hierarchical structures for your warehouse, aggregating its child locations ; can't directly contain products

Internal Location: Physical locations inside your own warehouses,

- They can be the loading and unloading area of your warehouse, a shelf or a department, etc.

Customer Location: Virtual location representing the destination location for products sent to your customers

Inventory Loss: Virtual location serving as counterpart for inventory operations used to correct stock levels (Physical inventories)

Procurement: Virtual location serving as temporary counterpart for procurement operations when the source (vendor or production) is not known yet. This location should be empty when the procurement scheduler has finished running.

Production: Virtual counterpart location for production operations: this location consumes the raw material and produces finished products

Transit Location: Counterpart location that should be used in inter-companies or inter-warehouses operations

The Virtual Locations are places that do not exist, but in which products can be placed when they are not physically in an inventory yet (or anymore). They come in handy when you want to place lost products out of your stock (in the Inventory loss), or when you want to take into account products that are on their way to your warehouse (Procurements).
(source from : odoo)

Monday, 3 October 2016

New in V10

New in V10

As you all know Odoo v10 released on 3rd October, 2016.

The following are the highlights of new features added in Odoo v10.


  • Event :
    • Event Barcode
    • Email Schedule : Easy to Followup
  • Account :
    • Tax Cloud
    • Accounting Reports with Analytic Account
    • Multi-level hierarchy in trial balance [ https://drive.google.com/file/d/0B21cUNlAdZ6gM0w1dmVIUVNEWG8/view?usp=drivesdk ]
    • New CSV, CAMT bank statement import (different Modules for csv import)
  • HR :
    • HR Attendance (Kiosk Mode)
    • Print Employee Badge
    • Sign In/Out authenticate using Pin
    • Timesheet Apps : usability Improvement
  • POS :
    • POS Serial Number
    • POS Default Cash Control
    • POS Restaurant : Transfer order from one table to another
  • Stock:
    • Option in Payment Gateway to auto confirm SO
    • Out of stock warning in option
    • Delivery : choose the package when clicking on put in pack
    • Inventory : Can apply Quality control on picking
    • Serial Number Upstream Tracebility
    • Delivery Order : Add margin in % to cover lost
    • Picking : Up/Down Tracebility
  • Website/ Ecommerce:
    • B2B/B2C
    • New checkout design for address selection
    • Ecommerce : Add multiple images of products
    • Improved Portal Frotend view
    • Easy to set website Favicon
    • Ecommerce insight: Save, manage, and reuse credit cards. Authorize amount at checkout and capture at shipping.
    • Ecommerce user can pay through stored card
    • Easy to trace Website Orders, Invoices
  • Expense :
    • Accountant can direct pay the Expense
    • Email Alias to direct record Expense (based on expense internal reference, system identify product and create expense accordingly)
  • General / Discuss :
    • history of chatter clickable (source document)
    • The debug mode does not split the web assets by default
    • Keyboard shortcuts detailed on the top right menu from the home page
    • Easy to maintain user access (set default access to default user)
    • Search date ranges quickly with the new in-between operator.
    • Canned responses and /commands in discuss
    • Create in one click
    • Company setting of apps moved to Apps > Setting
    • Any HTML type report easily edit in app view => https://drive.google.com/file/d/0B21cUNlAdZ6gWHl5NUE4b0lqc0k/view?usp=drivesdk
  • Studio
    • Easy to Create new Apps
    • Easy to add new field in either form view or tree view
    • Channge string, help message, views, reports,....
  • Purchase :
    • Editable PO: Easy to edit confirmed PO
    • Purchase Teander : Blanket order Type
  • Project:
    • Project : project dashboard is now based on user's favorite
    • Project : Easy to maintain Sub-Task
    • Forecast : Grid : By User, By Project
  • Subscription:
    • Subscription dashboard by company, Tag, Contract
    • Subscription : New Cohort Analysis
  • Helpdesk Management
    • Easy to assign tickets by different Assignation Method
      • Randomly
      • Manually
      • Balanced
    • Generate Tickets
      • Email Alias
      • Live Chat
      • Ticket Form
      • External API
    • Performance
      • SLA Pollicies
      • Rating
      • Canned Response
    • Self-Service
      • Forum- Help Center
      • Slides- eLearning
  • MRP
    • PLM
    • MPS
    • Maintenance
    • Quality
    • Easy to know "Overall Equipement Effectivness"
    • Unbuild Order , Scrap Products
Enjoy Odoo v10
Demo : odoo.com
Trial : odoo.com

..Enjoy..

Tuesday, 12 July 2016

Odoo Barcode Print



Barcode not getting printed on reports..

May have library issue follow the  following step :



Download and extract  : http://www.reportlab.com/ftp/pfbfer.zip

Create a folder named “fonts” under : (from command line)
/usr/lib/python2.7/dist-packages/reportlab/

$ cd /usr/lib/python2.7/dist-packages/reportlab/
$ sudo mkdir fonts

Move all the *.pfb files and paste into this folder (fonts) (from command line)

Go to extracted folder : $ sudo mv *.pfb /usr/lib/python2.7/dist-packages/reportlab/fonts


..Enjoy..