OpenERP Indian Accounting

Improvements in Indian Accounting localization (l10n_in Module)

We have improved a module that helps you to create Chart of Accounts as per your company type.

So now after installing the Chart of Accounts for Indian Accounting using Configure your chart of Accounts wizard, It will install two different Accounting templates.

1. Indian Chart of Accounts for public Ltd.
2. Indian Chart of Accounts for Private Ltd/ Partnership.

So now it is possible to install Chart of Accounts as per your company type using above Account templates.

So if your company is publicly held you can select Indian Chart of Accounts for public Ltd. which will install Chart of Accounts as per your business suite. And same case for Private Ltd/ Partnership Company. 

Regards,

Mustufa Rangwala

OpenERP Consultant 

Read more »

How to Generate a SSL certificate for OpenERP

To connect via xml-rpc secure protocol (8071) we need to generate a certificate and a private key file for the OpenERP . Below are the steps which can guide you to achieve this.

Step 1: Create a Directory eg: "SSL" under openerp-server/bin

Step 2: Go to "SSL" directory. cd ssl

Step 3: Generate Private key(pkey) as
execute command :openssl genrsa - des3 -out server.pkey 2048
enter the details that is asked for.

Step 4: Certificate
execute command openssl req-new-key server.pkey -out server.csr
enter details that is asked for.

Step 5: copy the .pkey file:
cp server.pkey server.pkey.org
enter password

Step 6: openssl rsa -in server.pkey.org -out server.pkey

Step 7: Generate CA private key
openssl genrsa - des3 -out ca.pkey 2048
enter password (enter different password then before)

Step 8: Generate a certificate in x509 format
execute: openssl req-new -x509 -days 365 -key ca.pkey -out ca.crt
Enter details that is asked for.

Step 9: sign the pkey
openssl x509 -req -in server.csr -out server.crt -CA ca.crt -CAkey ca.pkey
-CAcreateserial -CAserial ca.srl
Enter password same as entered in step 7

Step 10: start openerp server with --cert-file=YOUR .crt FILE PATH --pkey-
file=YOUR pkey FILE PATH

eg: server$ ./openerp-server --addons-path=../openobject-addons/ --cert-
file=bin/ssl/server.crt --pkey-file=bin/ssl/server.pkey


Thanks,
nch(OpenERP)

Read more »

Dynamic Widget Adaption In Custom Filter

Hello,
We are proud to announce that there is a totally new custom Filters available now in GTK client Trunk Version. It just adopts to the widgets based on the fields type, i.e the field you selected for search. The criteria will also change according to the field type. say for eg: if its a date or a datetime field then two extra criteria will be added in the condition box
1:between
2:exclude range
similarly for other types.Try the new feature and give your feedback.


Thanks
nch(OpenERP)

Read more »

Integration of Quick Books Pro 2011 with OpenERP V6.0

Quick Books Integration Process
==========================

• I have created a module named "quickbooks_ippids" .
• This module will import the customers and vendors data in to openerp.
• Following are the steps to import the data.

Step 1 :
======

• First of all , install this module in to the system.
• Click on the Start Configuration when installed the module and set the token and realm id for the company.
• For test purpose you can use :
•        Token = 'd573nmwdnmfki9dwhs49rchv8csa'
•         Realm ID = '199646053'

Step 2 :
======

• Now click on Administrations->QuickBooks->Import Datas (Wizard)
• Enter the workplace login and password and also select the option for import the datas.
• For test purpose you can use :
•         login = apa@tinyerp.com
•         password = 9879123679
• Select the options those you want to import the data from quickbooks.
• Now click on import button.

About fields map :
===============

• I have created this module and it will automatically installed when you install quickbooks_ippids module.
• Here,you have to define a dictionary which maps quickbook's fields with openerp fields.
• you have to written this dictionary in map_fields.py file
• For example,

            {'res.partner':
                 {'name':'Name',
                     'active':'Active',
                     'qb_ref':'Id',
                     'address':
                         {'Address':
                             {'name':'Line1',
                               'street':'Line2',
                               'street2':'Line3',
                               'city':'City',
                               'state_id':'CountrySubDivisionCode',
                               'country_id':'Country',
                               'zip':'PostalCode',
                               'partner_id':'ShowAs',
                               'type':'Tag',
                               'phone':'Phone',
                               'mobile':'Phone',
                               'fax':'Phone',
                               'email':'Email'
                               },
                           },
                   },
              }

