Posted by
Daniel Carrasco on
Jul 18, 2006; 5:09pm
URL: http://ofbiz.116.s1.nabble.com/Employee-pay-tp140712p140721.html
Thanks all,
I will try to be more explanatory:
I need an application that calculate the salary of an employee, the
salary is made up of several items, they are grouped in two type:
taxable and tax-free, over the taxable items must be apply the
deductions.
The most important deductions are 7% to health system, 12,5 % to
pension system, (depend of the kind of contract) 0,8% to unemployment
insurance, and the Tax.
The process to get the Tax is: the salary minus deductions(health,
pension, unemployment) is searched in with range of a table of factors
and discounts is it, then get the factor, rest the discount and that
is all, there is the tax.
Example
Taxable
Basic salary 1000
Bonos 200
Extra hours 100
1300
Tax-free
Eat allowance 100
Family allowance 100
Deductions
Health 12,50% 162,5 (1300*12,50%)
Pension 7,00% 91 (1300*7%)
Unemployment 0,80% 10,4 (1300*0,8%)
Subtotal 263,9
Taxable-Subtotal 1036,1 (1300-263,9)
Factor (range 2) 155,42 (1036,1*0,15)
Factor-Discount=TAX 55,42 (155,42-100)
TAX 55,42
TOTAL 319,32 (263,9+55,42)
Taxable+Tax-free 1500
Deductions -319,32
TOTAL SALARY 1180,69
Table de Factors and Discounts
Range From To Factor Discount
1 0 500
2 500 999 0,1 50
3 1000 1499 0,15 100
4 1500 1999 0,2 300
NOTE
1) The porcent of health and pension system may be variable, depend
with system you contract.
2) May be more items in Taxable and in Tax-free.
3) The table of factors and discount change every month and It is
provided by the Tax Authority
I agree with BJ, more of this task are accounting. At this moment I
have company, tax authority and employee parties created, I'm trying
to understand and make a relationship between this parties, then I
will create the partie and roles of health system, pension system,
unemployment insurange.
Thanks a lot!!
Daniel
2006/7/17, Si Chen <
[hidden email]>:
> As a wild, wild guess--did you create the roles for your parties
> first, before trying to create a relationship between them?
>
> In general, please furnish more details about what happened. It's
> very hard to figure out what is happening from so far away.
>
>
>
> On Jul 17, 2006, at 10:50 AM, Daniel Carrasco wrote:
>
> > I´m tring to assign a Employee to a Company,I tried do it with
> > relationships, but I couldn´t do it, can you help me??
> >
> > 2006/7/14, Si Chen <
[hidden email]>:
> >>
> >> The TaxAuthority model with all the related entities should allow you
> >> to do that.
> >>
> >>
> >> On Jul 14, 2006, at 1:41 PM, Daniel Carrasco wrote:
> >>
> >> > Thanks, I´m learning how to model the specific country tax on the
> >> > pays of
> >> > employees with those entities
> >> >
> >> >
> >> > 2006/7/14, Si Chen <
[hidden email]>:
> >> >>
> >> >> Don't add a new field. Use the PartyTaxAuthInfo entity instead.
> >> >>
> >> >>
> >> >> On Jul 14, 2006, at 12:21 PM, Daniel Carrasco wrote:
> >> >>
> >> >> > Hi all
> >> >> >
> >> >> > I am trying to develop a pay application, but I need to add a
> >> new
> >> >> > fields to
> >> >> > some entities, for example the company must have an ID
> >> assigned by
> >> >> > the TAX
> >> >> > authority, how can I make this?. I think that I should make a
> >> new
> >> >> > entity or
> >> >> > view entity that supports It. Is it right?
> >> >> >
> >> >> > Thanks a lot!
> >> >> >
> >> >> > Daniel
> >> >>
> >> >>
> >>
> >>
>
>