Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Artificial Intelligence
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Property Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

Need Unpaid Leave Salary Calculation

Subscribe

Get notified when there's activity on this post

This question has been flagged
hr_payroll
7 Replies
24294 Views
Avatar
sridhar

How to calculate Unpaid Leave, it is not reducing in the Net salary, i also tried in the salary rule for the following formula

result=(contract.wage/31)*worked_days.Unpaid.number_of_days

I put this calculation but I get server error. anybody help me.

Thanks & Regards Sridharan G Chennai

2
Avatar
Discard
Avatar
Hilar Andikkadavath
Best Answer

Hi, You can check this blog by Cybrosys  about Unpaid leaves and its payslip calculations here

2
Avatar
Discard
ANSU MARY JACOB

not getting the output getting error

Avatar
Maath
Best Answer

In additional to '@Mustufa Rangwala' solution you need to add condition to avoid error when employee do not have any unpaid leave I was explain that at this link:

https://accounts.openerp.com/forum/Help-1/question/16131?answer=16132#post-id-16132

2
Avatar
Discard
Atul Kumar jain

How can we calculate Overtime in openerp

Avatar
sengottuvel
Best Answer

Hi...My requirement is result = total wage will be divided into total working days of month * total present days of employee of this month..I have a own modules and it contains total working day and total present of month for each employee..Kindly tell me the solution to achieve my result

0
Avatar
Discard
Avatar
Debashis Das
Best Answer

for Basic LWP I have set condition "result=worked_days.Unpaid and worked_days.Unpaid.number_of_days or False" and computation "result = -(contract.wage *.4)/((worked_days.Unpaid.number_of_days+worked_days.WORK100.number_of_days) * worked_days.Unpaid.number_of_days)"...its works fine in Payslip...but through Batch its reflect nothing...any suggestion ?

0
Avatar
Discard
sengottuvel

Hi...My requirement is result = total wage will be divided into total working days of month * total present days of employee of this month..I have a own modules and it contains total working day and total present of month for each employee..Kindly tell me the solution to achieve my result

Avatar
Mustufa Rangwala (mra)
Best Answer

First of all you have to create Leave type called "Unpaid" and then create Leave request for employee and approve it.

After creating leave type and leave request you have to create salary rule and add that rule on employee salary structure..

Now create Payslip it will come overthere.

Regards, Mustufa Rangwala

0
Avatar
Discard
sridhar
Author

Thanks For Reply Same procedure i already i followed but yet i didn't get result "result=(contract.wage/31)*worked_days.Unpaid.number_of_days" this code is correct or not i'm using OpenERP 7 , help me. Thanks & Regards Sridharan G Chennai

Maath

@Mustufa Rangwala the code result=(contract.wage/31)*worked_days.Unpaid.number_of_days calculate the total of Unpaid leaves but we need total at that month and there is error when employee do not have an Unpaid leave , how to solve this problems , Or if we can build new module to calculate that , Please help ....

Ajmal

@Maath I am also having the same issue.. i think we can have a python condition check because it will be always "TRUE" so it wont allow if they doesnt have unpaid leaves.. i tried that condition also but it failed because of having "Unpaid" object

Maath

@Ajmal , Oky , and what about the total leaves for each month I try with payslip Bach and every thing is Oky and there is no error

sridhar
Author

@Maath Unpaid rules added in Salary Structure for an employee means, it didn't accept batch concept same error Python code Error Plese check it my DB

Raminder Pal Singh

@all : How to deduct the salary of the employee if he is absent without taking any leaves.?? Plz Help

Raminder Pal Singh

@all: Error when using this python code if employee dont have any leave. Is there a method to solve this.??

Maath

@Raminder Pal Singh I think there is may be error in the system , But when I create a Bach for salary then there is no error , I am also need for deduct the salary of the employee if he is absent without taking any leaves , I think we should create new module .. if you want to share our work and contact on skype I think there is other developer want to do the same .

Raminder Pal Singh

@maath the error remains when we creates salary batch.

Maath

@Raminder Pal Singh I think there is may be error in the system , I think we should create new module .. if you want to share the work then will contact on skype

Raminder Pal Singh

@maath I am not a python programmer. but we can contact to discuss this issue. You can mail me ur skype id on rps023@gmail.com

Maath

@Raminder Pal Singh Finally her the solution if help you then vote Up OK? http://help.openerp.com/question/16131/unpaid-leaves-deduction-not-working/?answer=16132#post-id-16132

Maath

@Ajmal the problem finally solved I am adding new answer for this question .. vote up if helped you

Raminder Pal Singh

@maath thanks a lot. this works FINALLY

Ajmal

@maath Thank you .. It Works !!

Maath

@Ajmal Can U Vote up may question and answer too , it is take more time to solve and if you search in all sites will not founded ! I found it in French Site

Debashis Das

for Basic LWP I have set condition "result=worked_days.Unpaid and worked_days.Unpaid.number_of_days or False" and computation "result = -(contract.wage *.4)/((worked_days.Unpaid.number_of_days+worked_days.WORK100.number_of_days) * worked_days.Unpaid.number_of_days)"...its works fine in Payslip...but through Batch its reflect nothing...any suggestion ?

Avatar
sridhar
Author Best Answer

I Got a Answer for this problem but not updating in the gross amount. "result=-(contract.wage/31)*worked_days.Unpaid.number_of_days"

Sridharan Chennai

-1
Avatar
Discard
Atul Kumar jain

How can we calculate Overtime in openerp

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
【GUIA 24-7】¿Cómo llamar a LATAM desde El Salvador?
hr_payroll
Avatar
0
Jun 26
40
problem with work entries in hr.payroll
hr_payroll
Avatar
0
May 22
4905
Is it possible to add a custom button to payslips tree view Solved
hr_payroll
Avatar
Avatar
1
May 22
3650
Intégration secrétaria social
hr_payroll
Avatar
1
Jan 22
3421
How to set input in salary rule Solved
hr_payroll
Avatar
Avatar
1
Oct 21
16674
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk Slovenščina Español (América Latina) Español Svenska ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now