Archive for the ‘Eclipse’ Category

Inno8Tech (Outsource Project) Success Story in OpenERP v6

March 2, 2012 3 comments
Project :
Outsource Project (Inno8Tech)
Project Assigned By:
Project Completed  By:
Mohsin Yaseen and Waqas Pitafi
Software Tools Used:
OpenERP v6
Overview of Modules Developed and Customized in OpenERP:
Customized Modules are; 
-Finance, Sale and Purchase
-HR, Expense, Contract, Payroll, Attendance, Time Sheet and Recruitment 
-Project Management
Developed Modules are; 
-Project based Employee Advances & Recovery, Integration with invoice (finance), approval workflow
-Email and sms alerts against project completion, task assignment, task completion, project based advance requisition, advance approval and advance rejection. 

Project: Police Information System in OpenERP v6

March 1, 2012 Leave a comment
Project :
Police information System
Project Assigned By:
Police Line District Mardan, NWFP Pakistan
Project Completed  By:
Mohsin Yaseen
Software Tools Used:
OpenERP v6
Overview of Modules Developed in OpenERP for Mardan Police Line:
This Module is developed for Purpose of Police Personal Evaluation at Mardan District of NWFP Pakistan
This Module includes,
– Officer Personal Informations,
– Current Posting and Current Rank
– History of All Posting and Promotion according to time
– Courses Passed during career and gain points
– Good Points assigned by senior and its all history of officer
– Different punishments given by senior officer and its bad points
– Leave Qouta, Earned leave history, Medical Leave History and Casual Leave History
– Record complaints against officer from differ persons, These complaints will only read by senior officer.
– Promotion and Posting Policy enforcement
– Retirement and experience in career
– Reports:
Strength of Police Station
Posting Wise Officer Selection
Course Assignment wise Officer Selection
Officer Selection by current posting tenure
Officer Selction by posting in home Police Station or circles

OpenERP Training in Pakistan from NUST, Islamabad (Non OpenERP Partner)

February 9, 2012 8 comments

Dear Viewers,

NUST offering OpenERP training. NUST is one of the ‘TOP 100 UNIVERSITIES IN ASIA’ and one of the best educational industry in Pakistan. NUST have 16-18 schools of different areas in Pakistan including capital cities.

This workshop has been designed for both IT Professionals and people from Management background who would like to explore how HRM can be effectively managed through an open source ERP solution. The workshop is also beneficial for IT and Management students to know about state of the art in ERP solutions deployment and its related challenges.

Please Follow the details from given advertisement.


Contact With:


A center of excellence for quality education and research

Sector H-12 Islamabad Tel: 051 9085 2400 Fax: 051 8317363

HRDC Survey(Statistical Analysis) Project in OpenERP

July 6, 2011 5 comments
Project :
Third Party Validation of Performance of PTCs of Khyber Pakhtoonkhwa Pakistan
Project Assigned By:
Education Department of Khyber Pakhtoonkhwa Pakistan
Project Assigned To:
HRDC, IMSciences Peshawar Pakistan
Project Field Work Domain:
All Schools of Khyber Pakhtoonkhwa Pakistan (No of Sample Schools 5400)
Software for Statistical Analysis and Its Reporting:
First Time OpenEPR used as Statistical Analysis Software and for its Statistical Reporting
Software Tools Used:
OpenERP Framework, Python, Postgresql, PDF & MSExcel and Linux platform as OS
First Time OpenERP for Statistical Analysis and Its Reporting:
First Time OpenERP is used for strong statistical analysis and its reporting.  Approximately 89 users entered 5400 schools data using OpenERP interface from different terminals.Each school have 5 different survey forms i.e. Auditors Form, EDO Form, Secretary Form and Member Council Form.Each form has 40-50 different questions representing school different area of functionality, Physical Infrastructure, Financial Position, Teacher & Students Attendance, Parents & Teachers meeting, Meeting Agenda & its implementation rate  and much more.
Overview of Modules Developed in OpenERP for Statistical Analysis
 There are two modules developed for this project
  1. Hrdc
  2. Hrdc_reporting
  • Module hrdc includes objects, tree views, forms views, update data files, wizards, menus and security rights files.
  • Module hrdc_reporting includes 15 different statistical reports (including summary and details). These reports first print in pdf and we also export these report in MSExcel for report writing purpose.
