Skip to Content
0
Former Member
Nov 24, 2009 at 12:13 PM

Payroll rule with a maximum limit

31 Views

Hi Payroll gurus

I have a request that needs your help.

1. I created Wagetype 1000 u201CTyresu201D needs to be captured on IT15 for Tyres,and

another one for WT1001 "Maintenance"

2. A recurring wagetype (IT14) u201CTyres cumulativeu201D was created to cumulate the tyres (new WT) component of the fleetcard usage. When the tyres component reaches the maximum limit of R15 000 for the year, the amount exceeded should be deducted from the employeeu2019s income as a normal deduction, whilst the value of the maintenance new WT should be reduced with the amount exceeded. The new WT should be added to the recurring Tyres cumulative wagetype as well as the recurring Maintenance cumulative wagetype (See Part B)

Part B

1. A recurring wagetype (IT14) u201CMaintenance cumulativeu201D was created to cumulate the maintenance (WT 1001) as well as the tyres (new WT) component of the fleetcard usage. When the maintenance component reaches the maximum limit of R 25000 for the year, the amount exceeded should be deducted from the employeeu2019s income as a normal deduction, whilst the value of the maintenance WT 1001 should be reduced with the amount exceeded.

Part C

2. An additional wagetype (IT15) needs to be created to deduct the excess from the employeeu2019s salary. The description should be u201CFleetcard limitu201C.

General

The cumulative wagetypes on IT14 should be created programmatically once a Maintenance WT 1001 wagetype is uploaded for a ES A or B band job for the first time and delimit 30 June of each year. 1 July a new cumulative wagetype should start running (Might need to run a program to create the wagetype).

Any Ideas how i can do this in the system?

Kind Regards