UBS Payroll Software » Housekeeping

ID #1375

Allowance Formula

Description

The solution below shows  the  way of setting the  following variable allowance (assuming the allowance amount is varying for employees):

 

Scenario:

Full allowance (e.g.  RM500 for an employee) if no absent and NPL

 

With absent/NPL, allowance should be reduced accordingly at the  rate  of 500/29 for each  day of

NPL/absent

  

Solution 

1.    Go      to      Housekeeping—Setup—Tables            Maintenance—Allowance     Table,        key     in allowance  description,  click  “Next“,  “Next“,  at  the  Formula  field  for  the  row  where  the allowance is added, key in the  following formula:

IIF(RATTN=O, AW, IIF(RATTN—=1, AW — (AW/29)*NPL,O)) 

  

2.    Click “OK“ to “save“ the record.  

 

3.    Go  to  Personnel—Add/Update  Employees,  click  Allowance/Deduction  tab,  key  in allowance amount for individual employee

 

 

Tags: Allowance Formula

Related entries:

Last update: 2010-11-17 04:11
Author: Noor Diyana
Revision: 1.0

Digg it! Share on Facebook Print this record Send FAQ to a friend Show this as PDF file
Propose a translation for Propose a translation for
Please rate this FAQ:

Average rating: 0 (0 Votes)

completely useless 1 2 3 4 5 most valuable

You cannot comment on this entry