OpenERP Developed Module Demonstration for Statistical Analysis 
•Module hrdc_reporting includes summary and detail (district level) reports, these reports extract from 5400 schools information ( each school have 4 different survey forms).
•These reports includes heavy statistical calculation and shows the situation of different area of functionality, Physical Infrastructure, Financial Position, Teacher & Students Attendance, Parents & Teachers meeting, Meeting Agenda & its implementation rate  and much more.
Statistical Reports in MSExcel 
•These all reports are also print in excel format for final report writing purpose.
•Final report presents to Education Department of Khyber Pakhtoonkhwa Pakistan.
HRDC Survey Project in OpenERP 1
HRDC Survey Project in OpenERP 2
HRDC Survey Project in OpenERP 3

Enter a Bank statement in Openerp and Its Bank Reconciliation with Invoices:

December 17, 2010 1 comment

I assume that viewer of this post have studied my first and second posts, I will continue using same example I have used in mention two post.

Previous example overview:

List of Suppliers partners: Ahmad, Asif, Dawood & Co, Naeem and Saleem & Co.

List of Customers partners: Crown & Co, Naseem & Co, Rafiq & Sons and Rizwan & Co

we have enter some supplier invoice using supplier partners, and similarly some customers invoices using some customers partners. Above invoices both of supplier and customers were based on accrual. The invoices status was open.

After these accrual basis accounting impact we receipt Rs. 3000 and Rs. 6000 from two customers Naseem & Co and Rafiq & Sons respectively in Bank Acc 123. we reconcile receipt voucher with customers invoices. The these two customers invoice status becomes done. Similarly we also make payment of Rs. 2000, Rs. 2500 and Rs. 1000 to our supplier Asif, Dawood & Co and Naeem respectively. After reconciliation the status of these three supplier invoice were also becomes done.

This was the preview of example we used;

Following are the some snaps , so that you can understand the account balances, partner balances, invoices status (open or done). After these snaps we will continue our topic.

Snap of account balances:

Trial Balance

Read more…

Hire Purchase: Module Development example in openerp

December 14, 2010 20 comments

In this tutorial, I will share how module develops in openerp. First I will explain the functionality of hire purchase (what we are going to develop), second I will develop hire purchase module in openerp. A simple explanation of hire purchase module is sale of goods in installment. In my example, I will ignore the interest portion of hire purchase. I just spread the price of good in number of monthly installment. I can say that, this module is a demo version of hire purchased without installment. In future I will extend this module with interest. In this tutorial I will focus on step by step development of module in openerp.
What hire purchase is read out the wiki about hire purchase, for detail of hire purchase also read wikieducator.

In this tutorial I will cover; how to create openerp objects (in .py file), interaction with object using openerp views (tree and form), openerp wizards and menuitem.

Step 1:

Create the following files and folders.

a. Folder having named ‘hirepurchase’ and 2nd folder having name ‘wizard’ in ‘hirepurchase’ folder.

b. Create the files in hirepurchase folder, i.e.,, hirepurchase_view.xml and

c. Create the files in wizard folder, i.e. and

File structure: hirepurchase folder contains one folder (wizard) and four files (,, hirepurchase_view.xml and Wizard folder contains two files ( and

Read more…

Creating Partners, Products, Chart of Accounts, Invoices(Customers and Suppliers), Partner Balances in OpenERP

November 9, 2010 2 comments

In this tutorial i will show how to create partner with their account, Products (for Selling and Purchases), Chart of Accounts of a company, Customer Invoices, Supplier Invoices, Partner Balances etc and mush more.

Step 1: Create following chart of account; if you don’t know how to create accounts in openerp follow the post (

Chart of Account

Chart of Account

Read more…