Featured
-
How Regression Testing Detects Integral Errors In Business Processes
Humans are forever changing and evolving and so to
by kristina.rigina -
Get Display Banner Advertising Opportunity on FindNerd Platform
“Do you have a product or service that nee
by manoj.rawat -
Android O Released with Top 7 New Features for App Developers
Android was founded by Andy Rubin, Rich Miner, Nic
by sudhanshu.tripathi -
Top 5 Features That Make Laravel the Best PHP Framework for Development
Laravel is a free open source Web Framework of PHP
by abhishek.tiwari.458 -
Objective C or Swift - Which Technology to Learn for iOS Development?
Swift programming language is completely based on
by siddharth.sindhi
Tags
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...
