Featured
-
Function calling on button click in OpenERP
Adding a button on an OpenERP view is very easy an
by dinesh.singh
Tags
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...
Managing the two versions of OpenERP on the same machine
Sometimes you require to run two versions of any software on a same machine. To run OpenERP with two different versions, you can have issues even if you try to use different browsers or windows at the same time.
To run OpenERP 6.1 and 7.0 vers...
Get a many2one field in a list with domain
To get a many2one field of another model in your model as a drop-down list, you have to define a column or a field and a write a function for it.
Suppose, you want to get a list of invoices in a drop down list based on the customer selected o...
Property field in OpenERP
Each time you work in OpenERP, you find a new concept, recently I came across a concept Property Field in OpenERP and tried hard to understand it. Here is a small introduction to a property field.
Property Field: A property field is a special ...
Relational Types in OpenERP
Relational types in OpenERP are:
many2one
one2many
many2many
related
many2one: associates an object to its parent object. Example Customer and Invoices. Many invoices belong to one customer.
Syntax:
fields.many2one(
...
Get rid of the difference in base and subtotal amounts in an invoice
It has been noticed that if we create an invoice in OpenERP, we see a difference between the subtotal of a line and the base amount for taxes, and this amount can vary hugely as the quantity of the product/item increases. For this, I have been se...
Cool widgets in OpenERP
Widgets are the GUI elements that can perform some controlling tasks. In OpenERP, we can see a few of widgets that have significance in the views like statuses of the any process, seeing states of an object, or getting lists out of huge data, or ...
Very Useful Tags in OpenOffice Reports
Here are some important very useful tags that can help you definitely while creating various kinds of reports:
[[ repeatIn(objects,'o') ]]: To add loop on the object selected, example [[ repeatIn(objects,'invoice') ]].
[[ repeatIn(o.invoic...
