Payroll Balance issue
Content
I need to fetch balance value as of particular date in payroll fast formula i.e. fetch YTD value of a balance as on 31-Mar-2020 whereas current payroll run is Jun 2020.
So there are various approach I tried.
1) Call another payroll formula, set contexts (Payroll_rel_action_id) of previous run and fetch balance value from DBI (EMP_SALARY_ASG_YTD). - Did not work out as we can not change context value of payroll_rel__action_id in payroll fast formula.
2) by creating a value set and Call pay_balance_package by passing Defined_balance_id, calc_breakdown_id, Payroll_rel_action_id . pass this value as parameter from payroll fast formula. but in this case, parameters to be passed in From clause of value set instead of where clause.
Tagged:
0