You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Payroll Balance issue

Received Response
edited Sep 5, 2020 12:33AM in Payroll and Global Payroll Interface (GPI) 4 comments


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.


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!