Featured
-
Function calling on button click in OpenERP
Adding a button on an OpenERP view is very easy an
by dinesh.singh
Tags
JSON.parse:unexpected end of data at line 1 or 2
JSON.parse:unexpected end of data at line 1 or 2 this type error occur when you take printout from openerp setup.
So to resolve such error follow these below step
1- install all report module like- account_financial_report_webkit,webkit re...
Form view and element events- (onchange events)
Views in OpenErp:- Two type of views in openerp
1- From Views
2- Tree Views
1- From Views:- In OpenErp Form Views follow many point like as
By default, each field is preceded by a label, with its name.
Fields are placed in screen right t...
Basic openerp module directory structure and _init_.py
Basic openerp module directory structure:-
In OpenErp all module of openerp server are located in the server/addons directory, to create all new module in openerp follow this step:-
first step is create a subdirectory in the server/addons...
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 ...
Special fields in OpenERP
Openerp contain different types of fields and these Fields are divided into three different categories, they are simple fields, relation fields and functional fields.
So lets discuss this one by one-
1. Simple Fields- The simple types are integ...
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
<-----------------...
Constraint Error While Creating Customer Invoice
When we are creating a new Customer invoice, than on validating(Clik on validate button) the invoice, we got a " 'Constraint Error': Invoice Number Should be unique "
To resolve this error Simply go to settings >> Configurations >&...
Calculate Pay Slip automatically
If we enter employee name in the Pay slip sheet All the information regarding the attendance, leaves and basic sal-expenses should be displayed .
First, You need to install hr_payroll module for this.
This is the flow you need to follow: ...
How to create scheduler in OpenERP
A Scheduler helps to identify the necessary task, assigns a logical sequence to these tasks and monitor their execution. The main purpose of Scheduler is to identify tasks are on time.(Note: Tag is only used for the next Line).
There are two way...
Installation OpenERP 6.1 on Ubuntu
Step 1. Build your server
you can install the openssh-server during the install procedure or install subsequently depending on your preference.
<pre>sudo apt-get install openssh-server denyhosts</pre>
Now make sure you are ...
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...
Creating Search View in Openerp
Search views are very useful when it comes to exact data requirement. In OpenERP we can create such views very easily and quickly, just adding the few line of code in your view. You can add as many fields you wish and add buttons that do some sor...
Create Incoming and Outgoing Server in OpenERP
Create Incoming Mail Server
Go to Setting->Configuration->Email->Incoming Mail Servers, and create
Give a Name, example: Incoming Gmail Server
Select Server Type as POP/IMAP
In Server Name field, give the hostname or the IP of t...
How to create email template in OpenERP
By creating an email template one can send emails very easily and quickly as you already design it, add reports, signature. You can use these templates for any document in the OpenERP to enhance your sales, marketing, and accounting tasks. With t...
How cooler is OpenERP 7.0 than 6.1?
With every new version of OpenERP there are always surprising changes visually or functionally. Lets discuss the very cool new features of OpenERP 7.0 and compare with those of 6.1.
Clean Views:
OpenERP has made the version 7.0 views very ...
Important modules for any company in OpenERP
For any enterprise that needs to implement an ERP system, the basic modules that are essential would include all the major functions of the enterprise that describe it completely.
OpenERP is one such system that does it all and has all the mo...
How to convert your report to rml in OpenERP
Converting any .sxw report file that we create using Open Office is very easy and useful for future usages, as it helps creating reports for our module.
Follow the simple steps:
Create your report and send to server, created dailycash.sx...
Using if else in OpenOffice Report
Printing any field on an OpenERP report on a conditional basis, you can add a simple line in your report
[[(object.field == 'Some Value') and 'value1' or 'value2']] is equivalent to
if object.field:
print value1
else:
print value2...
Create many2one and one2many relationship in OpenERP
In OpenERP we can create many2one and one2many relationships between models very easily by creating many2one and one2many fields. You just need to declare a field in _columns and then using this field normally in the rest programming and views a...
Creating a functional field in OpenERP
Functional field is a field which gets its value on the basis of a function, for example an amount can be calculated using the various others values of the invoice like taxes, discounts, labor charges, extra charges etc, you will need a function ...
Function calling on button click in OpenERP
Adding a button on an OpenERP view is very easy and calling a function on it too. For example I created a function to add cartage amount on the sales order, I created a field to add cartage amount on it and then on button click it will be added t...
Create sequences in OpenERP
For any module or a part of the module we may have to have a field which is sequential and auto generated. For this we can create a sequence through the OpenERP UI and include in our model pragmatically through python code.
First create a s...
Launch a report through a wizard in OpenERP 6.1
Printing a report from a button a wizard is quite easy and very fast in execution. Its really awesome when you created a report on your own format using OpenOffice or any other report designing tool for OpenERP, and you can call that report on a ...
Adding a field to an existing module using Inheritance in OpenERP 6.1
To add a new field to an existing module, the best practice is to create a new module that inherits the model you want this field to add in. And your module will depend on the required module.
For example adding field cartage to account.invoic...
Summing a column in an OpenERP report
Its is very obvious that you would need reports in accounting where you are supposed to analyse the sales, refunds, and many more accounting documents, this means you would require maths functions too while creating OpenOffice reports for OpenERP...
How different is creating a simple module in Openerp 7.0?
Creating a module in OpenErp 7.0 is quite different from how it has been in 6.1. Already discussed earlier to create a module in version 6.1, its time to throw some light on a basic module created in OpenErp 7.0.
To start with the basic struct...
Import data from another database using CSV in OpenErp
The easiest and possibly the best idea of importing data from another database to a new database is the CSV export. OpenErp gives you this feature in the versions 6.1 and 7.0.
Following is the example on how you can export customers to a csv ...
Prevent duplicate partner entries in OpenErp
It is an obvious situation for any company to prevent the creation of duplicate partners with same name, and same case. To stop this we can do the following steps:
First merge all the duplicate entries on one partner.
Delete the other partn...
How to create reports using Base Report Designer and OpenOffice in OpenErp
Creating reports in OpenErp using OpenOffice is the easiest way. Just need to follow simple steps:
Download base_report_designer module from the web or https://www.openerp.com/apps.
Add to the addons and install the module.
Open OpenOffice...
How to create Wizards using osv.memory in OpenErp 6.1
To create a wizard for a module, we need to create a wizard folder; this folder will be imported in our main __init__.py of the module. The wizard folder will contain another __init__.py which will import all the wizard class files.
The Wizar...
