Infotype 0014 Amount proration until year-end from record start date

[former_member816992]

Hi Experts,

Infotype 0014 record maintained with End Date 31st Dec 2022 from any Start Date in the same year. Now, we need to prorate the amount from record Start Date to 31st Dec 2022 (year end) and should process that deduction amount only in that month only i.e., one month only.

Please help me to develop the logic with the above requirement.

[BalaAP]

Hi, I am adding to expert views of Sikindar/Vivek. You can try to create a custom payroll function or operation to return "number of days" as per your formula and use this in a custom PCR to prorate. As per my awareness, there is no standard operations are available to get this value related to PCR.

[sikindar_a]

Murali

it means we are asking the system to forecat the deduction amount in the first month of payroll which i am afraid it cannot be done

1 What in case if the deduction amount is greater than amount which needs to be paid to the employee

2. what in case if employee is mid moth entry and exit along with unpaid absence

3. and if i am not wrong the amount which needs to be deducted should happen month wise as per the data of proration in that case we cannot forecast the deduction amount

we can pass the amount to CRT and from CRT we can pass this to payslip (but i dont recommend this request to re consider the following scenario)

[former_member816992]

Hi Sikindar,

Thank you for your inputs. We will look into theses cases.

Is there anyway to get the remaining calendar days from IT0014 record start date to until end of the year?

Appreciate your help.

[VivekPalanivel]

ok, i am not sure we can achieve this without development. Will be keen to know if anyone else can give solution as i had similar issue in another project and then I requested them to maintain the amount and number (no.of days) in the infotype for that wage type to allow me to do the calculation.

[VivekPalanivel]

Use PRATE functionality. Check the below link for guideliness

https://blogs.sap.com/2016/08/04/prate-functionality-recurring-payments-deductions/

[former_member816992]

Hi Vivek,

Thank you for the info. Using PRATE function we can do the proration only for one month. My requirement is to prorate until end of the year.

Formula = Amount maintained in IT0014 X Total calendar days from IT0014 Start Date to 31st Dec yyyy / Total Calendar days in the year.