Search In
In OpenERP, create a custom module like: demo and then create file like: demo.py file in your demo module and demo.py file pass in your other file __init__.py file. And then create other file demo.xml file and pass this file in your other file like a
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'),
}
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 as dp
fr
Sometimes we need to make existing column as first column. For example you created a table and added column "id" after creating the column. Now you want to make "id" column as first column, then you can do this easily by using ALTER command as below:
If you want to make loops and special fields in OpenERP use below code -
def get_totals(self, cr, uid, ids):
countries = {}
for sale in self.browse(cr, uid, ids):
country = sale.partner_invoice_id.country
countries.setdefault(country, 0.0)
countr
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, field2,.
The code below helps to get a particular radio button checked on selecting a particular value from the dropdownlist.
<form>
<div>
<select id="selectvalue" onchange="Checkbox();">
<option value="1">Sele
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,
'cr
In OpenERP first we create users and configure users access rights, then user will create a new filter, use filter group and also add a new ir.rule entry for model_id and domain on the target group_id. If restrict is True then instead of adding a rul
In many cases we need to create foreign key in a table. We can do this at the time of table creation and after the table creation by ALTER command.
1- At the time of table creation:
CREATE TABLE user_device (
id int(11) NOT NULL AUTO_INCREMEN
