Featured
-
Function calling on button click in OpenERP
Adding a button on an OpenERP view is very easy an
by dinesh.singh
Tags
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 the loan/invest demand fields in OpenERP(Odoo)?
In below example, I have written Python script to loan/invest demand fields. Use below python code in your .py file :
'date_start': fields.date('Start Date', states={'confirm': [('readonly', True)]}),
'date_stop': fields.date('Matu...
How to remove 'provision' from selection list when configuring Cash Flow Codes in OpenERP(Odoo)?
In below example, I have written Python script to remove 'provision' from selection list when configuring Cash Flow Codes. Use below python code in your .py file :
def fields_get(self, cr, uid, fields=None, context=None):
res = super(accou...
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 run two server in same machine at a same time in openerp-7 (Odoo)
If you want to run two server on a same machine at a same time in openerp-7 (Odoo)
follow these two simple step
1-Do this in your Terminal to run first server
`/workspace/openerp/openerp-6.1-1$` ---> (this is server location )
Now run th...
How to define the States of object in openerp-7 & Openerp-8(Odoo)?
Below is the way to define the States of object in openerp-7 & Openerp-8(Odoo)
First we have to define the States After that, We have to add a state field to object, in the
_columns collection
See below code Example-
<pre>
_co...
How to generate bar code image and bar code value in OpenERP(Odoo)?
To generate bar code image and bar code value in OpenERP(Odoo), you have to follow 3 simple steps as given below.
Step-1 Click Bar-code Menu
As shown in below screen-shot
Step-2 Click on Barcode->Barcode ->Model ->Res Id -...
How to manage counterpart in Point of sale in OpenERP(Odoo)?
Below is a code of Python script for counterpart. Below python code is written in .py file :
insert_data('counter_part', {
'name': _("Trade Receivables"), #order.name,
'account_id': order_account,
...
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 configure the Barcode through Python code in OpenERP(Odoo)?
In below example I have written Python script to configure barcode. It will print one barcode on each page based on quantity available of selected products. Like below python code in .py file :
import logging
from openerp.osv import field...
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 Unit of Measure (UOM) in OpenERP (Odoo)
To make Unit of Measure (UOM) in OpenERP (Odoo) is not a difficult, you can do this in just two steps which are provided below, follow both the steps and it's done.
Step-1 Go to sales modules->Configuration ->Unit of Measure->Create
...
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 set the outgoing email servers in OpenERP (Odoo)?
To set the outgoing email servers in OpenERP (Odoo) follow the below steps?
Step-1 Go to settings -> General Settings
Step-2 Click on configure outgoing email servers->Create
Step-4 Description ->Priority ->SMTP Server ->SMT...
How to Restore database in PostgreSQL in ubuntu
To restore database in PostgreSQL in ubuntu follow these step in terminal
1- sudo su - postgres
2- psql
3- psql -d abc1 < /home/sachin/pqr.sql
abc1 = is dbname from where I am restoring backup
pqr = backup file which will res...
How to take backup database in PostgreSQL in ubuntu
To take backup database in PostgreSQL in ubuntu follow these step in terminal
1- sudo su - postgres
2- psql
3- pg_dump abctest_db > /home/sachin/abc.sql
Here,
abctest_db = is a dbname whose backup I want to take
abc.sql fil...
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 Add Extra Fields in account module in openerp
To Add Extra Fields in account module in openerp use below code
In OpenERP Add Extra fields in account module to create new module name is invoice_cartage
and add these 4 file.
1- __init__.py file ---
import invoice_crtage
2- __op...
Unable to upgrade module in OpenERP
If module is not upgrade in OpenERP, later on error will came while you upgrading any module.
Or in other words we can say that, while upgrading module in OpenERP we faces error and every-time false to upgrade module, so to solve this issue foll...
Create Invoice Autometic in openerp-7
If you want to create invoice automatically then follow these step
1- Install subscription module in OpenERP
2 - Than go to menu Tools -> Configuration -> Document Types
3 - Than go to menu Tools -> Recurring Events ->...
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 add OpenERP Report Designer In menu for Creating Report in openoffice
This tutorial will guide you to add OpenERP Report Designer in menu for Creating Report in openoffice.
Follow these step to add menu in openERP
1 - install base_report_designer module in database
2 - Download openoffice and open
3 - conf...
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 create selection field in openerp
To make selection field in OpenERP (Odoo)
In Selection Field first we have to go in .py file (python file)
After that we have to decide where you want to give selection Field and then give attribute Selection to that field.
Like below ...
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 validate address of customer in Ava Tax in openerp-7 (Odoo) " ?
It is answer to the questions like
a- how to verify address of partner in openerp
b- how to correct address entered by user
We need to verify and valid address in several cases like for - shipping ad...
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 create an osv_memory wizard systems in openerp-7 and openerp-8(Odoo)
To create an osv_memory wizard systems in openerp-7 and openerp-8(Odoo), follow the below steps.
In the action that opens the object, you can put </br>
<field name="target"/>
It means the object will open in a new...
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...