OpenERP 7 support multi company configuration in which there can be number of sub companies under a main company or another company itself. The modules installed in my OpenERP 7 are :
Sales
Purchase
Accounting
Warehouse
Communicating with OpenERP has been made easy in Drupal with the OpenERP Proxy API. This module provides API for other Drupal modules to interface with the OpenERP via the XML-RPC calls. We can use this API for authentication, searching, data retrieval, data updation to the OpenERP server. We have used the openerp-7.x-1.6 module to connect to OpenERP.
Nice work! It looks like a good way to build custom interfaces for openerp to add on extra functionality. Have you used the openerp-drupal integration in a real world case?
Thank you, Timothy. We have already implemented it for a few of our customers. If you want more details please share your email id or mail to contact@zbeanztech.com
Hi man,
Is there any manual? how can i create the forms on drupal? I was able to connect and use the workbench to select data on openerp, but, cannot use drupal to show it... can you give me the way?
Enterprise Resource Planning or ERP is software that integrates all functionalities of an organization in a single database. It streamlines all the business processes and gives desired result at the click of a button. The biggest advantage of ERP software is the integration of all the business solutions is integration of all business solution in a single platform, which reduces paper work, unnecessary documentation, repeated entry, cycle time, etc.
Hurrah, that's what I was seeking for, what a information! present here at this blog, thanks admin of this site.
Very good Blog Lepeesh. I would like to speak with you. Can you please send me your contact information. Thanks, Stacey
The data mapping focuses on the movement of data between systems.data mapping lead to greater consistency, which subsequently leads to greater productivity, reduce ongoing maintenance costs, improve readability of software and also making it easier for developers to understand new code more quickly. There are different methods to import your data into OpenERP.such as
Wizard enables the user to enter data and based on the data inputted, corresponding report can be generated. But in some cases there can be situations to generate Excel report with multiple sheet with different data in different sheets.
Hello Prajul, I'm trying to implement the solution you've given for subreports in jasper but I'm continuosly having this error: 'Failed to invoke method execute in class com.nantic.jasperreports.JasperServer: Error evaluating expression : \n\tSource text : ((net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("sub_report")' What might be happening?
Great blog entry, keep up the good work and contribution..
Great job......it really olot.Thax
Hello Mr Prajul, This is the
Hello Mr Prajul,
This is the best article I found out about this multicompany issue.
I would like to discuss the following situation:
Just to organize the products we sell, I have 3 companies:
one of the companies (company C) sells all products but the other 2 (A and B) only sells one type of product each one. All my employees work for all companies.
I've OpenERP installed with multicompany and defined a shop for each company.
Company A -> Shop A -> Sells products A
Company B -> Shop B -> Sells products B
Company C -> Shop C -> Sells products A, B and C
My situation is the following:
* When my salesman wants to create an order for company A, he just selects shop A and creates the order for that shop
* When he wants to create an order for company B, he just selects shop B and creates the order for that shop.
If he needs to order mixed products, than he "puts" the order for the shop C from the Company that sells all products.
Does this work?
The employees have access (Allowed Companies) to all companies. They have only one login. They belong to company C.
Each company has its accounting, stocks, warehouses and so one.
Does this work?
I thank for your help on this.
Regards
Antonio
Thank you for the article.
Thank you for the article. It is quite through and well presented.
My question is whether you have to have separate Users for each company, or whether a User in the Root company can create Quotations, orders etc, for a Sub Company?
It seems like most of the code is set up this way but I am not seeing a way to create an order (in my Admin or SubAdmin role) for any company but the one I am assigned to.
I will see if I can "disconnect" from a main company but it seems I have not found that yet.
Thanks again.
Hi there. I'm trying to
Hi there. I'm trying to setup a new chart of accounts for my second company but I do not get the invoicing Settings menu. I also do not get the Company Structure menu. I am the administrator so I can't see it being a security issue.
My settings menus are as follows:
Sales
Purchases
Warehouse
Manufacturing
Project
Accounting
Human Resources
Knowledge
General Settings
Companies
Companies
I also have enabled "Manage multiple companies" within the General Settings.
Mike
Hi, If you are going to
Hi,
If you are going to configure chart of account for your new company, go to "Settings -> Configuration -> Invoicing". Here in Chart Of Account section you could see a dropdown field "Select Company" in which you could select the company. Select your newly created company from this dropdown field. If no chart of account is configured for this company, A new field will be visible as "Template" where you can select the installed chart of account in OpenERP. If you want to install a new chart of account, just click "Install more chart templates" where you could select the template you want.
My experience is that the
My experience is that the "Invoicing" module name changes to Accounting once the primary Chart of accounts is installed, so attaching a Chart to a Sub Company will likely be done under "Accounting" config rather than Invoicing after that.
When I'm trying to add a user
When I'm trying to add a user to sub company I get this error
"Error occurred while validating the field(s) company_id,company_ids: The chosen company is not in the allowed companies for this user"
Any idea?
Hi, In users form view
Hi,
In users form view you could find a field named "Allowed Companies". Add the company you are trying to assign to the user to this field. User can be assigned to the companies assigned to him in this field.
Hi Prajul, I would like to
Hi Prajul,
I would like to know about following: please help me.
If the user is accountant in finance and accounting, that user want to know and see about payroll in openERP 7. So, how can i do that?
best regards,
anonymous
Hi, If the user is
Hi,
If the user is assigned as Officer in Human Resource group, he could see the details of the employee payslip. If you want to see and configure payroll, the user should be assigned as Manager for the group Human Resources.
But my boss want to be "
But my boss want to be " Account can access payroll but not give manager permission for human resources and then account must be employee in hr." but i can't do that.
Thanks regards,
kothudevil