Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

How to enter direct salary for new hires in EPBCS

edited Jun 6, 2018 12:31PM in Planning 18 comments

Summary

How to enter direct salary for new hires in EPBCS

Content

I have been asked how to do this for a while, so I spent the last few nights and worked on the following solution.  The enhancement is very simple and still allows you to execute driver-based planning as well as the direct salary input.  The attached video demonstrates all of the changes, and the member formula is attached below. 

Link to video.

 

Code Snippet

IF(@ismbr(@relative("YearTotal",0)))
IF("OWP_Status"->"No Property" == [OWP_Status.Active] OR "OWP_Status"->"No Property" == [OWP_Status.Maternity])

/*Is there data in the Manual input Current Yearlevel*/
IF("OWP_Salary Basis"->"BegBalance"->"Salary_Input" <> #MISSING AND "OWP_Value"->"BegBalance"->"Salary_Input"  <>#MISSING)

IF ("OWP_Salary Basis"->"BegBalance"->"Salary_Input"==2 ) /* Weekly */
 "OWP_Expense Amount"=((("OWP_Value"->"BegBalance"->"Salary_Input" )*52)/"NumPeriods")*("OWP_FTE"->"No Property" - "OWP_Reconciled FTE"->"No Property")*"OWP_Partial Payment Factor"->"No Property";
ELSEIF ("OWP_Salary Basis"->"BegBalance"->"Salary_Input"==3) /* Annual */
 "OWP_Expense amount"=(("OWP_Value"->"BegBalance"->"Salary_Input" )* [TimeBalanceSpread])*("OWP_FTE"->"No Property" - "OWP_Reconciled FTE"->"No Property")*"OWP_Partial Payment Factor"->"No Property"; 
ELSEIF ("OWP_Salary Basis"->"BegBalance"->"Salary_Input"==4 ) /* Bi-Weekly */
 "OWP_Expense amount"=((("OWP_Value"->"BegBalance"->"Salary_Input" )*26)*[TimeBalanceSpread])*("OWP_FTE"->"No Property" - "OWP_Reconciled FTE"->"No Property")*"OWP_Partial Payment Factor"->"No Property";
ELSEIF("OWP_Salary Basis"->"BegBalance"->"Salary_Input"==1) /* Hourly */
 "OWP_Expense amount"=((("OWP_Value"->"BegBalance"->"Salary_Input" )*52*"Hours per Week"->"No Property")*[TimeBalanceSpread])*("OWP_FTE"->"No Property" - "OWP_Reconciled FTE"->"No Property")*"OWP_Partial Payment Factor"->"No Property";
ELSEIF("OWP_Salary Basis"->"BegBalance"->"Salary_Input"==5) /* Monthly */
 "OWP_Expense amount"=((("OWP_Value"->"BegBalance"->"Salary_Input"
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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