Read more »

Development Team @ OpenERP India

Read more »

Make your future bright @ Tiny ERP India

It is our pleasure to introduce you with Open Source ERP in India which is having its immense application, Tiny ERP Pvt Ltd (“Open ERP”) open source ERP solution provider. Open ERP is one of the most downloaded open source ERP in the world, having large presence in Europe and other parts of western world with around 500 modules and sub modules, it is a complete ERP solution. Its origin is in Belgium and here at Ahmedabad, India we are working as development and support center.

Open ERP is a rich architecture written in Python and back-end is powerful PostgreSQL, which has great flexibility to integrate many application within. Python is one of the most robust and easy to learn scripting language. Open ERP serves for both, web and desktop based client interface. Multiple Library support of Python has added a feather to Open ERP. Open ERP has been successfully integrated with Sugar CRM, Jhoomla and MS Office.

Project Training Program @ Tiny ERP India

We are pleased to announce Project Training Program at our India Office. We are Inviting final semester students for their full time Project work . Training will be provided at Indian Office. We welcome all students, those who are interested and want to make their carrier into Open source Technologies like Python, PostgreSQL, Turbogears, OpenOffice, MySQL, PHP, Linux, and Frameworks based on these Technologies. We never missed any highly skilled people @ Tiny. We are happy to offer jobs to all those brilliant and highly skilled people after 6 months of training period.

Who can apply ?

BE / BTech / BSc
Student should have passed their 10th and 12th with minimum 60% and Aggregate 60% up to the 7th Semester.

MCA/ MSc / MSc IT / MTech / ME
Student should have passed their 10th and 12th with minimum 60% and Bachelor degree with aggregate 60% and Master degree should have at-least 50% without Final Semester.

Students those who have taken the participation in any of the National Level of State Level competition or contest, will be added a plus point.
Students who have passed their semester in Bachelor or Master with more then one attempt are now be applicable for the Entrance Exam.

How to Apply ?

Send your CV to hr [at] tinyerp [dot] co [dot] in. Your Email title should be "Applied for the Project Training - 2010-2011/College Name"

Entrance Exam.

Entrance Exam will be based on the Conceptual Technical Questions, Object Oriented Questions, Data structure and Database, etc..

Project title and working Methodology.

They have to work on the AGILE Methodology during the Training Period, and project Title will be given after the Selection Process.

Project Duration and Certification.

The total project time will be of 6 Months from the Joining date. It will be divided in the 3 milestones, every two month one milestones will be finished. Certificate will be issued after successfully finishing the 2nd milestone. Last and final milestone will be really challenging for all those students who want to continue as a Employee @ Tiny.

Get More Information on Tiny / Open ERP

http://www.openerp.com
http://launchpad.net/openobject
http://www.facebook.com/OpenERP

Want to Organize Seminar on Open Source ??

Send an email to hr [at] tinyerp [dot] co [dot] in, and we will try our best to conduct the Informative seminar on the Open Source and related Technologies.

Schedule

Scheduled will be declared through email only. Send your CV to hr [at] tinyerp [dot] co [dot] in.

Contact Me

Contact me for any queries regarding Project Training Program.

Kim Veria
HR Manager
A-705 Wallstreet-2, Nr Rly Crossing, Ellisbridge,
Ahmedabad - 380 006. Gujarat INDIA.

Phone: +91 79 400 500 48
Email: hr [at] tinyerp [dot] co [dot] in

Read more »

Voucher made periodical reconciliation very easy

Hello !!

You have seen the simplicity of the Sales Receipt, and Sales Payment in my last two videos. It is very easy to working with the Vouchers. Manual and Automatic reconciliation are the ways to manage the periodical reconciliation process. We have also a way to manage bank reconciliation using Bank Statements. In all the cases we have to take care in the reconciliation process that we have to match the correspondence entries to reconcile. The new innovative way which voucher offers is really simple and user friendly. It will automatically reconcile sales, and purchase with the payment, receipt and available credits.

Example:
Advance Payment from Axelor - 200 EUR
Customer Invoice - 200 EUR
Sales Receipt - 200 EUR
Full Outstanding Payment - 200 EUR
Reconcile all Advance payment and Invoices.

Read more »