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
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...
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...
Avoiding gap in ids for a table in OpenERP PostgreSQL
Sometimes when we delete few or all records from a table, we may want ids of records to be in sync with the last record or the first one, but what we get is that new ids with a significant amount of gap have been generated, for example if it shou...
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...
