Tag: Erp

How to Create an Excel Report File in Odoo

To create reports in PDF or HTML file odoo has provided its own model, namely ir.actions.report. With this model, we can create PDF and HTML reports quite easily, without having to think about how to retrieve data from the database or how to download the reports. Unfortunately, to create reports in an excel file, we ….  Read More

How to Call Odoo API with PHP

Odoo has provided an API that can be accessed from outside of the odoo application for all model by default. So if we want to link our odoo application with other application we don’t need to create our own API. Just call the API that has been provided by odoo. In this tutorial, I will ….  Read More

How to Write Odoo Domain in Easy Way

In odoo, domain is a list that contains certain expressions that are used to filter some data from the database. Domain will be translated by odoo into an SQL expression to fill the where clause. For example, if we have a domain like this. The domain above if applied to the sale.order model will produce ….  Read More

How to Override an Odoo Widget

Odoo has many widgets that ready to use, such as many2many_tags, image, html, handle etc. How to use those widgets are relatively easy. But of all the widgets that Odoo has, I think the many2many_tags widget is kinda weird. Why ? Because it can’t be clicked. I mean if I click on that widget, I ….  Read More

How to Configure the Menu Item in Odoo

Menu item is an odoo’s view in the form of buttons, icons, links, dropdowns etc. Which if we click it we will be redirected to another page or form. This is an example of a menu item on the odoo home page. Where is the Menu Item Stored ? Menu items are stored in the ….  Read More

How to Solve the “ProgrammingError: column does not exist” Error in Odoo

As an odoo programmer, in the middle of a module or addon development, have you ever experienced something unpleasant, like after you refreshed the browser, suddenly an Internal Server Error message appears as below ? After we check in the terminal or log file, it turns out that there is a ProgrammingError: column res_partner.max_order_item does ….  Read More

What is External ID in Odoo ?

When you work with odoo, have you ever had any questions about what is an External ID ? Like when you are going to export some data, for example the customer as shown below ? Or when you edit a form. What exactly is an External ID ? And what does it do ? Basically ….  Read More

How to Give a Customer Portal Access in Odoo

Odoo has a customer portal module, with this module, our customers can log in to our odoo website and view their transactions. In the customer portal, customers can view their unprocessed sale orders, completed delivery orders, unpaid invoices and other information. Customers can also download their transaction documents such as invoices, and communicate with us ….  Read More

How to Use a Transient Model in Odoo

Transient model is a model in odoo where its data will be deleted periodically. Since the data will always be deleted, of course it is not recommended to use this model to store the real data. Usually, this model is used as a wizard or as a connector between several models, for example to show ….  Read More