How read percentge/Interest rate number from IT0014

[Former Member]

Hi,

Requirment : Wagetype amount (Out put) = Percentge or Interest rate number from IT0014 x Number of Calendar Days of the Month/365 Calendar days

How to read Percentge or Interest rate number from IT0014 for calculation & Number of Calendar Days of the Month/365 Calendar days?

[former_member193210]

For the number of Calendar Days in the month, the answer depends on your Payroll Period;

  - if you have Monthly Payroll Periods, you should be able to get that information from the Partial Period Parameters, as mentioned by Venkatesh Yadav.

  - if your Payroll Periods have an other frequency (Weekly/bi-weekly/Semi-monthly), then you should be able to generate an Information WT with the appropriate value, through Time Evaluation.

As for your WT on IT0014, look at your Payroll Schema and find Function P0014 (in your "Import additional payments/deductions" sub-schema, possibly xAP0), then look at the pcr that is linked to that Function.  Function P0014 will "read" the employee's IT0014 and the pcr will process these entries.

So depending in what field the percentage is entered in IT0014 (Number or Amount?), then the appropriate Payroll Operation (NUM or AMT) will be used to process it.

What are the Input Values generated by Function P0014 ?

What is the processing happening in the pcr for the "Interest Rate" WT ?

What are the entries in the Output Table after Function P0014 processed the Input through the pcr ?

[Former Member]

Reading "Number/Unit" field from IT0014 as Interest percentage to calulate loan interest amount (Loan balance from IT0045)

[former_member193210]

The "Number/Unit" field from IT0014 should be transfered to the NUM field of the Payroll WT through Payroll Function P0014.

The Loan Balance WT probably has a value in it's AMT field.

[former_member193210]

Try a Payroll Simulation, with the "Display log" box checked, for one employee with a loan and an IT0014 with the Interest % number, and drill down into the log until you find Function P0014.

Double clic on that function to see the input values (from IT0014), the processing (in the pcr associated to this function) and the output (into the InputTable).

You should then be able to see the Interest Rate WT in the Input Table with the appropriate Number.

[venkateshorusu]

We can query number of a wage type.

Operation NUM can be used to query number of wage type.

Operation TKSOLL can be used to Query number of calendar days of the month accordingly we can incorporate the logic in system.

Regards

Venkatesh

[Former Member]

Hi,

I did the same,But that PCR i have to insert that PCR before IT0014 function because of that NUM= **** not available in IT table

How to get NUM= **** in to IT table before my PCR process.