- Zesty Beanz
- Open ERP
- Case Studies
- Contact Us
In this blog we will go through simple steps in connecting microsoft office applications with postgresql using ODBC, which will be helpful for those who would like to use Excel as a front-end for data analysis.
Print screen was a feature of OpenERP which enables the user to take the printout of the tree view of the selected records. This feature was available in OpenERP 6.1 GTK client was not available in OpenERP 6.1 web client and OpenERP 7. In OpenERP 7, there is an option to take printout of the tree view. But in OpenERP 7 we cannot select the particular records which we want to print in the report.
OpenERP 7.0, The full featured ERP making the switch from an ERP to a suite of integrated business applications. So far, the world was split between ERPs and best of breed applications. With 7.0, OpenERP combines the key benefits of stand-alone apps (ease of use, quick to deploy, highly customizable, ...) with the integrations and feature coverage only ERPs used to provide to their customers.
This in an interesting module in OpenERP which I found useful recently for importing different csv file templates to a single object(model) in OpenERP. For example when we create a crone job (scheduler) to import csv files from different suppliers with their invoices which has different structure to the Customer Invoices in OpenERP. Below is a generic explanation of the existing module.
iReport is an reporting tool used for designing jasper report in OpenERP. In OpenERP it is difficult to create a report that has a dynamic column. For instance consider an example of a project report that has details regarding the project task completion date. The task name will be the name of the column. In such cases, the cross tab in report comes handy.
Jasper report is an reporting tool used in OpenERP for printing the reports in formats like pdf, Excel, HTML etc. Lets consider an example about the accounting reports. The report contain details regarding the credit amount, debit amount balance etc. It would be very useful if the report is printed in excel format. In excel sheet we will be able to specify the formula based on which each cell value is calculated. So if we are generating the excel sheet from jasper report we should be able to specify the formule in jasper report which should be used in the excel sheet.
I met my success in porting the Drupal 6 module, OpenERP Proxy API to Drupal 7 (D7). Now it is working with OpenERP 5 and OpenERP 6. I faced many complications to make the data communication between Drupal and OpenERP. Even though we can have specific methods to tranfer projects, leads anything like these from OpenERP or from Drupal and make both to communicate each other, I wished if I had a specific API module in Drupal 6 my task will be easier. Later, I found this module will do the nice. Thanks to BoogieBug who developped the Drupal6 version
Hi all recently I was assigned the task of restricting multiple logins of a single user in OpenERP. Since I'm a newbie to OpenERP, I searched the web for some kick-start articles but for vain. That is why I'm summarizing my points in this, my first ever, blog.
In today's aggressive business environment it is essential to be prepared to face a vast and competitive world. Like any other industry manufacturing companies also are facing so much competition. To withstand the competition, organization must have a proper system and software that supports whole system with integrity. Enterprise Resource Planning is one of the ways to improve and streamline the system.
The Openoffice Report Designer is a plugin used to create reports for OpenERP. It is an easy to install and use plugin. The main advantage of this plugin is that anyone can easily create and modify reports for OpenERP.
Install using Extension Manager in Openoffice.org Writer