Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
OpenERP

Featured

How to delete provisions fields in OpenERP(Odoo)?

In provisions fields first we have to go in .py file (Python file) After that we have to decide where we want delete fields and then write the python code of that field. use below code in .py(python file): cr.execute('SELECT id FROM account_...

pgadmin not connect to openerp server and open the openerp than accour error

If you faces such below error pgadmin not connect to openerp server and open the openerp than occur error than follow these step to resolve this type of error 1- first update the postgresql.conf file in pgadmin go to this location /var/li...

Error occur when create new server in pgadmin

When Error occur to create new server in pgadmin than use these commond in terminal to resolve this type of problem in pgadmin 1-sudo -u postgres psql 2-sudo -u postgres psql template1 3-ALTER USER postgres PASSWORD 'newPassword';

How to set the traceability fields in OpenERP(Odoo)?

In traceability fields first we have to go in .py file (Python file) After that we have to decide where we want traceability fields and then give start to end Path to that field.Use below .py code in python file: 'date': fields.date('Entry D...

How to manage amount interest provision in accounting in OpenERP(Odoo)?

In below example, I have written Python script to amount interest provision in accounting. Use below python code in your .py file : if demand.amount_interest: cfpline_obj.create(cr, uid, { 'origin': dem...

How to make the confirmation receipt through python code in OpenERP(Odoo)?

In below example, I have written Python script to confirmation receipt through python code. Use below python code in your .py file : 'partner_id': fields.many2one('res.partner', 'Partner', change_default=True, required=True, states={'confir...

How to inherit workflow in openerp

To Inherit workflow in openerp use this below code in worlflow.xml file in openerp <record id="module_name.act_done" model="workflow.activity"> <field name="wkf_id" ref="module_name.wkf"/> <field name="name">done&l...

How to create workflow in openerp

To create workflow in openerp use these below step In academy.py file import academy.py In __openerp__.py file data:["academy.xml", "academy_workflow.xml"], In academy.py file class session(osv.osv): _...

How to make unique field and not allow duplicates records in openerp

To make a unique field and do not allow duplicates records in openerp, below is the solution In .py file use this code:- class course(osv.osv): _name="course" _columns={ "name":fields.char("Name"), } ...

Creat Google Maps in OpenERP

Use below method to create Google Maps in OpenERP 1- use this code .py file in openerp from openerp.osv import osv,fields class launch_map(osv.osv): _inherit = "res.partner" def open_map(self, cr, uid, ids, context=None): ...

How to manage the account cashflow operations in OpenERP(Odoo)?

In below example, I have written Python script for account cashflow operations. see below python code in .py file : import time from datetime import datetime, date, timedelta import tools from osv import osv, fields import decimal_precision...

How to manage each tax group in Point Of sale in OpenERP(Odoo)?

In below example, I have written Python script for each tax group. see below python code in .py file : (tax_code_pos, base_code_pos, account_pos, tax_id)= (0, 1, 2, 3) for key, tax_amount in group_tax.items(): ...

How to add the skype field in .py file(Python) in OpenERP(Odoo)?

For the skype field first we have to go in .py file (python file) After that we have to decide where you want to give skype field and then give attribute of skype to that field. Like below python code in .py file : from openerp.osv impor...

How to make the scheduled call in OpenERP(Odoo) ?

To make the scheduled call in OpenERP(Odoo) you must follow the below steps- Step-1 Go to Sales Modules-> Phone Calls->scheduled calls Step-2 Call Summary ->Date->Duration->Responsible ->Administrator Step-3 Sales Team...

How to generate the barcode for product in openerp (Odoo)?

You will need the following kind of python code declaration in your .py file: class product_category(orm.Model): _inherit = 'product.category' _columns = { 'ean_sequence_id': fields.many2one('ir.sequence', 'Ean Sequence'...

How to set the incoming email servers in OpenERP (Odoo)?

How to set the incoming email servers in OpenERP (Odoo)? Step-1 Go to settings -> General Settings Step-2 Click on configure incoming email servers->Create Step-4 Name->Server Type ->POP Server Step-5 Click On Server Informatio...

Manifest file __openerp__.py in OpenERP

In OpenERP all the content is included in Manifest file __openerp__.py. This file, which must be a Python dict literal, is responsible to- 1- Determine the XML files that will be parsed during the initialization of the server. 2- Determine...

How to inherit the modules in OpenERP (Odoo) ?

First we have to look customized module, according to there requirement fields class, model and then we have to decide to inherit existing module. As in below .py (Python file):- class Demo(osv.osv): _inherit='sale.order.line' // sale...

How to use defaults function in OpenERP(Odoo)?

In defaults function first we have to go in .py file (python file) After that we have to decide where we want defaults function and then give attribute defaults function to that field. See below python code in .py file for reference : -class h...

How to Set the Multi Companies and Technical Features in OpenERP (Odoo)?

Step-1 Go to Settings menu Step-2 Select submenu -> Users -> User Step-3 Selcet Administrator -> Create Step-4 Select Access Rights -> Technical Settings Step-5 Select -> Multi Companies -> Technical Features

How to make the X-path in OpenERP (Odoo)?

In X-Path first we have to go in View_XML file (XML file) After that we have to decide where we want X-Path and then give Initial to last Path to that field. See below View_Xml code in Xml file . <?xml version="1.0" encoding="utf-8"?>...

How to make readonly field in OpenERP(Odoo) ?

In readonly field first we have to go in .py file (python file) After that we have to decide where we want readonly field and then give attribute readonly to that field. See below python code in py file for reference : - class spartner(...

How to refresh all modules and database at a time in OpenERP (Odoo)?

Step-1 Go to terminal -> Start the OpenERP Server-> and enter the below commands Step-2 ~/workspace/OE7_Test$ ./openerp-server Step-3 ~/workspace/OE7_Test$ ./openerp-server u all Database name So this will Refresh all the modul...

How to hide the field in OpenERP (Odoo) ?

To hide the field first we have to go in .XML file (OpenERP) After that we have to decide where we want to hide the field and then give attribute invisible to that field. As in example below, .XMLcode in XML file : - <record id="view_or...

How to make the onchange function in OpenERP(Odoo) ?

In onchange function first we have to go in .py file (python file) After that we have to decide where you want to give onchange function and then give attribute on_change to that field. Like below python code in py file : def oncha...

How to install OpenERP (Odoo) in windows server 2012 R2 ?

Step-1 Go to the link-> http://nightly.odoo.com/7.0/nightly/exe/ Step-2 Select->latest exe file like-> openerp_7.0.20150622.exe -> (Latest Date) 03:29->129251691 Step-3 click on Downloaded exe->select the languages->cl...

How to Edit fields label in module in openerp

If you want to change or edit the label in module in OpenERP, follow the below example. EXAMPLE:- change label like that in product form change label of list_price(Sale Price ) to list_price(Max Price) in product.product .xml file- &l...

"Initial Setup and AvaTax Configuration In OpenERP (Odoo)"

About AvaTax-> Global companies know that outsourcing key business functions like payroll and tax compliance makes good sense. Avalara AvaTax automates Value Added Tax (VAT) calculation directly within your accounting software. Whether yo...

How to set the PayPal In OpenERP-8 (Odoo)?

Step-1 Install Payment_Paypal Module. Step-2 Settings-->Accounting-->Configuration -->Paypal account -->Show payment Step-3 Settings-->Payments-->Payments Acquiers-->Select Paypal Step-4 Pa...

How to define States of object in openERP-7 & OpenERP-8(Odoo)?

First we have to define the States So to define states follow the below code. columns = { state: fields.selection([ (new,New), (assigned,Assigned...

How to Modifying a report in OpenERP-6.1 ?

Step-1 First we have to Modify existing reports which will then replace the originals in our OpenERP database, Step-2 create new reports for the selected object. select Report > Modify Existing Report . Choose the report Request for Quo...

How to Add the Bar codes in RML files in Openerp-7 and openerp-8(Odoo)?

Barcodes can be generated using the tag in RML files. The following formats are supported codabar code11 code128 (default if no code specified) standard39 standard93 i2of5 extended39 extended93 msi fim postnet You can ch...

How to activate the developer mode in OpenERP (Odoo) ?

Step-1 Go to browser Step-2 Click on Administrator: Step-3 Click on about OpenERP Step-4 Click on activate the developer mode. You can activate the developer mode in the About Box located under your username in the top right cor...

How to create recurring invoice in OpenERP-8(Odoo)?

Installation of Subscription Module in Open ERP Step 1:- Install -> Subscription Module. Step 2:- Go to Settings -Technical - Automation - Recurring Types -create record must be Invoice. Step 3:- Go to Settings - Technical -Au...

Form Views Default Rules

Default Rules of Form Views- Form Views shows how each object is displayed in openerp browser. The field disposition in a form view always follows the same principle. Fields are placed on the screen from left to right, and from top to bo...

osv.osv object in OpenERP

osv.osv object in OpenERP:- OSV is a openerp descriptor class which must inherit all the class modules for openerp development. In other words we can say that, In openerp osv.osv object is actually an orm.Model class and define a new object, ...

Inherit OpenERP Models

Inherit OpenERP Models: There are two ways of Inheritance in openerp:- 1-Object Inheritance - _inherit 2-view inheritance 1-Object Inheritance - Objects may be inherited in some custom or specific modules. It is better to inherit an object...

Basic OpenERP Object Attributes and Different Field Types

An object attributes is defined by declaring some fields with predefined names in the class. Two of them which are required (_name and _columns). The predefined fields are: _auto: Determines whether a corresponding PostgreSQL table must be ...

Function fields in OpenERP

Function fields in OpenERP: A functional field is a field whose value is calculated by a function and Fields that do not directly store into the DB but compute their value instead Parameters: fnct, arg=None, fnct_inv=None, fnc...

OpenERP module configuration file

How to Make an OpenERP module configuration file?: It is very simple to Create a module in OpenErp. All you need to know is the basic structure of any module to be used in the system. So if you want to make a simple module in openerp, here ...

HOW TO SET HR-Payroll IN OPENERP

Hi all, To configure the setup in OPENERP, i have provided the method/solution below, you just need to follow the steps one by one. SOLUTION Go to Settings-> Configuration-> Human Resources (this will Install your countrys payroll.) ...

Error, When Installing module on Server openerp 6.1

Hello all, When we install module in openerp version 6.1 we face the following error shown below and to resolve this issue I have provided the code below, mentioned in solution part. Error look like this on terminal <-----------------...

Increase the number of search results in OpenERP

Its sometimes very tedious and time consuming to search for a product or a partner or anything by typing and still not getting the desired result and then you have to wait for the Search More wizard. To compensate this, I have got a solution, ...

Break up database for a financial year in OpenERP

Create backup for the database first. Restore again in a new database, with whatever name or with new financial year succeeding the name. Now perform the following tasks: delete all the sales order from the sale_order table. ...

Making 'sales' module load quicker

A company which is using OpenERP for their sales operations may face the problem of loading sales module quite slow. It can be difficult to handle a situation where there can be many sales counters, the customer and salesman waiting for more than...

Print multiple copies of an OpenERP OpenOffice report

Sometimes we require to print more than one copies of any report for example an invoice which may have two or three copies, one for customer, one for salesman and one for Accounts department or a payment voucher to be printed twice. I got the...

Password Recovery in OpenERP

Can't log in? Forgot Password? Many users and many passwords? All these questions are very common in daily operations of your OpenERP. If you are admin then you have all the access to change or recover passwords for other users as well. Thi...

Backup and Restore Database Using OpenERP

The easiest solution to create backup and restoring you database in OpenERP is itself provided by OpenERP. To create backup and restore for your OpenERP database, you have two options: 1.) PostgreSQL 2.) OpenERP. The first one is simple and ...

ORM Methods in OpenERP

Every object in OpenERP is based on OSV i.e Object Service and this service implements full Object-Relational Mapping enabling developers not to worry for the simple SQL operations. In OpenERP, we have such ORM methods that are very useful. He...

Events in OpenERP 6.1

On Change (on_change) The on_change is the attribute that describes what will happen when a field value changes, what changes in other fields or an event will take place. Syntax <field name="field_name" on_change="function_name(field1...
1 5
Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: