PCR to calculate amount based on Number entered in WT in IT0015

[former_member585582]

Hi experts

please need your help to write PCR or if it possible by configuration only.

the requirements is as below:

In IT0015 a WT 2000 is created to hold Number of hours for the late attendances.

and based on IT0008 we have ( Basic - Housing - Transportation - other allowances)

Note: the base to calculate the late attendance is only on (Basic - Housing - transportation)

so as example:
Employee 1 ( Basic is 1000 SAR, Housing is 1000 SAR, Transportation is 1000 SAR, other allowances is 2000 SAR)

-----------------

in Feb: in IT0015 WT 2000 was maintained (10 hours)

so I need in schema to be calculated like following:

our base to calculate the late attendance is (1000+1000+1000=3000SAR)

Feb month is 28 days, so the daily rate in Feb is 3000/28 day = 107.14 SAR

so the Hourly rate will be 107.14 / 8 hours = 13.39 SAR

So WT 2000 should be in Feb = 10 hours * 13.39 = 133.92 SAR

---------------

in March: in IT0015 WT 2000 was maintained (10 hours)

so I need in schema to be calculated like following:

our base to calculate the late attendance is (1000+1000+1000=3000SAR)

March month is 31 days, so the daily rate in March is 3000/31 day = 96.77 SAR

so the Hourly rate will be 96.77 / 8 hours = 12.09 SAR

So WT 2000 should be in March= 10 hours * 12.09 = 120.96 SAR

-------------------------

Note: number of hours per day is fixed as 8 hours.

Note: every month the rate will be different as the number of days not fixed

[former_member193210]

For all Payroll related queries, it is always preferable to mention the Country Code, since that could have an impact on the reply.

Do a Payroll Simulation for one employee, with the "Display log" box checked, and drill down into that log.

Look for the Partial Period Parameters (Payroll Function PARTT) and identify the parameter that always shows the number of days in the month (even if the employee has an unpaid absence).

Use a Custom Cumulator (/190 to /199) to cumulate all Amounts that should be used for your calculation (Basic - Housing - transportation), or create a pcr to process these WTs and generate an Information WT or a temporary variable.

Create a Custom PCR to make the calculation, and insert it in your Payroll Schema somewhere after Function P0015.

[sikindar_a]

You need to write 2 PCRs

1. To Determine Hourly Rate Monthly

2. Convert the hourly Rate into Amount in second PCR under function P00015