Featured
-
Function calling on button click in OpenERP
Adding a button on an OpenERP view is very easy an
by dinesh.singh
Tags
How to Recursively load the template objects and create the real objects in openerp
To Recursively load the template objects and create the real objects in openerp show detail given below.
1-param company: company the wizard is running for
2-param code_digits: number of digits the accounts code should have in the COA
3-par...
How to upload database dump in Odoo ?
The upload method https://upgrade.odoo.com/database/v1/upload/ use this link to Upload a database dump
Parameters
key (str) -- (required) your private key
request (str) -- (required) your request id
Returns
request result
Return type
jso...
How to create a database using upgrade request in openerp
To upgrade list of each database given information about one particular error. Each dictionary can contain various keys depending on the type of error but you will always get the reason and the message keys as below:
reason: the error type
mess...
How to Sending a signal from a subflow in Odoo/OpenERP
When a workflow is embedded in an activity (as a subflow) of a workflow, the sublow can send a signal from its own activities to the parent workflow by giving a signal name in the attribute signal_send. Odoo processes those activities by sending ...
How to Add the Python function in odoo-9
Here is just one thing to do: create the Python function which is called by the automated action.
The Python function process_demo_check_queue will automatically create and update the value called by automated action.
So let us create this in t...
How to creating the views in odoo-9
If you have the database part ready it is time to create your view.
Example:- I have created a simple form view and tree view which shows the fields name, numberOfUpdates and lastModified as created in our model:
<record id="view_check_re...
How to Creating the new model and fields in odoo-9
First create a model (if you dont have one yet) then create some fields on this model:
class check_demo(models.Model):
_name = 'check.demo'
name = fields.Char(required=True)
...
How to Override to confirm the sale order, if defined and if the transaction is done in openerp
If define Payment Transaction in sale order in sale module then first override the function and inherit to the view from sale and add fields acquirer_name in sale order model and set default draft method and use this function in your own module....
How to provided external identifier in test module in OpenERP/Odoo ?
In Odoo-9 by default, tests are run once right after the corresponding module has been installed. Test cases can also be configured to run after all modules have been installed, and not run right after the module installation.For example code is ...
Consume product with specific quantity from specific source location in openerp
The quantity from specific source location with Consumed product and param product_qty means that Consumed product quantity and param location_id is Source location and returns Consumed lines in this function. Use the below function in .py file
...
How to Override of the base.stage method in project module in openerp
To Override the base.stage method in project module and Parameter of the stage search taken from the lead and also section_id if set, stages must belong to this section or be a default stage; if not set, stages must be default stages in project m...
How to retrieve all children projects of project ids in openerp
TO retrieve all children projects of project ids in project module and return a dictionary mapping each project to appiar its parent.id in parent project in project module (or None)in openerp. use this code given below in .py file in openerp.
...
How to set Default option methods in openerp
Options apply standard CSS classes to the snippet. Depending on the method that you choose, the UI will behave differently.
data-select_class=" class name "
More data-select_class in the same group defines a list of classes that the user ...
get_encodings, ustr and exception_to_unicode were originally from tools.misc in openerp
Set encoding to default and find value to get_encodings, ustr and exception_to_unicode were originally from tools.misc in openerp and use this method in openerp. Use this code in .py file in openerp
ef get_encodings(hint_encoding='utf-8'):
...
How to called except block to allow converting exceptions to arbitrary
To Called within an except block to allow converting exceptions to arbitrary responses. Anything returned (except None) will be used as response. use this code given below in openerp.
def _handle_exception(self, exception):
"""Called ...
How to implement translations system in OpenERP/Odoo ?
The procedure to translate text in Python and JavaScript code is very similar. You could have noticed these lines at the beginning of the petstore.js file.
var _t = instance.web_t,
_lt = instance.web_lt;
These lines are simply used to ...
How to set inspection and introspection in OpenERP/Odoo ?
Odoo stores most model metadata inside a few meta-models which allow both querying the system and altering models and fields on the fly over XML-RPC.
For example code like below.
models.execute _kw(db, uid, password, 'ir.model', 'create', [{
...
How to create more Action in OpenERP(Odoo)
Actions are used to trigger one or more actions to be performed on the server side, when a specific stage of a workflow is reached. To write this code in .xml file in openerp(odoo), use the Code given below.
<record id="company_normal_actio...
How to Create a transit location with company_id in odoo-9
To Create a transit location with company_id being the given company_id. This is needed in case of resupply routes between warehouses belonging to the same company, because we don't want to create accounting entries at that time. For this use thi...
How to create Account Analytic Line class to compute the line in odoo-9
To create Account Analytic Line to compute the line and inherit the class account_analytic_line in odoo-9 then write this function in .py file in your module in odoo.
Use this code show in given below
def _compute_accountanalytic(self, d...
How to Create procurements based on quantity ordered in openerp-9
To Create procurements based on quantity ordered in openerp-9 If the quantity is increased and
new procurements are created then use this code given below in .py file
def _action_procurement_create(self):
precision = self.env['deci...
How to Compute the quantity invoiced If case of a refund in openerp(odoo)-9
To Compute the quantity invoiced If case of a refund in openerp to Compute the quantity invoiced. If case of a refund, the quantity invoiced is decreased. Note that this is the case only if the refund is generated from and function given below t...
How to check product quantity in openerp
To check product quantity in openerp
You have to write this function in .py file to check product quantity in product module and relate his to
the inventory management. See code given below
def check_product_quantity(self, cr, uid, product,...
How to remove 'provision' from selection list when configuring Cash Flow in Odoo
In below example, I have written Python script to remove 'provision' from selection list when configuring Cash Flow Codes. Paste below python code in .py file :
def fields_get(self, cr, uid, fields=None, context=None):
res = super(accoun...
How to modify the PetToysList component in OpenERP/Odoo ?
How to modify the PetToysList component so clicking on a toy replaces the homepage by the toy's form view in OpenERP/Odoo ?
If you want to modify the PetToysList component in OpenERP(Odoo) so that when you click on a toy it replaces the homepa...
How to make workflow transitions in OpenERP/Odoo ?
To make workflow transitions in OpenERP/Odoo ?
If you want to make workflow transitions in OpenERP(Odoo) follow the below mentioned code and paste it in your workflow_xml file:
<record id="trans_idea_draft_confirmed" model="workflow.trans...
Use amount booked in the company currency for conversion into voucher currency in Odoo
To Use amount booked in the company currency in openerp Follow these step to given below
Step-1 Install the account_voucher module.
Step-2 After that custmozie account_voucher module.
In below example, I have custmozied account_voucher modu...
Odoo Tree View
If you want to make tree view in OpenERP(Odoo) follow the below mentioned code and paste it in your .xml file: -
<tree string="Idea list">
<field name="name">
<field name="inventor_id">
</field></field>...
Could not execute command 'lessc' in odoo-9
If "Could not execute command 'lessc'" Error ocour while installing odoo-9 and the login page will not show clearly.
Then use this six command in terminal and run it one by one
1- sudo apt-get install nodejs
2- sudo apt-get install npm
3-...
Odoo/OpenERP : Advance Point of sale Software
Hello Guys,
With advent of POS (point of sale) software, it has become quite easy & trouble-free for the hospitality business owners, especially hotel & restaurant owners to run their business in quite better & healthy way. A poin...
How to Debug in odoo 8
Use below code line in .py file if you want to debug file in odoo
import ipdb; ipdb.set_trace();
And then restart server use this command in terminal and then restart your openerp- server with the debug option.
# openerp-server debug
How to Use XML-RPC of Odoo 8
XML-RPC is very useful in openerp. The XML-RPC protocol communicate to server and clients. XML-RPC is a very simple protocol which allows the client to do remote procedure calls. The called function, its arguments, and the result of the call are...
How to calculate two fields and show total in third fields in openerp
To create two float fields in openerp you have to make third fields function and also this is a auto calculate in openerp.
Like:- field3 = field1 + field2
EXAMLE -
'field3' : fields.function(get_total, method=True, string='FIELD3',type='i...
How to Create write function in openerp
To create writer function in openerp you have to override the create and write methods, as show in example below.
Example:- use this code to write and override function in openerp
def write(self, cr, uid, ids, values, context = None):
re...
How to check partner balance in openerp
To check partner balance in openerp follow these step given below
Step1-First Install Account module, to install Account module in openerp
Step2- Go to Account -> Reporting -> Generic Report -> Partners -> Partners Balance and save...
unique records creation with account_number and company_id in avalara-salestax
To use constraints on unique records creation with account_number and company_id in avalara-salestax in OpenERP/Odoo follow below steps-
Step-1 Go to avalara_salestax module.
Step-2 avalara_salestax->avalara_salestax.py.
Step-3 After that...
How to search name field in OpenERP
To install account module and searching by name in account module in customers invoice form and get results in particular name use this code in account_invoice file in account module in openerp.
Code given below:-
def name_search(self, cr,...
How to Create Basic Search View In Odooo
In Odoo Search View is easy to use that is provided on every list view. With a module, you can add additional filter options that make it easier for users to find the information they are looking for and user can select the filter in Odoo.
To ...
How to Create Basic Form View In Odoo
You can create form view in odoo by using below code in .xml file
There are two ways to create a Form View in Odoo.
1. Existing Form
2. Simple Form View.
1- Existing form Here you have to inherit form view and change this form view in...
How to Add Action and Menus in Odoo
To add action and menu in Odoo
Action- There are different types of actions in Odoo:
1- Window: Opening of a new window
2- Report: The printing of a report
3- Custom Report: The personalized reports or RML Report: The XSL:RML reports
...
How to resolve Severe Assertion Error in openerp
To resolve Severe Assertion Error in openerp follow these step given below
After getting sever assertion error then first :
Step1- In pgAdmin run the following query:
update ir_module_module set state = 'installed' where state = 'to install'...
How to solve error on re-installation of OpenERP or pgAdmin
If you face error on re-installation of OpenERP or pgAdmin, then you need to add the port 5432 for Postgres in Inbound and Outbound Rules.
Follow these step given below:-
Step1- Go to Control panel/System and Security/Windows Firewall and se...
How to Data Mapping using ETL Tools in OpenERP/Odoo ?
The data mapping fixates on the powerful data between systems, It leads to more significant consistency, which results into preponderating productivity, reducing perpetual maintenance costs, amending readability of software and additionally makin...
How to send mail from Any Button in OpenERP/Odoo ?
OpenERP enables utilizer to send and receive emails when an action is done from OpenERP. We can configure emails to be send when a sale is verify or invoice is paid etc. But to implements these type of functionality, we require to update the func...
How to make the sale Order Double Validation in OpenERP/Odoo ?
Sales module OpenERP is utilized to manage Sales from OpenERP. In OpenEPR v7, when a sale is engendered, Utilizer have the option to attest the sale to engendered invoice and/or distribution order predicated on the configuration take in the sal...
How to create Procurement Exceptions in openerp
Procurement Exceptions means A Procurement Exception occurs when the system cannot find a way to fulfill a procurement. Some exceptions will resolve themselves automatically, but others require manual intervention.
To Create Procurement Excep...
Benefits of Using E-Commerce OpenERP/Odoo software
1-An Enterprise Resource Planning Software-As we don't need to describe the benefits of implementing an ERP solution for organization, with OpenERP/Odoo solution, you get a consummate ERP solution where you can manage Warehouse Management, Sales,...
7 Important steps before implementing an ERP system
1- Working on the direct work of your business processes, roles, hierarchy, departments is consequential. Develop a inspired flow ahead of you, initiate your ERP implementation as it extract your timeline and finance.
2- Understanding each emp...
OpenERP V7 and V8(odoo) installation on Ubuntu
Hello guys,
As we know OpenERP(v7) / ODOO(v8) is an open source suit of ERP business applications.
There are several ways to install OpenERP(v7) and odoo(v8).
We will guide you how you can easily install OpenERP(v7) from Launchpad and v8...
How to send email in OpenERP by python code ?
We can manage email sending by .py (python) code.
To send an email in OpenERP using python code you can use the below code.
import base64
import logging
from openerp import netsvc
from openerp.osv import osv, fields
from openerp.osv im...
